|Here's what my spreadsheet looks like:|
(A) Client Name
(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.
A B C D
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.