Hi,
I would like to have a formula existing the will tell me the count of unique records when filtered.
Data represented below.
ID Name Priority
ORPAU0092 MONTICELLO UH
ORPAU0092 MONTICELLO UH
ORPAU0203 LONGVIEW NORTH UH
ORPAU0203 LONGVIEW NORTH UH
In the above example if I filtered for ORPAU0092 I would like the count to show 1.
Current formula being used is =CONCATENATE("Count of Sites - ",VALUE(SUBTOTAL(2,X3:X587))) but this does not account for unique records.
Any ideas? Thanks in advance.
I would like to have a formula existing the will tell me the count of unique records when filtered.
Data represented below.
ID Name Priority
ORPAU0092 MONTICELLO UH
ORPAU0092 MONTICELLO UH
ORPAU0203 LONGVIEW NORTH UH
ORPAU0203 LONGVIEW NORTH UH
In the above example if I filtered for ORPAU0092 I would like the count to show 1.
Current formula being used is =CONCATENATE("Count of Sites - ",VALUE(SUBTOTAL(2,X3:X587))) but this does not account for unique records.
Any ideas? Thanks in advance.