| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Searching two columns for information
I have a range of data in A2:G30 with cells in range A2:A30 with 'yes' or
'no' as text in the cells, and I have 'David', 'Andrew', 'Charles' or 'John' as text in cells D2:D30. I want to put in cell K50 a function that searches D2:D30 for 'Charles', then records the number of cells in the corresponding rows in range A2:A30 where the cells are 'yes'. How do I do this please. -- Thank you, Colin. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Searching columns, summarizing, and totalling? | Excel Discussion (Misc queries) | |||
| Searching Columns and Rows | Excel Worksheet Functions | |||
| Searching Columns | Excel Discussion (Misc queries) | |||
| searching columns and rows | Excel Discussion (Misc queries) | |||
| Searching Columns | Excel Discussion (Misc queries) | |||
Threaded Mode
