| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Matching up data - BOB?
you are probably correct - Thank you Bob
"Bob Phillips" wrote: Your new formula has nothing to do with comparing one column against another AFAICS. Sounds like you have no full matches. Are you sure that some of the seeming matches do not have extra spaces, probably at the end? -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Filter by first letter" wrote in message ... sorry it does not fix it, There are no cells with a red format like I set up I also tried =IF(C2=C3,1,IF(C2=C1,1,"")) which works in another spreadsheet (numbers), but does not here for some reason "Bob Phillips" wrote: There was a missing ) in my formula =ISNUMBER(MATCH(C1,B:B,0)) does that fix it? -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Filter by first letter" wrote in message ... Bob I did exactly what you ask - but I do not get any colour differential, I know for a fact that there are 200 names that are in both lists. Very frustrated here "Bob Phillips" wrote: I would use conditional formatting. Select all cells in column C, assuming starting at C1, Goto FormatConditional Formatting Change Condition1 to Formula Is Add a formula of =ISNUMBER(MATCH(C1,B:B,0) Select the pattern tab Select a colour OK out all items in C that are also in B will show in colour. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Filter by first letter" wrote in message ... I have a list in column C that has thousands of different company names and I am trying to see which names in column C match up with the names in column B which has hundreds of names. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table data not matching source | Excel Discussion (Misc queries) | |||
| Getting #N/A from Vlookup when matching value exist in the lookup data range. | Excel Worksheet Functions | |||
| Matching data using date criteria... | Excel Worksheet Functions | |||
| Only text values matching using index/match lookup - data type pro | Excel Worksheet Functions | |||
| Matching data in one column to another | Excel Worksheet Functions | |||
Threaded Mode
