| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Compare numbers in to raws
I'm using Excel 2003
Can anybody help with programming this: I have a column of numbers in F20:F33 I would like to check against an other colums of numbers in A20:A23. All numbers are phone numbers - no parentheses. If a number in F match a number in A, it should return a "Y" (for yes) in the adressfield to the right for this number (say G28). I tried to modify the IF COUNT IF in the thread shown in "Programming" on the 10.02.2010 without succes. The above ranges are arbitrary. The real ones are much much longer. Thank you in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| compare 2 columns of numbers and place the matched numbers in a 3r | Excel Discussion (Misc queries) | |||
| VLOOKUP should compare numbers stored as text to plain numbers. | Excel Worksheet Functions | |||
| how to hide raws and use password | Excel Worksheet Functions | |||
| how to hide raws and use password | Excel Discussion (Misc queries) | |||
| copy columns to raws | Excel Discussion (Misc queries) | |||
Threaded Mode
