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.