(Count Formula) Count if two seperate ranges create unique combination
I'm having trouble with this formula. I need to count only if range1 and range2 create a unique combination. range1 is text and range2 is number.
both ranges will have countless duplicates.
I could do this with concatenate, but I would prefer to know the proper way to do this before creating new ranges to work on.
Thank you for any help or ideas beforehand.
Justin
please upload a sample file with expected result.
for attaching a sample file "Go Advance" the "Manage Attachments"
If answer helped you say Thanks by Add Reputation
Post some sample data and tell us what result you expect.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks