Hello. I have customers and renewals, but there are duplicate instances in my list. I want to isolate each customer and each renewal decision AND/OR count ALL UNIQUE customers and ALL UNIQUE renewals. Thanks. Spreadsheet attached.
Hello. I have customers and renewals, but there are duplicate instances in my list. I want to isolate each customer and each renewal decision AND/OR count ALL UNIQUE customers and ALL UNIQUE renewals. Thanks. Spreadsheet attached.
For unique customers. Use the Unique option on the Advanced Filter
https://support.office.com/en-us/art...5-ca507915b704
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Hi Alan, but I don't think that will get me what I want.
I used that technique on the attached file and the numbers come up the same as yours. My output is in G9:I14
With formulas in the total rows.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks