Grouping rows on multiple criterias

Microsoft Office excel 2007
October 26, 2010 at 19:02:50
Specs: Windows 7
Here's what my spreadsheet looks like:

(A) Client Name
(B) Date
(C) Session Type
(D) Formula (If) return Yes when date is in a range

A client may have more than one row since it may have more than 1 session type. What I need to find out if the session is current (i.e. Col. D = yes), I want to see the all the session types related to the same client.


Client 1 10/21/10 Type 1 No
Client 1 10/19/10 Type 4 Yes
Client 1 10/31/10 Type 3 No
Client 2 11/3/10 Type 1 No
Client 2 12/4/10 Type 4 No

Since one of the rows in Client 1 shows a Yes in col D, I would like to see all rows for that client in my summary, whereas I don't want to see anyting that relates to Client 2 since nothing in Col D is yes.

I created the fomula in Col D using an If statement, if there's a better way to put in a date range I'm open to suggestions.

See More: Grouping rows on multiple criterias

Report •

October 27, 2010 at 04:35:49
Could there be more than one Yes at any given time - either for the same client or for multiple clients?

Report •

October 27, 2010 at 06:54:55
yes, definitely.

Report •

Related Solutions

Ask Question