| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula to identify specific cells
Looking for a formula that will be in another worksheet that will identify
Jim had 5 oranges or art had 2 bananas. Would like to have it so that it would identify Jim and any one of the headers in a range of cells A2 A3 A4 A5 "Apples" "Oranges" "Pears" "Bananas" B2 "Jim" 41 0 6 3 B3 "Don" 0 9 0 12 B4 "Art 5 5 0 2 B5 "Fran" 4 0 11 25 -- thanx |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create formula to identify duplicate cells? | Excel Worksheet Functions | |||
| Identify by color border the cells in a formula | Excel Worksheet Functions | |||
| search column of text cellto identify those cells with specific w | Excel Worksheet Functions | |||
| Sum formula of cells with specific color value | Excel Worksheet Functions | |||
| Formula to identify a keyword in all cells of a column | Excel Discussion (Misc queries) | |||
Threaded Mode
