Hello friends,
I need to figure out a formula that can count a distinct value of one column and get filtered by another.
My situation:
This tab is from Report! workpage. I need in column F to have a formula that will calculate how many of quantity (orders) in column All_orders!R:R have a unique merchant_id (All orders!B:B)
Report
2.JPG
All_orders
3.JPG
4.JPG
Bookmarks