| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to search vertically then count horizontally in excel
Hi I'm trying to work out how to FIND an instance of a name on the vertical
axis, then count any iinstances of a particular text on the horizontal. i.e. Joe bloggs is in cell A1 on sheet 1 then on sheet 2 he is in cell A10. Sheet 1 shows what days Joe worked and was on holiday, as does sheet 2. Sheet 3 "the holiday planner" counts each holiday for joe using the formula countif. which requires me to choose the correct cell range. Can I use a formula to find the correct row "joe bloggs" then count the number of holidays that joe had on seperate sheets? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I arrange tabs vertically in Excel (not horizontally)? | Excel Discussion (Misc queries) | |||
| How do I freeze panes horizontally and vertically at same time | Excel Discussion (Misc queries) | |||
| aligning sheet tabs vertically, not horizontally | Excel Worksheet Functions | |||
| How to create a floating bar chart vertically not horizontally... | Charts and Charting in Excel | |||
| Move cells vertically to horizontally | Excel Discussion (Misc queries) | |||
Threaded Mode
