| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula looking up multiple information.
Excel 2003. I'm wanting a formula that encompasses all 3 requirements:
1. If a number in column A appears multiple times in column B. 2. Then if 2 different pre-determinded names appear in column C (there's one name per cell) that are in the same rows as the numbers found in column B. 3. Bring back the count of times the number appears in column B, less the number of times the 2 names appear in column C (if only 1 name appears, just the total count of numbers found in column B) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| If formula that looks at multiple cells and values, and then calul | Excel Discussion (Misc queries) | |||
| Formula to compare multiple rows values based on another column? | Excel Worksheet Functions | |||
| Formula to find information between 2 dates | Excel Worksheet Functions | |||
| Excel should let me refer to the same formula on multiple sheets | Excel Worksheet Functions | |||
Threaded Mode
