Hello. I tried to do this with pivot tables but nobody responded hahaAnyways, I have customer data, year of the data, and claims for each year. I would like to do a count of number of customers that filed two or more claims in the first year and then renewed into the second year (meaning they have data for year 2).
Spreadsheet attached. Thanks.
Hi, Refer the attachment
☚ Click ★ just below left if it helps, Boo?ath?
Re: conditional formula with two categories
Hi ammartino...
Try this Array entered Formula.. (use Ctrl + Shift + Enter to put it...)
Formula:
Please Login or Register to view this content.
Check the attached file..
Regards,
Vikas Gautam
Excel-buzz.blogspot.com
Excel is not a matter of Experience, its a matter of Application.
Say Thanks, Click * Add Reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks