| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comparing Absolute Column on multiple rows
=SUM(IF(Sheet2!$A$1:$A$20=Sheet1!$B$1:$AE$1,1,0))
Should work when entered/committed with Ctrl+Shift+Enter rather than just enter. -- Regards, Tom Ogilvy "mortals" wrote in message ups.com... My mistake, I meant that the rows would be Sheet1!B1:AE1 That would make a big difference. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparing multiple column values | Excel Worksheet Functions | |||
| Formula for comparing rows in a column | Excel Discussion (Misc queries) | |||
| Way to put multiple rows into the same column. | Excel Discussion (Misc queries) | |||
| Multiple rows to one column | Excel Programming | |||
| Problem when trying to convert one column with multiple rows to one row with multiple column | Excel Programming | |||
Threaded Mode
