Detecting Duplicate Cells Using Info From The List

Feb 5, 2014

I have a sheet containing lots of information (lists of flight information to and from all countries). So entries are duplicated in the entire sheet. For example LITHUANIA, USA, CHINA... appears lots of times. I only need to highlight particular countries.

I would just use conditional formatting, but maybe there is a quicker way to do that?

So there is a list of 50 countries in one sheet and in another sheet I got all the info. I need those 50 countries from the list to be highlighted in the info sheet (sheet has many columns and rows).

View 6 Replies


Detecting Same Value In 3 Cells

Mar 11, 2009

Would like to detect same value in 3 cells.

Q 16, R 16, S 16

If there is a same value appearing in two of the three cells.

View 11 Replies View Related

VBA Delete Duplicate, Yet Retain Info From Adjacent Cell

Jul 16, 2007

I have a VBA macro that deletes duplicates rows, however I would like to retain the information from the duplicate row, just before deleting it. For instance, If I have these two columns: ....

View 9 Replies View Related

Detecting If A Cell In Range Of Cells Has Been Modified

Jun 11, 2013

I want to detect if a cell within a range of cell has been modified

A range of cell is named "ChartData" =Data_In_Out!$E$15:$E$29

I understand how to react for a single cell, but not with a group of cells


Sub Worksheet_Change(ByVal Target As Range)
On Error Resume Next
If Target.Address = Range("LastBarString").Address Then
Application.EnableEvents = False
end if

View 2 Replies View Related

Finding Duplicate And Or Similar Info Across Columns And Highlight (names And Addresses)

Jan 29, 2014

Magazine subscription list. How to highlight the customers that are already in the sheet if enter them again (renewal). Our list is like so....

ColA ColB ColC ColD ColE ColF
First Last 123 Ave City State Zip

Is there a way to highlight the row if the info on ColA, ColB, ColE, and ColF all match? Sometimes the Street info is abbreviated or entered PO Box instread of P.O. Box and they wind up on the list a second time.

View 5 Replies View Related

Delete Duplicate Cells Or Rows With A Duplicate Cell

Nov 1, 2007

I feel as though I have spent enough time searching the previous posts to ask this question.

I have a 4 column sheet, column B has many cells with identical data. I want to delete all the rows that that have duplicate data in column B.

COLUMN A= Car Makers
COLUMN B= Models of cars
COLUMN C= color
COLUMN D= owner

I want to end up with rows that each contain unique info in COLUMN B.

View 9 Replies View Related

Auto Input Info From A List

Feb 10, 2009

I am having difficulty with this formula. In the attached spreadsheet. I want to just input the item number in column A, manually. From there I want it to take the information from the hidden list and fill in the rest of the fields. Example. I input in A4-2664, I want it to search the list for 2664 and take the corrisponding information. It would take the information from M5, O5, and Q5 and place that in C4, E4, G4. I place spaces in the hidden list to make the format the same.

View 2 Replies View Related

Dropdown List Created From 2 Columns Of Info?

Mar 24, 2014

I have a list of names in column B, I can easily put this into a list

I also have a different list of names in Column C

These two list are feeding from sharepoint and are updated regularly

What I want to do is create a drop down list that will list all the names in Column B and Column C, while keeping the initial lists in there separate columns

I have been trying to find a formula to lookup both columns and return all the names into another column (E) using the formula below


the plan been to just put column E into my drop down list, but this formula is returning alot of blanks between Column B + C in the list (there might be 100 names in column B and only 30 in column C)

To try remove the blanks I tried another formula pulling the info into Column F,


But while this did remove the blanks (about 500 blanks) it left me with about 70 "0" errors.

View 3 Replies View Related

Need To Pull Out Specific Info From Mixed List

Apr 3, 2014

I pulled a report into excel that lists staff details and workgroups that they have access to. There are nearly 8000 staff who can have anywhere from 0 to 120 workgroups.

The workgroups are listed with the staff details in the following format:

SurnameForenamePost Title183860314040|188778743040|261226948048|584865373040|088365861041
SurnameForenamePost Title695416612049|751836367043|430463930049|461208099048|488798547045|723225723045|183860314040|472108996043
SurnameForenamePost Title177448555041|315136549047|400323457046

With the whole list appearing in one cell and not in numerical order.

I need to pull out a list for each workgroup, with all the staff who have access.

Even if there was a way I could separate out the workgroups and get them to line up.

View 2 Replies View Related

Limit Drop Down List And Linking To Other Info

Feb 1, 2006

I have set up a spreadsheet that requires info to be inputted into cells. I have created drop down lists in the cells to only allow certain information to be inputted.

