Hey guys
Hope all is well
I need some help,
Aim- To count how many unique “MID Internal (Merchant ID)” (column B) fall under “# of Calls” Column I
For eg
“MID Internal (Merchant ID)” = ‘878022420888’ (highlighted yellow) Row 8 & 9 is in my data twice, however i want it count against the “# of Calls” = “Less than 2” just the once
“MID Internal (Merchant ID)” = ‘878187094882’ (highlighted green) Row 22 & 28 is in my data seven times, however i want it count against the “# of Calls” = “Five - seven ” just the once
Please find attached my excel
Would appreciate any help available
Bookmarks