| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help comparing data in two columns
I have data on the first tab that includes a unique ID #. I have a list of
ID#'s on a fourth tab that I'm trying to compare to list on first tab to let me know "Yes" this ID is included from fourth tab or "No" Can anyone help? Thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need help comparing data in two columns
Hi,
=IF(COUNTIF(Sheet4!A$1:A$100,A1),"Yes","No") I entered this formula on the first sheet in cell B1. Copy it down as needed. -- If this helps, please click the Yes button Cheers, Shane Devenshire "drew" wrote: I have data on the first tab that includes a unique ID #. I have a list of ID#'s on a fourth tab that I'm trying to compare to list on first tab to let me know "Yes" this ID is included from fourth tab or "No" Can anyone help? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparing data in columns | Excel Discussion (Misc queries) | |||
| Comparing two columns of data | Excel Discussion (Misc queries) | |||
| Comparing columns of data | Excel Discussion (Misc queries) | |||
| Comparing Data in 2 columns | Excel Worksheet Functions | |||
| Comparing Data in two columns | Excel Worksheet Functions | |||
Linear Mode