Allow user to use a drop down list and pick the appropriate entry, then have another drop down list in the adjacent cell that only contains items that correspond to what the first drop down entry was (i.e. company name in first drop down box, adjacent cell drop down list only contains parts made for that company). Then I would like the next column to contain the pricing of the item that was chosen in the previous cell's drop down box. Ideally, this cell would be populated automatically depending on the part chosen for the company. I am trying to create a log of parts shipped and total amount shipped.

View 13 Replies View Related

Getting Info From A List And Input Then Transferring Data

Mar 24, 2007

a user inputs the drawing number and revision in a box on the first sheet in the workbook. Once that is done, the user then selects the type of drawing from the drop-down menu, once "Submit" is clicked it takes that info and puts the information in the next available cell for the other worksheets (if that worksheet calls out for that certain part).

I've been having trouble trying to figure out how to be able to accomplish this task.

If you have any ideas, that'd be great.

I've attached a basic worksheet I drew up to give you a better idea of what I'm looking to do.

Forgot to mention that there are totals involved! The "destination" worksheets have set totals for each drawing type, so what also has to be taken into consideration is that the specific drawing needs to have the correct total beside it. I created a "Totals" worksheet to show what drawings are what totals for each cell. Realizing this may always change or be updated, I created a seperate worksheet to pull all the numbers off of. I thought this might be easier rather than going in and changing the coding each time.

View 9 Replies View Related

Dropdown List In Spreadsheet Which Combine Info From Two Columns

Oct 24, 2012

I'm trying to have a drop down list in a spreadsheet which combines the info from two columns.

For example:

1 John 29
2 Sandy 40, etc

And the drop down list turns into

John 29
Sandy 40

Is this possible?

View 1 Replies View Related

Compiling Info From Different Sources To Make A Mailing List

Aug 22, 2013

I do not know what function will do what I need. I am compiling info from different sources to make a mailing list. Basically it boils down to the following. Sheet 1 has Names and Parcel Numbers, sheet 2 has Parcel Numbers and Addresses. I am trying to combine it in a way that I have names and addresses on the same sheet.

View 2 Replies View Related

Excel 2007 :: How To Combine Info From Columns Into 1 List

Oct 4, 2011

is there a way to combine the info from several columns into 1 list?

All of my columns have information in rows 1-20, but I want it all to automatically combine into a list in column B on a new sheet.

This is Excel 2007

View 9 Replies View Related

Excel 2007 :: Putting Info Together To Make A List

Apr 17, 2014

If I have a set of number in a column. a1-12345 a7-12356 and a20-15487. how can I get them to show like this in columns Z.


I am use 2007 and my data go down to cell 40000 in column A:A

View 7 Replies View Related

Fill Info In Sheet One And Have Same Info Appear In All Sheets That Follow

May 12, 2014

I would like to fill in a a form on page /sheet one and have the same info on every sheet that follows is it possible?

View 3 Replies View Related

How To Fill Vertical Columns With Info From Horizontal Info

Aug 22, 2014

I have attached a spreadsheet and I am trying to capture the info in lines 2,7,12,17 and return the info into column d,e,f,g

The info in these columns at present has been manually entered but I am sure it could be automated.

OOL Roster Final 18-31Aug14.xlsx

View 1 Replies View Related

List Duplicate List Values

Aug 24, 2008

I have an excel spreadsheet that is several thousand entries long. There are cases in which duplicate entries will spring up on that list.

What I want to do is come up with a formula that will find the first duplicate entry in that list and then display that entry in cell on another worksheet. If it was at all possible, I would also like to have the row that the duplicate entry is contained on display as well, in a different cell of course.

I do not want to highlight them using conditional formatting since I have used that to perform other tasks on that sheet and that wouldn't display the entries in a different cell for me, and I would prefer not to use a macro to perform this function it that was at all avoidable.

View 7 Replies View Related

Copy Four Cells Of Info From One Tab To Another

Mar 9, 2013

I want to copy Four Cells of info from one tab to another if the value of a cell is a specific value is this possible?

View 2 Replies View Related

Getting Equation To Apply To Cells Only With Info In

Jul 30, 2014

Any way I can get an equation to only apply to cells with information in? E.g. I have two columns, one with 'disposal dates' in and the other with 'extended disposal dates'. I would like to get the difference between them (Extended disposal dates- disposal dates) however not all of them have an extended disposal date, therefore some cells display as '#VALUE!' because its calculating the disposal date-blank cell....

View 3 Replies View Related

How To Split Info In Cells / Column

Feb 13, 2012

I have data that I've converted from a different source, and the formatting doesn't always come out as I'd like it. For example, I have data that has two different values, and I need to split them into different columns. Is there an easy/quick way to do this?

15* 27016* 1324517* 2086518* 24943

View 5 Replies View Related

Separating Info From One Cell Into 2 Different Cells

Aug 28, 2007

Whenever I get information from or from my job and put it into excel all the information seems to go in one cell and numerous rows. (I think its b/c I am putting information that isnt' meant to be in excel and forcing it to open up there.)

For Example in cell A1 I will have
"AIG , AMER INTL GROUP I , 66.08 , 1:16pm , 169.455B , 16.736 , 2.01 , 9.47 , 0.78"

Cell A2 I will have
GOOG , GOOGLE , 508.9 , 1:21pm , 158.845B , 22.361 , 17.511 , 26.29 , 1

What I want to see is cell A1 as AIG and cell B1 as 66.08 and cell A2 - GOOG and cell B2 508.9. I don't even want the rest of the stuff.

Is there any way or formula I can use to just pull the information out of cell and have it separated for me?

View 11 Replies View Related

Insert The Info From The User Form Into Certain Cells

Sep 4, 2008

I have a very simple userform that has name, address, phone, etc.

I want the command button the insert the info from the user form into certain cells in my spreadsheet then clear the info out of the userform and close it.

View 13 Replies View Related

Input Box Info Pasted Into Range Of Cells

May 29, 2009

I have this code going for a sheet i've been working on, but thers only one thing I can't figure out how to do.

I want it to take the text that was entered in the "Grid Date" input box and stick it in the bottom 10 cells (plus one space). IE - if A14 is the last used cell, paste it into A16 through A26.

View 2 Replies View Related

Passing Textbox Info To Cells From UserForm

Jan 20, 2012

When a user selects Yes from a drop down list in a particular cell a UserForm pops up to request further information.

How can I pass this information to the cells to the right of the "Yes" cell.

E.G. Cell H6 contains Yes, the UserForm info is to be passed to I6 and J6.

This needs to happen on each row everytime the user selects "Yes" -

Yes in H7, Userform info to I7 and J7 etc etc.

View 1 Replies View Related

Variables That Tell Other Cells To Pick Info From The Next Sheet

Jan 12, 2007

I have a blank log template on one sheet, On this I need to be able to enter two variables that tell other cells to pick info from the next sheet. The two variables being 1) Date and 2) DAY SHIFT or NIGHT SHIFT.

On the next sheet is an archive of data running in columns with the dates in row1 and the denoted shift (day or night) in row 2. The rest of the relevant info is in the columns below each date and shift

What formula would I use so that the log template cells fill with data from the archive when the date cell and shift cell data is entered.

View 9 Replies View Related

Deleting Rows Based On Info In Certain Cells

Nov 29, 2009

I have a column that has different SIC codes in it (00045, 00046, etc). I would like to set up a macro or filter that would take cells in this column and delete each row that contains a certain code that I don't want.

Example, I want to delete all the rows with SIC codes that have 00345, 00873, 00145, etc in a particular cell. I would like a macro that would look at each cell in the column and delete the rows that I don't want.

View 9 Replies View Related

Search Using Info From Two Cells To Give Corresponding Answer From Different Sheet

Feb 14, 2014

see the attached 'Example' excel sheet.

I'm not the best at explaining, but I think that the excel sheet is pretty straight forward.

In Sheet2, cells C3 and D3 are manually entered by the user. I am looking for a formula for B3 that will take the information entered into C3 and D3, find the row in Sheet1 in which column C=Sheet2!C3 and column D=Sheet2!D3, and give the unique corresponding result from Sheet 1 for that row in column B .

So, for example,
if C3=A and D3=102, then the result would be 444
if C3=A and D3=104, then the result would be 111
if C3=B and D3=102, then the result would be 111

The combination of C3 and D3 is always unique and will never have more than one possible result in column B of Sheet1.

View 5 Replies View Related

Conditional Formatting For Cells Which Have Multiple Date Info

Feb 10, 2009

I need for coloring "Expected Delivery Date" column corresponding with "Control Date" and "Control Result. But I want to correspond with the cells' last content of "Control Date" and "Control Result" But first of all I want "Control Date" should be flashed 10 days ago of it's date... (it's already done on my excel file)

I want "Expected Delivery Date" as green when
- "Expected Delivery Date" =< "Control Date" and "Control Result" =Y (Means Control is Ok on due time)

I want "Expected Delivery Date" as red when
- "Expected Delivery Date" > "Control Date" and "Control Result" =Y (Means control is ok not on due time)

- "Expected Delivery Date" > "Control Date" and "Control Result" =N (Means control ok is not given, delayed...)

View 3 Replies View Related

Copy Info Between Cells And Sort By Horizontal Titles

May 25, 2014

I have a column of Data (A1:A20584) that includes information for different contacts


I need the information to list as Row Titles (horizontally) so I can sort. I hope I am saying this correctly.

View 2 Replies View Related

Copyrights 2005-15, All rights reserved