| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
reporting list of dates
Hi all,
i have a worksheet with 'col A' a list of dates and 'row 14' a list of names. under the names appears the text "late" to line up with a date. I have a sumproduct section to total the no of times the text "late" appears within a date range. On another worksheet i want to list the names in one column and then the dates where "late" appears in adjacent columns, but only if the sumproduct total is 9 I'm a bit lost at this point any help appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I generate a list of random dates from dates I specify | Excel Worksheet Functions | |||
| using excel to pick data from a list, reporting names and integers | Excel Discussion (Misc queries) | |||
| How to filter out all the partial dates from a big list of dates? | Excel Discussion (Misc queries) | |||
| Need to pull current dates from list w/many dates | Excel Discussion (Misc queries) | |||
| need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
Threaded Mode
