| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find if there is a matching number in another column
Maaybe
=IF(COUNTIF($A$1:$A$50,B1)0,"X","") Drag down as required Mike "Xhawk57" wrote: is there a way to take two sets of data and mark a third column when the number from the fist column has a match anywhere in the set (range) of data for the other column? for instance i have 3 columns A B C 1 9 3 9 4 is there a formula that would return a marker in column C by asking the question "if B1 = any number in column A return an "X""? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count to find the number of 100% 90% 80% in a column | Excel Discussion (Misc queries) | |||
| lookup or find matching number in text string | Excel Worksheet Functions | |||
| Find max Row() number for a value in column | Excel Worksheet Functions | |||
| find a cell matching separate column and row values | Excel Worksheet Functions | |||
| How do I find the first value in a column less than a number? | Excel Worksheet Functions | |||
Threaded Mode
