| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
COmparing a cell with a colum of data
Hi iam having trouble wiht my formula
=IF(A2='[Area 43-52 New Floc Upload.xls]Area 43-52 New Floc Upload'!$A:$A,"New","Old") or even =IF(K12=L1:L15,"YAY","NA") It will only check if the data is on the same row. I want excel to compare one particular cell with all the cells in a whole entrie column for a match and then tell me yes or no. How do i do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| comparing colum data and exporting | Excel Discussion (Misc queries) | |||
| Keeping a sum colum correct after inserting a colum of data in fro | Excel Discussion (Misc queries) | |||
| Comparing two cells in a colum with 2000 rows | Excel Discussion (Misc queries) | |||
| Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) | |||
| Check data on colum A and find match on colum b | Excel Discussion (Misc queries) | |||
Threaded Mode
