Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formula or tool to compare two columns of data
I am looking for a formula in excel that will compare to columns of data and
put a result in another column. Basically: "If the number in column A (each row will have a different number) appears in column E (any row and may even have multiple occurences), put a Y in column G on the row in which the column A number appears." Does that even make sense? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formula or tool to compare two columns of data
I think you will need to use an ID, ISERROR and VLOOKUP.
Something like this in G1: =IF(ISERROR(VLOOKUP(A1;E:E;1;FALSE));"";"Y") Per Erik On Fri, 14 Apr 2006 08:49:01 -0700, RBS wrote: I am looking for a formula in excel that will compare to columns of data and put a result in another column. Basically: "If the number in column A (each row will have a different number) appears in column E (any row and may even have multiple occurences), put a Y in column G on the row in which the column A number appears." Does that even make sense? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formula or tool to compare two columns of data
Hi!
Does that even make sense? Yes! Try this in G1: =IF(COUNTIF(E$1:E$100,A1),"Y","") Then just copy down as needed. Biff "RBS" wrote in message ... I am looking for a formula in excel that will compare to columns of data and put a result in another column. Basically: "If the number in column A (each row will have a different number) appears in column E (any row and may even have multiple occurences), put a Y in column G on the row in which the column A number appears." Does that even make sense? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formula or tool to compare two columns of data
Try this in G1:
=IF(COUNTIF($A$1:$A$100,"="&E1)0,"Y","") Copy down as needed. HTH, Elkar "RBS" wrote: I am looking for a formula in excel that will compare to columns of data and put a result in another column. Basically: "If the number in column A (each row will have a different number) appears in column E (any row and may even have multiple occurences), put a Y in column G on the row in which the column A number appears." Does that even make sense? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to compare 6 columns of text data | Excel Worksheet Functions | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Macro to compare two columns of data | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions |