Count Unique Values IFS

O177812

Board Regular
Joined
Apr 16, 2015
Messages
82
Office Version
  1. 365
  2. 2021
I am looking for a formula that will count the unique values in Column C for all the rows that have a specific date (6/1/22) in Column B and a specific name in Column A (Dave).

1660155759383.png


The Formula should return "3"

Can someone please help?

THANKS!
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
Pivot Table your data.
Place Sales Person ,Order Number and Date in Rows. (You could use Name instead of Order Number as well.)
Also Place Order Number in Sigma, Right Click to change function to Count if necessary.

Using the Pivot Table Context Ribbon, Design to change Report Layout to Tabular. Also use Report Layout to change to Report All Row Labels. Change Subtotals to Do not Show Subtotals.
 
Upvote 0
Pivot Table your data.
Place Sales Person ,Order Number and Date in Rows. (You could use Name instead of Order Number as well.)
Also Place Order Number in Sigma, Right Click to change function to Count if necessary.

Using the Pivot Table Context Ribbon, Design to change Report Layout to Tabular. Also use Report Layout to change to Report All Row Labels. Change Subtotals to Do not Show Subtotals.
Hi Thanks for the suggestion but I specifically need a formula.
 
Upvote 0
@O177812 As you have XL365, try this.

MrExcelAug.xlsx
ABCDEF
1PersonDateRefPersonDave
2Dave6/1/22121341Date6/1/22
3Tim6/1/22121342Count3
4Michael6/1/22121343
5Dave6/4/22121344
6Tim6/6/22121345
7Michael6/9/22121346
8Tim5/30/22121347
9Michael6/1/22121343
10Michael6/4/22121349
11Michael5/31/22121350
12Dave6/1/22121351
13Dave6/1/22121341
14Dave6/1/22121353
15Tim6/1/22121342
16
17
Sheet2
Cell Formulas
RangeFormula
F3F3=COUNTA(UNIQUE(FILTER(A1:C999,(A1:A999=F1)*(B1:B999=F2),)))/3
 
Upvote 0

Forum statistics

Threads
1,213,535
Messages
6,114,194
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top