Count unique rows with exception

[RattlingCarp3048]

I have a tricky one and cannot seem to find anything searching the web related and im not sure how to phrase it. I am currently working with this formula...

=IFERROR(ROWS(UNIQUE(FILTER(IHC!$A$3:$A$40000,(IHC!$N$3:$N$40000=Summary!B51)*((IHC!$J$3:$J$40000="Open")+(IHC!$J$3:$J$40000="Processing"))*(IHC!$D$3:$D$40000<>"Hemepath")))),"-")

which basically says to count unique rows if employee name matches, status is "processing" or "open" and it did not come from "Hemepath". One factor we did not take into account is the dates. Somehow i need to add a criteria that says if the dates in column O are the same then only count the rows for that date 1x, however, if the dates are different then count it 2x or 3x based on how many different dates there are.

In this example, AB23455 should be counted 2x for Mel because she handled the code on 7/12 then again on 7/13.

hopefully this makes sense.

A - J - N- O

Code	Status	Last Changed	Last Changed Date
			​
AB23455	Processing	Mel	7/12/2023 17:57​
AB23455	Processing	Mel	7/12/2023 17:57​
AB23455	Processing	Mel	7/12/2023 17:57​
AB23455	Processing	Mel	7/12/2023 17:57​
AB23455	Processing	Mel	7/12/2023 17:57​
AB23455	Processing	Mel	7/12/2023 17:57​
AB23455	Processing	Mel	7/12/2023 17:57​
AB23455	Processing	Mel	7/12/2023 17:57​
AB23455	Processing	VV	7/13/2023 12:28​
AB23455	Open	CD	7/13/2023 16:04​
AB23455	Processing	Mel	7/13/2023 16:13​
AB23455	Open	CD	7/13/2023 18:24​
AB23455	Processing	CD	7/13/2023 18:30​
AB23455	Processing	CD	7/13/2023 18:38​
AB23455	Processing	CD	7/13/2023 18:42​

 

[ExceLoki]

try the formula under new

Book1
	A									J				N	O	P	Q	R	S
1	Code									Status				Last Changed	Last Changed Date
2																	before	new
3	AB23455									Processing				Mel	7/12/2023 17:57		1	2	Mel
4	AB23455									Processing				Mel	7/12/2023 17:57		1	1	VV
5	AB23455									Processing				Mel	7/12/2023 17:57		1	1	CD
6	AB23455									Processing				Mel	7/12/2023 17:57
7	AB23455									Processing				Mel	7/12/2023 17:57
8	AB23455									Processing				Mel	7/12/2023 17:57
9	AB23455									Processing				Mel	7/12/2023 17:57
10	AB23455									Processing				Mel	7/12/2023 17:57
11	AB23455									Processing				VV	7/13/2023 12:28
12	AB23455									Open				CD	7/13/2023 16:04
13	AB23455									Processing				Mel	7/13/2023 16:13
14	AB23455									Open				CD	7/13/2023 18:24
15	AB23455									Processing				CD	7/13/2023 18:30
16	AB23455									Processing				CD	7/13/2023 18:38
17	AB23455									Processing				CD	7/13/2023 18:42
IHC

Cell Formulas
Range	Formula
Q3:Q5	Q3	=IFERROR(ROWS(UNIQUE(FILTER(IHC!$A$3:$A$40000,(IHC!$N$3:$N$40000=S3)*((IHC!$J$3:$J$40000="Open")+(IHC!$J$3:$J$40000="Processing"))*(IHC!$D$3:$D$40000<>"Hemepath")))),"-")
R3:R5	R3	=IFERROR(ROWS(UNIQUE(FILTER(INT(IHC!$O$3:$O$40000),(IHC!$N$3:$N$40000=S3)*((IHC!$J$3:$J$40000="Open")+(IHC!$J$3:$J$40000="Processing"))*COUNTA(UNIQUE(IHC!$A$3:$A$40000))*(IHC!$D$3:$D$40000<>"Hemepath")))),"-")

 

[RattlingCarp3048]

@ExceLoki This didnt work when i applied it to the entire month. My original formula was showing Mel at 861 total unique codes for the month but your formula is showing her at 21 for the month. Target total should be 916 for the month.

Here is a larger sample. In this set there are 61 unique codes, however the target should be 66 as there are 5 codes that were worked on different days. AB23455, AS233173, MD1353, RT10918, and UT10626

AB23442	Processing	Mel	7/12/2023 17:25​
AB23442	Processing	Mel	7/12/2023 17:25​
AB23442	Processing	Mel	7/12/2023 17:25​
AB23442	Processing	Mel	7/12/2023 17:25​
AB23442	Processing	Mel	7/12/2023 17:25​
AB23442	Processing	Mel	7/12/2023 17:25​
AB23442	Processing	Mel	7/12/2023 17:25​
AB23442	Processing	Mel	7/12/2023 17:25​
AB23442	Processing	Mel	7/12/2023 17:25​
AB23442	Processing	Mel	7/12/2023 17:25​
AB23442	Processing	Mel	7/12/2023 17:25​
AB23443	Processing	Mel	7/12/2023 15:34​
AB23443	Processing	Mel	7/12/2023 15:34​
AB23443	Processing	Mel	7/12/2023 15:34​
AB23443	Processing	Mel	7/12/2023 15:34​
AB23443	Processing	Mel	7/12/2023 15:34​
AB23443	Processing	Mel	7/12/2023 15:34​
AB23443	Processing	Mel	7/12/2023 15:34​
AB23443	Processing	Mel	7/12/2023 15:34​
AB23448	Processing	Mel	7/12/2023 15:34​
AB23448	Processing	Mel	7/12/2023 15:34​
AB23448	Processing	Mel	7/12/2023 15:34​
AB23448	Processing	Mel	7/12/2023 15:34​
AB23448	Processing	Mel	7/12/2023 15:34​
AB23448	Processing	Mel	7/12/2023 15:34​
AB23448	Processing	Mel	7/12/2023 15:34​
AB23448	Processing	Mel	7/12/2023 15:34​
AB23450	Processing	Mel	7/12/2023 16:29​
AB23450	Processing	Mel	7/12/2023 16:29​
AB23451	Processing	Mel	7/12/2023 16:27​
AB23451	Processing	Mel	7/12/2023 16:27​
AB23452	Processing	Mel	7/12/2023 16:30​
AB23452	Processing	Mel	7/12/2023 16:30​
AB23452	Processing	Mel	7/12/2023 16:30​
AB23452	Processing	Mel	7/12/2023 16:30​
AB23453	Processing	Mel	7/12/2023 16:30​
AB23453	Processing	Mel	7/12/2023 16:30​
AB23454	Processing	Mel	7/12/2023 17:52​
AB23454	Processing	Mel	7/12/2023 17:52​
AB23454	Processing	Mel	7/12/2023 17:52​
AB23454	Processing	Mel	7/12/2023 17:52​
AB23454	Processing	Mel	7/12/2023 17:52​
AB23454	Processing	Mel	7/12/2023 17:52​
AB23454	Processing	Mel	7/12/2023 17:52​
AB23455	Processing	Mel	7/12/2023 17:57​
AB23455	Processing	Mel	7/12/2023 17:57​
AB23455	Processing	Mel	7/12/2023 17:57​
AB23455	Processing	Mel	7/12/2023 17:57​
AB23455	Processing	Mel	7/12/2023 17:57​
AB23455	Processing	Mel	7/12/2023 17:57​
AB23455	Processing	Mel	7/12/2023 17:57​
AB23455	Processing	Mel	7/12/2023 17:57​
AB23455	Processing	Mel	7/13/2023 16:13​
AB23456	Processing	Mel	7/12/2023 17:52​
AB23456	Processing	Mel	7/12/2023 17:52​
AB23456	Processing	Mel	7/12/2023 17:52​
AB23456	Processing	Mel	7/12/2023 17:52​
AB23457	Processing	Mel	7/12/2023 17:52​
AB23457	Processing	Mel	7/12/2023 17:52​
AB23457	Processing	Mel	7/12/2023 17:52​
AB23457	Processing	Mel	7/12/2023 17:52​
AB23457	Processing	Mel	7/12/2023 17:52​
AB23457	Processing	Mel	7/12/2023 17:52​
AB23457	Processing	Mel	7/12/2023 17:52​
AB23458	Processing	Mel	7/13/2023 17:30​
AB23458	Processing	Mel	7/13/2023 17:30​
AB23458	Processing	Mel	7/13/2023 17:30​
AB23458	Processing	Mel	7/13/2023 17:30​
AB23458	Processing	Mel	7/13/2023 17:30​
AB23458	Processing	Mel	7/13/2023 17:30​
AB23458	Processing	Mel	7/13/2023 17:30​
AB23459	Processing	Mel	7/13/2023 17:36​
AB23459	Processing	Mel	7/13/2023 17:36​
AB23459	Processing	Mel	7/13/2023 17:36​
AB23459	Processing	Mel	7/13/2023 17:36​
AB23460	Processing	Mel	7/13/2023 15:43​
AB23461	Processing	Mel	7/13/2023 15:42​
AB23461	Processing	Mel	7/13/2023 15:42​
AB23461	Processing	Mel	7/13/2023 15:42​
AB23461	Processing	Mel	7/13/2023 15:42​
AB23461	Processing	Mel	7/13/2023 15:42​
AB23461	Processing	Mel	7/13/2023 15:42​
AB23461	Processing	Mel	7/13/2023 15:42​
AB23464	Processing	Mel	7/13/2023 16:12​
AB23464	Processing	Mel	7/13/2023 16:12​
AB23464	Processing	Mel	7/13/2023 16:12​
AB23464	Processing	Mel	7/13/2023 16:12​
AB23464	Processing	Mel	7/13/2023 16:12​
AB23464	Processing	Mel	7/13/2023 16:12​
AB23464	Processing	Mel	7/13/2023 16:12​
AB23464	Processing	Mel	7/13/2023 16:12​
AB23464	Processing	Mel	7/13/2023 16:12​
AB23464	Processing	Mel	7/13/2023 16:12​
AB23464	Processing	Mel	7/13/2023 16:12​
AB23464	Processing	Mel	7/13/2023 16:12​
AB23464	Processing	Mel	7/13/2023 16:54​
AB23464	Processing	Mel	7/13/2023 16:12​
AB23464	Processing	Mel	7/13/2023 16:54​
AB23464	Processing	Mel	7/13/2023 16:54​
AB23464	Processing	Mel	7/13/2023 16:54​
AB23464	Processing	Mel	7/13/2023 16:54​
AB23464	Processing	Mel	7/13/2023 16:54​
AB23464	Processing	Mel	7/13/2023 16:54​
AB23464	Processing	Mel	7/13/2023 16:54​
AB23464	Processing	Mel	7/13/2023 16:54​
AB23464	Processing	Mel	7/13/2023 16:54​
AO30385	Processing	Mel	7/13/2023 15:42​
AO30385	Open	Mel	7/13/2023 15:18​
AS233118	Processing	Mel	7/13/2023 12:04​
AS233118	Processing	Mel	7/13/2023 12:04​
AS233140	Processing	Mel	7/13/2023 16:38​
AS233140	Processing	Mel	7/13/2023 16:38​
AS233140	Processing	Mel	7/13/2023 16:38​
AS233140	Processing	Mel	7/13/2023 16:38​
AS233140	Processing	Mel	7/13/2023 16:38​
AS233140	Processing	Mel	7/13/2023 16:38​
AS233159	Processing	Mel	7/12/2023 16:34​
AS233159	Processing	Mel	7/12/2023 16:34​
AS233159	Processing	Mel	7/12/2023 16:34​
AS233159	Processing	Mel	7/12/2023 16:34​
AS233159	Processing	Mel	7/12/2023 16:34​
AS233159	Processing	Mel	7/12/2023 16:34​
AS233159	Processing	Mel	7/12/2023 16:34​
AS233159	Processing	Mel	7/12/2023 16:34​
AS233159	Processing	Mel	7/12/2023 16:34​
AS233169	Processing	Mel	7/12/2023 16:36​
AS233169	Processing	Mel	7/12/2023 16:36​
AS233169	Processing	Mel	7/12/2023 16:36​
AS233169	Processing	Mel	7/12/2023 16:36​
AS233173	Processing	Mel	7/12/2023 17:26​
AS233173	Processing	Mel	7/12/2023 17:26​
AS233173	Processing	Mel	7/12/2023 17:26​
AS233173	Processing	Mel	7/12/2023 17:26​
AS233173	Processing	Mel	7/12/2023 17:26​
AS233173	Processing	Mel	7/12/2023 17:26​
AS233173	Processing	Mel	7/13/2023 12:23​
AS233173	Processing	Mel	7/13/2023 16:41​
AS233173	Processing	Mel	7/13/2023 16:41​
AS233173	Processing	Mel	7/13/2023 16:41​
AS233173	Processing	Mel	7/13/2023 16:41​
AS233173	Processing	Mel	7/13/2023 16:41​
AS233173	Processing	Mel	7/13/2023 16:41​
AS233191	Processing	Mel	7/13/2023 16:40​
AS233191	Processing	Mel	7/13/2023 16:40​
AS233191	Processing	Mel	7/13/2023 16:40​
AS233191	Processing	Mel	7/13/2023 16:40​
AS233193	Processing	Mel	7/13/2023 16:50​
AS233193	Processing	Mel	7/13/2023 16:50​
BF551	Open	Mel	7/12/2023 13:16​
BF551	Processing	Mel	7/12/2023 13:25​
BF551	Processing	Mel	7/12/2023 13:25​
BF551	Open	Mel	7/12/2023 13:16​
BF551	Open	Mel	7/12/2023 13:16​
BF551	Processing	Mel	7/12/2023 13:25​
BF551	Open	Mel	7/12/2023 13:16​
BF551	Processing	Mel	7/12/2023 13:25​
BS7639	Processing	Mel	7/12/2023 13:22​
BS7639	Processing	Mel	7/12/2023 13:22​
BS7639	Open	Mel	7/12/2023 13:13​
BS7639	Open	Mel	7/12/2023 13:13​
BS7639	Processing	Mel	7/12/2023 13:22​
BS7639	Open	Mel	7/12/2023 13:13​
BS7639	Open	Mel	7/12/2023 13:13​
BS7639	Processing	Mel	7/12/2023 13:22​
BS7639	Open	Mel	7/12/2023 13:13​
BS7639	Processing	Mel	7/12/2023 13:22​
BS7639	Processing	Mel	7/12/2023 13:22​
BS7639	Open	Mel	7/12/2023 13:13​
BS7640	Open	Mel	7/12/2023 13:15​
BS7640	Open	Mel	7/12/2023 13:15​
BS7640	Processing	Mel	7/12/2023 13:24​
BS7640	Processing	Mel	7/12/2023 13:24​
BS7640	Processing	Mel	7/12/2023 13:24​
BS7640	Processing	Mel	7/12/2023 13:24​
BS7640	Open	Mel	7/12/2023 13:15​
BS7640	Open	Mel	7/12/2023 13:15​
BS7640	Open	Mel	7/12/2023 13:15​
BS7640	Processing	Mel	7/12/2023 13:24​
BS7640	Open	Mel	7/12/2023 13:15​
BS7640	Processing	Mel	7/12/2023 13:24​
BS7642	Processing	Mel	7/12/2023 13:25​
BS7642	Open	Mel	7/12/2023 13:15​
BS7642	Processing	Mel	7/12/2023 13:25​
BS7642	Open	Mel	7/12/2023 13:15​
BS7642	Open	Mel	7/12/2023 13:15​
BS7642	Processing	Mel	7/12/2023 13:25​
BS7642	Processing	Mel	7/12/2023 13:25​
BS7642	Open	Mel	7/12/2023 13:15​
BS7678	Processing	Mel	7/12/2023 13:23​
BS7678	Open	Mel	7/12/2023 13:14​
BS7678	Open	Mel	7/12/2023 13:14​
BS7678	Processing	Mel	7/12/2023 13:23​
BS7678	Processing	Mel	7/12/2023 13:23​
BS7678	Open	Mel	7/12/2023 13:14​
BS7678	Open	Mel	7/12/2023 13:14​
BS7678	Open	Mel	7/12/2023 13:14​
BS7678	Processing	Mel	7/12/2023 13:23​
BS7678	Processing	Mel	7/12/2023 13:23​
BS7678	Processing	Mel	7/12/2023 13:23​
BS7678	Open	Mel	7/12/2023 13:14​
BS7680	Processing	Mel	7/12/2023 13:23​
BS7680	Open	Mel	7/12/2023 13:14​
BS7680	Open	Mel	7/12/2023 13:14​
BS7680	Processing	Mel	7/12/2023 13:23​
BS7680	Processing	Mel	7/12/2023 13:23​
BS7680	Processing	Mel	7/12/2023 13:23​
BS7680	Open	Mel	7/12/2023 13:14​
BS7680	Open	Mel	7/12/2023 13:14​
BS7680	Open	Mel	7/12/2023 13:14​
BS7680	Processing	Mel	7/12/2023 13:23​
BS7680	Open	Mel	7/12/2023 13:14​
BS7680	Processing	Mel	7/12/2023 13:23​
BS7693	Open	Mel	7/12/2023 13:14​
BS7693	Open	Mel	7/12/2023 13:14​
BS7693	Processing	Mel	7/12/2023 13:22​
BS7693	Open	Mel	7/12/2023 13:14​
BS7693	Open	Mel	7/12/2023 13:14​
BS7693	Processing	Mel	7/12/2023 13:22​
BS7693	Open	Mel	7/12/2023 13:14​
BS7693	Processing	Mel	7/12/2023 13:22​
BS7693	Processing	Mel	7/12/2023 13:22​
BS7693	Open	Mel	7/12/2023 13:14​
BS7693	Processing	Mel	7/12/2023 13:22​
BS7693	Processing	Mel	7/12/2023 13:22​
CS10683	Open	Mel	7/12/2023 19:12​
CS10683	Processing	Mel	7/12/2023 19:45​
CS10683	Open	Mel	7/12/2023 19:43​
CS10917	Processing	Mel	7/12/2023 17:56​
CS10927	Processing	Mel	7/13/2023 14:12​
CS10927	Processing	Mel	7/13/2023 14:12​
CS10927	Processing	Mel	7/13/2023 14:12​
CS10927	Processing	Mel	7/13/2023 14:12​
CS10927	Processing	Mel	7/13/2023 14:12​
CS10927	Processing	Mel	7/13/2023 14:12​
CS10927	Processing	Mel	7/13/2023 14:12​
CS10927	Processing	Mel	7/13/2023 14:12​
CS10929	Processing	Mel	7/13/2023 15:40​
CS10929	Processing	Mel	7/13/2023 15:40​
CS10929	Processing	Mel	7/13/2023 15:40​
CS10929	Processing	Mel	7/13/2023 15:40​
CS10929	Processing	Mel	7/13/2023 15:40​
CS10929	Processing	Mel	7/13/2023 15:40​
CS10929	Processing	Mel	7/13/2023 15:40​
CS10929	Processing	Mel	7/13/2023 15:40​
CS10929	Processing	Mel	7/13/2023 15:40​
HO10698	Processing	Mel	7/13/2023 17:13​
HO10698	Processing	Mel	7/13/2023 17:13​
HO10698	Processing	Mel	7/13/2023 17:13​
HO10698	Processing	Mel	7/13/2023 17:13​
HO10699	Open	Mel	7/13/2023 17:52​
HO10699	Open	Mel	7/13/2023 17:53​
HO10699	Open	Mel	7/13/2023 17:53​
HO10699	Processing	Mel	7/13/2023 17:55​
HO10699	Processing	Mel	7/13/2023 17:55​
HO10699	Processing	Mel	7/13/2023 17:55​
HO10699	Open	Mel	7/13/2023 17:48​
HO10699	Open	Mel	7/13/2023 17:43​
HO10699	Processing	Mel	7/13/2023 17:55​
HO10699	Processing	Mel	7/13/2023 17:55​
HO10699	Open	Mel	7/13/2023 17:53​
HO10699	Open	Mel	7/13/2023 17:46​
HO10699	Processing	Mel	7/13/2023 17:55​
HO10699	Processing	Mel	7/13/2023 17:55​
HO10699	Processing	Mel	7/13/2023 17:55​
HO10699	Processing	Mel	7/13/2023 17:55​
HO10699	Open	Mel	7/13/2023 17:53​
HO10699	Open	Mel	7/13/2023 17:48​
HO10699	Processing	Mel	7/13/2023 17:55​
HO10699	Processing	Mel	7/13/2023 17:55​
HO10699	Processing	Mel	7/13/2023 17:55​
HO10699	Open	Mel	7/13/2023 17:52​
HO10699	Open	Mel	7/13/2023 17:53​
HO10699	Open	Mel	7/13/2023 17:46​
HO10700	Processing	Mel	7/13/2023 17:55​
HO10700	Processing	Mel	7/13/2023 17:55​
HO10700	Open	Mel	7/13/2023 17:48​
HO10700	Open	Mel	7/13/2023 17:52​
HO10700	Processing	Mel	7/13/2023 17:55​
HO10700	Processing	Mel	7/13/2023 17:55​
HO10700	Open	Mel	7/13/2023 17:49​
HO10700	Open	Mel	7/13/2023 17:52​
HO10700	Processing	Mel	7/13/2023 17:55​
HO10700	Open	Mel	7/13/2023 17:48​
HO11530	Processing	Mel	7/12/2023 19:43​
MD1331	Processing	Mel	7/12/2023 12:26​
MD1331	Processing	Mel	7/12/2023 12:26​
MD1331	Processing	Mel	7/12/2023 12:26​
MD1331	Processing	Mel	7/12/2023 12:26​
MD1353	Open	Mel	7/12/2023 12:20​
MD1353	Processing	Mel	7/13/2023 16:45​
RT10901	Processing	Mel	7/12/2023 19:08​
RT10901	Open	Mel	7/12/2023 19:07​
RT10901	Processing	Mel	7/12/2023 19:08​
RT10901	Open	Mel	7/12/2023 19:07​
RT10917	Open	Mel	7/12/2023 13:55​
RT10917	Processing	Mel	7/12/2023 13:59​
RT10917	Processing	Mel	7/12/2023 13:59​
RT10917	Processing	Mel	7/12/2023 13:59​
RT10917	Open	Mel	7/12/2023 13:55​
RT10917	Open	Mel	7/12/2023 13:55​
RT10917	Processing	Mel	7/12/2023 13:59​
RT10917	Open	Mel	7/12/2023 13:55​
RT10917	Open	Mel	7/12/2023 13:55​
RT10917	Open	Mel	7/12/2023 13:55​
RT10917	Processing	Mel	7/12/2023 13:59​
RT10917	Processing	Mel	7/12/2023 13:59​
RT10918	Processing	Mel	7/12/2023 14:01​
RT10918	Open	Mel	7/12/2023 13:55​
RT10918	Processing	Mel	7/13/2023 12:42​
RT10918	Processing	Mel	7/13/2023 12:42​
RT10918	Processing	Mel	7/13/2023 12:42​
RT10918	Open	Mel	7/12/2023 13:55​
RT10918	Open	Mel	7/12/2023 13:55​
RT10918	Processing	Mel	7/12/2023 14:01​
RT10918	Processing	Mel	7/12/2023 14:01​
RT10918	Open	Mel	7/12/2023 13:55​
RT10918	Processing	Mel	7/12/2023 14:01​
RT10918	Processing	Mel	7/13/2023 12:42​
RT10918	Processing	Mel	7/13/2023 12:42​
RT10918	Processing	Mel	7/12/2023 14:01​
RT10918	Processing	Mel	7/12/2023 14:01​
RT10918	Open	Mel	7/12/2023 13:55​
RT10918	Open	Mel	7/12/2023 13:55​
RT10918	Processing	Mel	7/13/2023 12:42​
RT10919	Open	Mel	7/12/2023 18:51​
RT10919	Open	Mel	7/12/2023 18:51​
RT10919	Processing	Mel	7/12/2023 18:52​
RT10919	Open	Mel	7/12/2023 18:51​
RT10919	Open	Mel	7/12/2023 18:51​
RT10919	Processing	Mel	7/12/2023 18:52​
RT10919	Open	Mel	7/12/2023 18:51​
RT10919	Processing	Mel	7/12/2023 18:52​
RT10919	Processing	Mel	7/12/2023 18:52​
RT10919	Open	Mel	7/12/2023 18:51​
RT10919	Processing	Mel	7/12/2023 18:52​
RT10919	Processing	Mel	7/12/2023 18:52​
RT10920	Open	Mel	7/12/2023 19:37​
RT10920	Processing	Mel	7/12/2023 19:43​
RT10920	Processing	Mel	7/12/2023 19:43​
RT10920	Open	Mel	7/12/2023 19:37​
RT10920	Processing	Mel	7/12/2023 19:43​
RT10920	Open	Mel	7/12/2023 19:37​
RT10920	Open	Mel	7/12/2023 19:37​
RT10920	Processing	Mel	7/12/2023 19:43​
RT10920	Processing	Mel	7/12/2023 19:43​
RT10920	Open	Mel	7/12/2023 19:37​
RT10920	Open	Mel	7/12/2023 19:37​
RT10920	Processing	Mel	7/12/2023 19:43​
RT10920	Open	Mel	7/12/2023 19:37​
RT10920	Processing	Mel	7/12/2023 19:43​
RT10920	Open	Mel	7/12/2023 19:37​
RT10920	Processing	Mel	7/12/2023 19:43​
RT10924	Open	Mel	7/13/2023 15:05​
RT10924	Open	Mel	7/13/2023 15:05​
RT10924	Processing	Mel	7/13/2023 15:05​
RT10924	Open	Mel	7/13/2023 15:05​
RT10924	Processing	Mel	7/13/2023 15:05​
RT10924	Processing	Mel	7/13/2023 15:05​
RT10924	Open	Mel	7/13/2023 15:05​
RT10924	Open	Mel	7/13/2023 15:05​
RT10924	Processing	Mel	7/13/2023 15:05​
RT10924	Open	Mel	7/13/2023 15:05​
RT10924	Processing	Mel	7/13/2023 15:05​
RT10924	Processing	Mel	7/13/2023 15:05​
RT10926	Open	Mel	7/13/2023 19:25​
RT10926	Processing	Mel	7/13/2023 19:26​
RT10926	Processing	Mel	7/13/2023 19:26​
RT10926	Open	Mel	7/13/2023 19:25​
RT10926	Processing	Mel	7/13/2023 19:26​
RT10926	Processing	Mel	7/13/2023 19:26​
RT10926	Processing	Mel	7/13/2023 19:26​
RT10926	Open	Mel	7/13/2023 19:25​
RT10926	Open	Mel	7/13/2023 19:25​
RT10926	Processing	Mel	7/13/2023 19:26​
RT10926	Open	Mel	7/13/2023 19:25​
RT10926	Open	Mel	7/13/2023 19:25​
RT10927	Open	Mel	7/13/2023 19:26​
RT10927	Open	Mel	7/13/2023 19:26​
RT10927	Processing	Mel	7/13/2023 19:26​
RT10927	Processing	Mel	7/13/2023 19:26​
RT10927	Open	Mel	7/13/2023 19:26​
RT10927	Open	Mel	7/13/2023 19:26​
RT10927	Processing	Mel	7/13/2023 19:26​
RT10927	Processing	Mel	7/13/2023 19:26​
RT10927	Open	Mel	7/13/2023 19:26​
RT10927	Open	Mel	7/13/2023 19:26​
RT10927	Processing	Mel	7/13/2023 19:26​
RT10927	Processing	Mel	7/13/2023 19:26​
RT10927	Open	Mel	7/13/2023 19:26​
RT10927	Open	Mel	7/13/2023 19:26​
RT10927	Processing	Mel	7/13/2023 19:26​
RT10927	Processing	Mel	7/13/2023 19:26​
RT10927	Open	Mel	7/13/2023 19:26​
RT10927	Open	Mel	7/13/2023 19:26​
RT10927	Processing	Mel	7/13/2023 19:26​
RT10927	Processing	Mel	7/13/2023 19:26​
RT10927	Open	Mel	7/13/2023 19:26​
RT10927	Open	Mel	7/13/2023 19:26​
RT10927	Processing	Mel	7/13/2023 19:26​
RT10927	Processing	Mel	7/13/2023 19:26​
RT10927	Processing	Mel	7/13/2023 19:26​
RT10927	Processing	Mel	7/13/2023 19:26​
RT10927	Open	Mel	7/13/2023 19:26​
RT10927	Open	Mel	7/13/2023 19:26​
RT10927	Processing	Mel	7/13/2023 19:26​
RT10927	Processing	Mel	7/13/2023 19:26​
RT10927	Open	Mel	7/13/2023 19:26​
RT10927	Open	Mel	7/13/2023 19:26​
RT10928	Open	Mel	7/13/2023 19:24​
RT10928	Open	Mel	7/13/2023 19:24​
RT10928	Processing	Mel	7/13/2023 19:26​
RT10928	Processing	Mel	7/13/2023 19:26​
RT10928	Open	Mel	7/13/2023 19:24​
RT10928	Open	Mel	7/13/2023 19:24​
RT10928	Processing	Mel	7/13/2023 19:26​
RT10928	Processing	Mel	7/13/2023 19:26​
RT10928	Processing	Mel	7/13/2023 19:26​
RT10928	Processing	Mel	7/13/2023 19:26​
RT10928	Open	Mel	7/13/2023 19:24​
RT10928	Open	Mel	7/13/2023 19:24​
RT10928	Processing	Mel	7/13/2023 19:26​
RT10928	Processing	Mel	7/13/2023 19:26​
RT10928	Open	Mel	7/13/2023 19:24​
RT10928	Open	Mel	7/13/2023 19:24​
SO10462	Processing	Mel	7/13/2023 15:40​
SO10462	Processing	Mel	7/13/2023 15:40​
SO10462	Processing	Mel	7/13/2023 15:40​
SO10462	Processing	Mel	7/13/2023 15:40​
SO10462	Processing	Mel	7/13/2023 15:40​
SO10462	Processing	Mel	7/13/2023 15:40​
SO10462	Processing	Mel	7/13/2023 15:40​
SO10462	Processing	Mel	7/13/2023 15:40​
SO10462	Processing	Mel	7/13/2023 15:40​
SO10462	Processing	Mel	7/13/2023 15:40​
SO10462	Processing	Mel	7/13/2023 15:40​
SO10462	Processing	Mel	7/13/2023 15:40​
SO10462	Processing	Mel	7/13/2023 15:40​
SO10462	Processing	Mel	7/13/2023 15:40​
SO10462	Processing	Mel	7/13/2023 15:40​
SO10462	Processing	Mel	7/13/2023 15:40​
SO10467	Processing	Mel	7/12/2023 18:55​
SO10467	Processing	Mel	7/12/2023 18:55​
SO10467	Processing	Mel	7/12/2023 18:55​
SO10467	Processing	Mel	7/12/2023 18:55​
SO10467	Processing	Mel	7/12/2023 18:55​
TR12291	Processing	Mel	7/12/2023 13:12​
TR12291	Processing	Mel	7/12/2023 13:12​
TR12354	Processing	Mel	7/13/2023 14:39​
TX10224	Processing	Mel	7/12/2023 20:24​
TX20910	Processing	Mel	7/12/2023 17:09​
TX20910	Processing	Mel	7/12/2023 17:09​
TX20910	Processing	Mel	7/12/2023 17:09​
TX20910	Processing	Mel	7/12/2023 17:09​
TX20910	Processing	Mel	7/12/2023 17:09​
TX20910	Processing	Mel	7/12/2023 17:09​
TX20910	Processing	Mel	7/12/2023 17:09​
TX20910	Processing	Mel	7/12/2023 17:09​
TX20910	Processing	Mel	7/12/2023 17:09​
TX20920	Processing	Mel	7/13/2023 17:09​
TX20920	Processing	Mel	7/13/2023 17:09​
TX20921	Processing	Mel	7/13/2023 17:09​
TX20921	Processing	Mel	7/13/2023 17:09​
TX20921	Processing	Mel	7/13/2023 17:09​
TX20921	Processing	Mel	7/13/2023 17:09​
TX20921	Processing	Mel	7/13/2023 17:09​
TX20921	Processing	Mel	7/13/2023 17:09​
TX20921	Processing	Mel	7/13/2023 17:09​
TX20921	Processing	Mel	7/13/2023 17:09​
TX20923	Processing	Mel	7/13/2023 17:35​
TX20923	Processing	Mel	7/13/2023 17:35​
TX20925	Processing	Mel	7/13/2023 17:35​
TX20925	Processing	Mel	7/13/2023 17:35​
TX20925	Processing	Mel	7/13/2023 17:35​
UT10626	Processing	Mel	7/12/2023 17:08​
UT10626	Processing	Mel	7/12/2023 17:08​
UT10626	Open	Mel	7/13/2023 16:10​
UT10626	Processing	Mel	7/13/2023 16:10​
UT10626	Processing	Mel	7/12/2023 17:08​
UT10626	Open	Mel	7/13/2023 16:10​
UT10626	Open	Mel	7/13/2023 16:10​
UT10626	Open	Mel	7/13/2023 16:10​
UT10626	Processing	Mel	7/13/2023 16:10​

 

[RattlingCarp3048]

try the formula under new

Book1
	A									J				N	O	P	Q	R	S
1	Code									Status				Last Changed	Last Changed Date
2																	before	new
3	AB23455									Processing				Mel	7/12/2023 17:57		1	2	Mel
4	AB23455									Processing				Mel	7/12/2023 17:57		1	1	VV
5	AB23455									Processing				Mel	7/12/2023 17:57		1	1	CD
6	AB23455									Processing				Mel	7/12/2023 17:57
7	AB23455									Processing				Mel	7/12/2023 17:57
8	AB23455									Processing				Mel	7/12/2023 17:57
9	AB23455									Processing				Mel	7/12/2023 17:57
10	AB23455									Processing				Mel	7/12/2023 17:57
11	AB23455									Processing				VV	7/13/2023 12:28
12	AB23455									Open				CD	7/13/2023 16:04
13	AB23455									Processing				Mel	7/13/2023 16:13
14	AB23455									Open				CD	7/13/2023 18:24
15	AB23455									Processing				CD	7/13/2023 18:30
16	AB23455									Processing				CD	7/13/2023 18:38
17	AB23455									Processing				CD	7/13/2023 18:42
IHC

Cell Formulas
Range	Formula
Q3:Q5	Q3	=IFERROR(ROWS(UNIQUE(FILTER(IHC!$A$3:$A$40000,(IHC!$N$3:$N$40000=S3)*((IHC!$J$3:$J$40000="Open")+(IHC!$J$3:$J$40000="Processing"))*(IHC!$D$3:$D$40000<>"Hemepath")))),"-")
R3:R5	R3	=IFERROR(ROWS(UNIQUE(FILTER(INT(IHC!$O$3:$O$40000),(IHC!$N$3:$N$40000=S3)*((IHC!$J$3:$J$40000="Open")+(IHC!$J$3:$J$40000="Processing"))*COUNTA(UNIQUE(IHC!$A$3:$A$40000))*(IHC!$D$3:$D$40000<>"Hemepath")))),"-")

ive been messing around with a few different formula options most of the day and still cannot seem to find anything. the most promissing ive been able to find is a sum(if(countifs))) nest but as soon as i add multiple criteria to the if statement it stops calculating. Any other thoughts to try?

 

[ExceLoki]

ive been messing around with a few different formula options most of the day and still cannot seem to find anything. the most promissing ive been able to find is a sum(if(countifs))) nest but as soon as i add multiple criteria to the if statement it stops calculating. Any other thoughts to try?

working on it between work

 

[ExceLoki]

with your last post of data set, i've come up with 'a' solution... if you can add a helper column.
-----------------

multiple posts solutions-v3.xlsx
	G	H
1	Name	Count
2	Mel	66
3	Bob	0
IHC

Cell Formulas
Range	Formula
H2:H3	H2	=IF(COUNTIF($D$2:$D$543,$G2)>0,COUNTA(UNIQUE(FILTER($F$2:$F$543,($F$2:$F$543<>"-")*($D$2:$D$543=$G2)))),0)

-----------------
I couldnt add all of the range using xl2bb, but you should be able to get it from here...

multiple posts solutions-v3.xlsx
	A	B	C	D	E	F
1	Code	Hemepath	Status	Last Changed	Last Changed Date	helper column
2	AB23442		Processing	Mel	7/12/2023 17:25	AB23442-45119
3	AB23442		Processing	Mel	7/12/2023 17:25	AB23442-45119
4	AB23442		Processing	Mel	7/12/2023 17:25	AB23442-45119
5	AB23442		Processing	Mel	7/12/2023 17:25	AB23442-45119
6	AB23442		Processing	Mel	7/12/2023 17:25	AB23442-45119
7	AB23442		Processing	Mel	7/12/2023 17:25	AB23442-45119
8	AB23442		Processing	Mel	7/12/2023 17:25	AB23442-45119
9	AB23442		Processing	Mel	7/12/2023 17:25	AB23442-45119
10	AB23442		Processing	Mel	7/12/2023 17:25	AB23442-45119
11	AB23442		Processing	Mel	7/12/2023 17:25	AB23442-45119
12	AB23442		Processing	Mel	7/12/2023 17:25	AB23442-45119
13	AB23443		Processing	Mel	7/12/2023 15:34	AB23443-45119
14	AB23443		Processing	Mel	7/12/2023 15:34	AB23443-45119
15	AB23443		Processing	Mel	7/12/2023 15:34	AB23443-45119
16	AB23443		Processing	Mel	7/12/2023 15:34	AB23443-45119
17	AB23443		Processing	Mel	7/12/2023 15:34	AB23443-45119
18	AB23443		Processing	Mel	7/12/2023 15:34	AB23443-45119
19	AB23443		Processing	Mel	7/12/2023 15:34	AB23443-45119
20	AB23443		Processing	Mel	7/12/2023 15:34	AB23443-45119
21	AB23448		Processing	Mel	7/12/2023 15:34	AB23448-45119
22	AB23448		Processing	Mel	7/12/2023 15:34	AB23448-45119
23	AB23448		Processing	Mel	7/12/2023 15:34	AB23448-45119
24	AB23448		Processing	Mel	7/12/2023 15:34	AB23448-45119
25	AB23448		Processing	Mel	7/12/2023 15:34	AB23448-45119
26	AB23448		Processing	Mel	7/12/2023 15:34	AB23448-45119
27	AB23448		Processing	Mel	7/12/2023 15:34	AB23448-45119
28	AB23448		Processing	Mel	7/12/2023 15:34	AB23448-45119
29	AB23450		Processing	Mel	7/12/2023 16:29	AB23450-45119
30	AB23450		Processing	Mel	7/12/2023 16:29	AB23450-45119
31	AB23451		Processing	Mel	7/12/2023 16:27	AB23451-45119
32	AB23451		Processing	Mel	7/12/2023 16:27	AB23451-45119
33	AB23452		Processing	Mel	7/12/2023 16:30	AB23452-45119
34	AB23452		Processing	Mel	7/12/2023 16:30	AB23452-45119
35	AB23452		Processing	Mel	7/12/2023 16:30	AB23452-45119
36	AB23452		Processing	Mel	7/12/2023 16:30	AB23452-45119
37	AB23453		Processing	Mel	7/12/2023 16:30	AB23453-45119
38	AB23453		Processing	Mel	7/12/2023 16:30	AB23453-45119
39	AB23454		Processing	Mel	7/12/2023 17:52	AB23454-45119
40	AB23454		Processing	Mel	7/12/2023 17:52	AB23454-45119
41	AB23454		Processing	Mel	7/12/2023 17:52	AB23454-45119
42	AB23454		Processing	Mel	7/12/2023 17:52	AB23454-45119
43	AB23454		Processing	Mel	7/12/2023 17:52	AB23454-45119
44	AB23454		Processing	Mel	7/12/2023 17:52	AB23454-45119
45	AB23454		Processing	Mel	7/12/2023 17:52	AB23454-45119
46	AB23455		Processing	Mel	7/12/2023 17:57	AB23455-45119
47	AB23455		Processing	Mel	7/12/2023 17:57	AB23455-45119
48	AB23455		Processing	Mel	7/12/2023 17:57	AB23455-45119
49	AB23455		Processing	Mel	7/12/2023 17:57	AB23455-45119
50	AB23455		Processing	Mel	7/12/2023 17:57	AB23455-45119
51	AB23455		Processing	Mel	7/12/2023 17:57	AB23455-45119
52	AB23455		Processing	Mel	7/12/2023 17:57	AB23455-45119
53	AB23455		Processing	Mel	7/12/2023 17:57	AB23455-45119
54	AB23455		Processing	Mel	7/13/2023 16:13	AB23455-45120
55	AB23456		Processing	Mel	7/12/2023 17:52	AB23456-45119
56	AB23456		Processing	Mel	7/12/2023 17:52	AB23456-45119
57	AB23456		Processing	Mel	7/12/2023 17:52	AB23456-45119
58	AB23456		Processing	Mel	7/12/2023 17:52	AB23456-45119
59	AB23457		Processing	Mel	7/12/2023 17:52	AB23457-45119
60	AB23457		Processing	Mel	7/12/2023 17:52	AB23457-45119
61	AB23457		Processing	Mel	7/12/2023 17:52	AB23457-45119
62	AB23442		Processing	Mel	7/12/2023 17:25	AB23442-45119
63	AB23442		Processing	Mel	7/12/2023 17:25	AB23442-45119
64	AB23442		Processing	Mel	7/12/2023 17:25	AB23442-45119
65	AB23442		Processing	Mel	7/12/2023 17:25	AB23442-45119
66	AB23442		Processing	Mel	7/12/2023 17:25	AB23442-45119
67	AB23442		Processing	Mel	7/12/2023 17:25	AB23442-45119
68	AB23442		Processing	Mel	7/12/2023 17:25	AB23442-45119
69	AB23442		Processing	Mel	7/12/2023 17:25	AB23442-45119
70	AB23442		Processing	Mel	7/12/2023 17:25	AB23442-45119
71	AB23442		Processing	Mel	7/12/2023 17:25	AB23442-45119
72	AB23442		Processing	Mel	7/12/2023 17:25	AB23442-45119
73	AB23443		Processing	Mel	7/12/2023 15:34	AB23443-45119
74	AB23443		Processing	Mel	7/12/2023 15:34	AB23443-45119
75	AB23443		Processing	Mel	7/12/2023 15:34	AB23443-45119
76	AB23443		Processing	Mel	7/12/2023 15:34	AB23443-45119
77	AB23443		Processing	Mel	7/12/2023 15:34	AB23443-45119
78	AB23443		Processing	Mel	7/12/2023 15:34	AB23443-45119
79	AB23443		Processing	Mel	7/12/2023 15:34	AB23443-45119
80	AB23443		Processing	Mel	7/12/2023 15:34	AB23443-45119
81	AB23448		Processing	Mel	7/12/2023 15:34	AB23448-45119
82	AB23448		Processing	Mel	7/12/2023 15:34	AB23448-45119
83	AB23448		Processing	Mel	7/12/2023 15:34	AB23448-45119
84	AB23448		Processing	Mel	7/12/2023 15:34	AB23448-45119
85	AB23448		Processing	Mel	7/12/2023 15:34	AB23448-45119
86	AB23448		Processing	Mel	7/12/2023 15:34	AB23448-45119
87	AB23448		Processing	Mel	7/12/2023 15:34	AB23448-45119
88	AB23448		Processing	Mel	7/12/2023 15:34	AB23448-45119
89	AB23450		Processing	Mel	7/12/2023 16:29	AB23450-45119
90	AB23450		Processing	Mel	7/12/2023 16:29	AB23450-45119
91	AB23451		Processing	Mel	7/12/2023 16:27	AB23451-45119
92	AB23451		Processing	Mel	7/12/2023 16:27	AB23451-45119
93	AB23452		Processing	Mel	7/12/2023 16:30	AB23452-45119
94	AB23452		Processing	Mel	7/12/2023 16:30	AB23452-45119
95	AB23452		Processing	Mel	7/12/2023 16:30	AB23452-45119
96	AB23452		Processing	Mel	7/12/2023 16:30	AB23452-45119
97	AB23453		Processing	Mel	7/12/2023 16:30	AB23453-45119
98	AB23453		Processing	Mel	7/12/2023 16:30	AB23453-45119
99	AB23454		Processing	Mel	7/12/2023 17:52	AB23454-45119
100	AB23454		Processing	Mel	7/12/2023 17:52	AB23454-45119
101	AB23454		Processing	Mel	7/12/2023 17:52	AB23454-45119
102	AB23454		Processing	Mel	7/12/2023 17:52	AB23454-45119
103	AB23454		Processing	Mel	7/12/2023 17:52	AB23454-45119
104	AB23454		Processing	Mel	7/12/2023 17:52	AB23454-45119
105	AB23454		Processing	Mel	7/12/2023 17:52	AB23454-45119
106	AB23455		Processing	Mel	7/12/2023 17:57	AB23455-45119
107	AB23455		Processing	Mel	7/12/2023 17:57	AB23455-45119
108	AB23455		Processing	Mel	7/12/2023 17:57	AB23455-45119
109	AB23455		Processing	Mel	7/12/2023 17:57	AB23455-45119
110	AB23455		Processing	Mel	7/12/2023 17:57	AB23455-45119
111	AB23455		Processing	Mel	7/12/2023 17:57	AB23455-45119
112	AB23455		Processing	Mel	7/12/2023 17:57	AB23455-45119
113	AB23455		Processing	Mel	7/12/2023 17:57	AB23455-45119
114	AB23455		Processing	Mel	7/13/2023 16:13	AB23455-45120
115	AB23456		Processing	Mel	7/12/2023 17:52	AB23456-45119
116	AB23456		Processing	Mel	7/12/2023 17:52	AB23456-45119
117	AB23456		Processing	Mel	7/12/2023 17:52	AB23456-45119
118	AB23456		Processing	Mel	7/12/2023 17:52	AB23456-45119
119	AB23457		Processing	Mel	7/12/2023 17:52	AB23457-45119
120	AB23457		Processing	Mel	7/12/2023 17:52	AB23457-45119
121	AB23457		Processing	Mel	7/12/2023 17:52	AB23457-45119
122	AB23457		Processing	Mel	7/12/2023 17:52	AB23457-45119
123	AB23457		Processing	Mel	7/12/2023 17:52	AB23457-45119
124	AB23457		Processing	Mel	7/12/2023 17:52	AB23457-45119
125	AB23457		Processing	Mel	7/12/2023 17:52	AB23457-45119
126	AB23458		Processing	Mel	7/13/2023 17:30	AB23458-45120
127	AB23458		Processing	Mel	7/13/2023 17:30	AB23458-45120
128	AB23458		Processing	Mel	7/13/2023 17:30	AB23458-45120
129	AB23458		Processing	Mel	7/13/2023 17:30	AB23458-45120
130	AB23458		Processing	Mel	7/13/2023 17:30	AB23458-45120
131	AB23458		Processing	Mel	7/13/2023 17:30	AB23458-45120
132	AB23458		Processing	Mel	7/13/2023 17:30	AB23458-45120
133	AB23459		Processing	Mel	7/13/2023 17:36	AB23459-45120
134	AB23459		Processing	Mel	7/13/2023 17:36	AB23459-45120
135	AB23459		Processing	Mel	7/13/2023 17:36	AB23459-45120
136	AB23459		Processing	Mel	7/13/2023 17:36	AB23459-45120
137	AB23460		Processing	Mel	7/13/2023 15:43	AB23460-45120
138	AB23461		Processing	Mel	7/13/2023 15:42	AB23461-45120
139	AB23461		Processing	Mel	7/13/2023 15:42	AB23461-45120
140	AB23461		Processing	Mel	7/13/2023 15:42	AB23461-45120
141	AB23461		Processing	Mel	7/13/2023 15:42	AB23461-45120
142	AB23461		Processing	Mel	7/13/2023 15:42	AB23461-45120
143	AB23461		Processing	Mel	7/13/2023 15:42	AB23461-45120
144	AB23461		Processing	Mel	7/13/2023 15:42	AB23461-45120
145	AB23464		Processing	Mel	7/13/2023 16:12	AB23464-45120
146	AB23464		Processing	Mel	7/13/2023 16:12	AB23464-45120
147	AB23464		Processing	Mel	7/13/2023 16:12	AB23464-45120
148	AB23464		Processing	Mel	7/13/2023 16:12	AB23464-45120
149	AB23464		Processing	Mel	7/13/2023 16:12	AB23464-45120
150	AB23464		Processing	Mel	7/13/2023 16:12	AB23464-45120
151	AB23464		Processing	Mel	7/13/2023 16:12	AB23464-45120
152	AB23464		Processing	Mel	7/13/2023 16:12	AB23464-45120
153	AB23464		Processing	Mel	7/13/2023 16:12	AB23464-45120
154	AB23464		Processing	Mel	7/13/2023 16:12	AB23464-45120
155	AB23464		Processing	Mel	7/13/2023 16:12	AB23464-45120
156	AB23464		Processing	Mel	7/13/2023 16:12	AB23464-45120
157	AB23464		Processing	Mel	7/13/2023 16:54	AB23464-45120
158	AB23464		Processing	Mel	7/13/2023 16:12	AB23464-45120
159	AB23464		Processing	Mel	7/13/2023 16:54	AB23464-45120
160	AB23464		Processing	Mel	7/13/2023 16:54	AB23464-45120
161	AB23464		Processing	Mel	7/13/2023 16:54	AB23464-45120
162	AB23464		Processing	Mel	7/13/2023 16:54	AB23464-45120
163	AB23464		Processing	Mel	7/13/2023 16:54	AB23464-45120
164	AB23464		Processing	Mel	7/13/2023 16:54	AB23464-45120
165	AB23464		Processing	Mel	7/13/2023 16:54	AB23464-45120
166	AB23464		Processing	Mel	7/13/2023 16:54	AB23464-45120
167	AB23464		Processing	Mel	7/13/2023 16:54	AB23464-45120
168	AO30385		Processing	Mel	7/13/2023 15:42	AO30385-45120
169	AO30385		Open	Mel	7/13/2023 15:18	AO30385-45120
170	AS233118		Processing	Mel	7/13/2023 12:04	AS233118-45120
171	AS233118		Processing	Mel	7/13/2023 12:04	AS233118-45120
172	AS233140		Processing	Mel	7/13/2023 16:38	AS233140-45120
173	AS233140		Processing	Mel	7/13/2023 16:38	AS233140-45120
174	AS233140		Processing	Mel	7/13/2023 16:38	AS233140-45120
175	AS233140		Processing	Mel	7/13/2023 16:38	AS233140-45120
176	AS233140		Processing	Mel	7/13/2023 16:38	AS233140-45120
177	AS233140		Processing	Mel	7/13/2023 16:38	AS233140-45120
178	AS233159		Processing	Mel	7/12/2023 16:34	AS233159-45119
179	AS233159		Processing	Mel	7/12/2023 16:34	AS233159-45119
180	AS233159		Processing	Mel	7/12/2023 16:34	AS233159-45119
181	AS233159		Processing	Mel	7/12/2023 16:34	AS233159-45119
182	AS233159		Processing	Mel	7/12/2023 16:34	AS233159-45119
183	AS233159		Processing	Mel	7/12/2023 16:34	AS233159-45119
184	AS233159		Processing	Mel	7/12/2023 16:34	AS233159-45119
185	AS233159		Processing	Mel	7/12/2023 16:34	AS233159-45119
186	AS233159		Processing	Mel	7/12/2023 16:34	AS233159-45119
187	AS233169		Processing	Mel	7/12/2023 16:36	AS233169-45119
188	AS233169		Processing	Mel	7/12/2023 16:36	AS233169-45119
189	AS233169		Processing	Mel	7/12/2023 16:36	AS233169-45119
190	AS233169		Processing	Mel	7/12/2023 16:36	AS233169-45119
191	AS233173		Processing	Mel	7/12/2023 17:26	AS233173-45119
192	AS233173		Processing	Mel	7/12/2023 17:26	AS233173-45119
193	AS233173		Processing	Mel	7/12/2023 17:26	AS233173-45119
194	AS233173		Processing	Mel	7/12/2023 17:26	AS233173-45119
195	AS233173		Processing	Mel	7/12/2023 17:26	AS233173-45119
196	AS233173		Processing	Mel	7/12/2023 17:26	AS233173-45119
197	AS233173		Processing	Mel	7/13/2023 12:23	AS233173-45120
198	AS233173		Processing	Mel	7/13/2023 16:41	AS233173-45120
199	AS233173		Processing	Mel	7/13/2023 16:41	AS233173-45120
200	AS233173		Processing	Mel	7/13/2023 16:41	AS233173-45120
201	AS233173		Processing	Mel	7/13/2023 16:41	AS233173-45120
202	AS233173		Processing	Mel	7/13/2023 16:41	AS233173-45120
203	AS233173		Processing	Mel	7/13/2023 16:41	AS233173-45120
204	AS233191		Processing	Mel	7/13/2023 16:40	AS233191-45120
205	AS233191		Processing	Mel	7/13/2023 16:40	AS233191-45120
206	AS233191		Processing	Mel	7/13/2023 16:40	AS233191-45120
207	AS233191		Processing	Mel	7/13/2023 16:40	AS233191-45120
208	AS233193		Processing	Mel	7/13/2023 16:50	AS233193-45120
209	AS233193		Processing	Mel	7/13/2023 16:50	AS233193-45120
210	BF551		Open	Mel	7/12/2023 13:16	BF551-45119
211	BF551		Processing	Mel	7/12/2023 13:25	BF551-45119
212	BF551		Processing	Mel	7/12/2023 13:25	BF551-45119
213	BF551		Open	Mel	7/12/2023 13:16	BF551-45119
214	BF551		Open	Mel	7/12/2023 13:16	BF551-45119
215	BF551		Processing	Mel	7/12/2023 13:25	BF551-45119
216	BF551		Open	Mel	7/12/2023 13:16	BF551-45119
217	BF551		Processing	Mel	7/12/2023 13:25	BF551-45119
218	BS7639		Processing	Mel	7/12/2023 13:22	BS7639-45119
219	BS7639		Processing	Mel	7/12/2023 13:22	BS7639-45119
220	BS7639		Open	Mel	7/12/2023 13:13	BS7639-45119
221	BS7639		Open	Mel	7/12/2023 13:13	BS7639-45119
222	BS7639		Processing	Mel	7/12/2023 13:22	BS7639-45119
223	BS7639		Open	Mel	7/12/2023 13:13	BS7639-45119
224	BS7639		Open	Mel	7/12/2023 13:13	BS7639-45119
225	BS7639		Processing	Mel	7/12/2023 13:22	BS7639-45119
226	BS7639		Open	Mel	7/12/2023 13:13	BS7639-45119
227	BS7639		Processing	Mel	7/12/2023 13:22	BS7639-45119
228	BS7639		Processing	Mel	7/12/2023 13:22	BS7639-45119
229	BS7639		Open	Mel	7/12/2023 13:13	BS7639-45119
230	BS7640		Open	Mel	7/12/2023 13:15	BS7640-45119
231	BS7640		Open	Mel	7/12/2023 13:15	BS7640-45119
232	BS7640		Processing	Mel	7/12/2023 13:24	BS7640-45119
233	BS7640		Processing	Mel	7/12/2023 13:24	BS7640-45119
234	BS7640		Processing	Mel	7/12/2023 13:24	BS7640-45119
235	BS7640		Processing	Mel	7/12/2023 13:24	BS7640-45119
236	BS7640		Open	Mel	7/12/2023 13:15	BS7640-45119
237	BS7640		Open	Mel	7/12/2023 13:15	BS7640-45119
238	BS7640		Open	Mel	7/12/2023 13:15	BS7640-45119
239	BS7640		Processing	Mel	7/12/2023 13:24	BS7640-45119
240	BS7640		Open	Mel	7/12/2023 13:15	BS7640-45119
241	BS7640		Processing	Mel	7/12/2023 13:24	BS7640-45119
242	BS7642		Processing	Mel	7/12/2023 13:25	BS7642-45119
243	BS7642		Open	Mel	7/12/2023 13:15	BS7642-45119
244	BS7642		Processing	Mel	7/12/2023 13:25	BS7642-45119
245	BS7642		Open	Mel	7/12/2023 13:15	BS7642-45119
246	BS7642		Open	Mel	7/12/2023 13:15	BS7642-45119
247	BS7642		Processing	Mel	7/12/2023 13:25	BS7642-45119
248	BS7642		Processing	Mel	7/12/2023 13:25	BS7642-45119
249	BS7642		Open	Mel	7/12/2023 13:15	BS7642-45119
250	BS7678		Processing	Mel	7/12/2023 13:23	BS7678-45119
251	BS7678		Open	Mel	7/12/2023 13:14	BS7678-45119
IHC

Cell Formulas
Range	Formula
F2:F251	F2	=IF(AND(OR(C2="Processing",C2="Open"),B2<>"Hemepath"),TEXTJOIN("-",TRUE,A2,INT(E2)),"-")

 

[RattlingCarp3048]

with your last post of data set, i've come up with 'a' solution... if you can add a helper column.
-----------------

multiple posts solutions-v3.xlsx
	G	H
1	Name	Count
2	Mel	66
3	Bob	0
IHC

Cell Formulas
Range	Formula
H2:H3	H2	=IF(COUNTIF($D$2:$D$543,$G2)>0,COUNTA(UNIQUE(FILTER($F$2:$F$543,($F$2:$F$543<>"-")*($D$2:$D$543=$G2)))),0)

-----------------
I couldnt add all of the range using xl2bb, but you should be able to get it from here...

multiple posts solutions-v3.xlsx
	A	B	C	D	E	F
1	Code	Hemepath	Status	Last Changed	Last Changed Date	helper column
2	AB23442		Processing	Mel	7/12/2023 17:25	AB23442-45119
3	AB23442		Processing	Mel	7/12/2023 17:25	AB23442-45119
4	AB23442		Processing	Mel	7/12/2023 17:25	AB23442-45119
5	AB23442		Processing	Mel	7/12/2023 17:25	AB23442-45119
6	AB23442		Processing	Mel	7/12/2023 17:25	AB23442-45119
7	AB23442		Processing	Mel	7/12/2023 17:25	AB23442-45119
8	AB23442		Processing	Mel	7/12/2023 17:25	AB23442-45119
9	AB23442		Processing	Mel	7/12/2023 17:25	AB23442-45119
10	AB23442		Processing	Mel	7/12/2023 17:25	AB23442-45119
11	AB23442		Processing	Mel	7/12/2023 17:25	AB23442-45119
12	AB23442		Processing	Mel	7/12/2023 17:25	AB23442-45119
13	AB23443		Processing	Mel	7/12/2023 15:34	AB23443-45119
14	AB23443		Processing	Mel	7/12/2023 15:34	AB23443-45119
15	AB23443		Processing	Mel	7/12/2023 15:34	AB23443-45119
16	AB23443		Processing	Mel	7/12/2023 15:34	AB23443-45119
17	AB23443		Processing	Mel	7/12/2023 15:34	AB23443-45119
18	AB23443		Processing	Mel	7/12/2023 15:34	AB23443-45119
19	AB23443		Processing	Mel	7/12/2023 15:34	AB23443-45119
20	AB23443		Processing	Mel	7/12/2023 15:34	AB23443-45119
21	AB23448		Processing	Mel	7/12/2023 15:34	AB23448-45119
22	AB23448		Processing	Mel	7/12/2023 15:34	AB23448-45119
23	AB23448		Processing	Mel	7/12/2023 15:34	AB23448-45119
24	AB23448		Processing	Mel	7/12/2023 15:34	AB23448-45119
25	AB23448		Processing	Mel	7/12/2023 15:34	AB23448-45119
26	AB23448		Processing	Mel	7/12/2023 15:34	AB23448-45119
27	AB23448		Processing	Mel	7/12/2023 15:34	AB23448-45119
28	AB23448		Processing	Mel	7/12/2023 15:34	AB23448-45119
29	AB23450		Processing	Mel	7/12/2023 16:29	AB23450-45119
30	AB23450		Processing	Mel	7/12/2023 16:29	AB23450-45119
31	AB23451		Processing	Mel	7/12/2023 16:27	AB23451-45119
32	AB23451		Processing	Mel	7/12/2023 16:27	AB23451-45119
33	AB23452		Processing	Mel	7/12/2023 16:30	AB23452-45119
34	AB23452		Processing	Mel	7/12/2023 16:30	AB23452-45119
35	AB23452		Processing	Mel	7/12/2023 16:30	AB23452-45119
36	AB23452		Processing	Mel	7/12/2023 16:30	AB23452-45119
37	AB23453		Processing	Mel	7/12/2023 16:30	AB23453-45119
38	AB23453		Processing	Mel	7/12/2023 16:30	AB23453-45119
39	AB23454		Processing	Mel	7/12/2023 17:52	AB23454-45119
40	AB23454		Processing	Mel	7/12/2023 17:52	AB23454-45119
41	AB23454		Processing	Mel	7/12/2023 17:52	AB23454-45119
42	AB23454		Processing	Mel	7/12/2023 17:52	AB23454-45119
43	AB23454		Processing	Mel	7/12/2023 17:52	AB23454-45119
44	AB23454		Processing	Mel	7/12/2023 17:52	AB23454-45119
45	AB23454		Processing	Mel	7/12/2023 17:52	AB23454-45119
46	AB23455		Processing	Mel	7/12/2023 17:57	AB23455-45119
47	AB23455		Processing	Mel	7/12/2023 17:57	AB23455-45119
48	AB23455		Processing	Mel	7/12/2023 17:57	AB23455-45119
49	AB23455		Processing	Mel	7/12/2023 17:57	AB23455-45119
50	AB23455		Processing	Mel	7/12/2023 17:57	AB23455-45119
51	AB23455		Processing	Mel	7/12/2023 17:57	AB23455-45119
52	AB23455		Processing	Mel	7/12/2023 17:57	AB23455-45119
53	AB23455		Processing	Mel	7/12/2023 17:57	AB23455-45119
54	AB23455		Processing	Mel	7/13/2023 16:13	AB23455-45120
55	AB23456		Processing	Mel	7/12/2023 17:52	AB23456-45119
56	AB23456		Processing	Mel	7/12/2023 17:52	AB23456-45119
57	AB23456		Processing	Mel	7/12/2023 17:52	AB23456-45119
58	AB23456		Processing	Mel	7/12/2023 17:52	AB23456-45119
59	AB23457		Processing	Mel	7/12/2023 17:52	AB23457-45119
60	AB23457		Processing	Mel	7/12/2023 17:52	AB23457-45119
61	AB23457		Processing	Mel	7/12/2023 17:52	AB23457-45119
62	AB23442		Processing	Mel	7/12/2023 17:25	AB23442-45119
63	AB23442		Processing	Mel	7/12/2023 17:25	AB23442-45119
64	AB23442		Processing	Mel	7/12/2023 17:25	AB23442-45119
65	AB23442		Processing	Mel	7/12/2023 17:25	AB23442-45119
66	AB23442		Processing	Mel	7/12/2023 17:25	AB23442-45119
67	AB23442		Processing	Mel	7/12/2023 17:25	AB23442-45119
68	AB23442		Processing	Mel	7/12/2023 17:25	AB23442-45119
69	AB23442		Processing	Mel	7/12/2023 17:25	AB23442-45119
70	AB23442		Processing	Mel	7/12/2023 17:25	AB23442-45119
71	AB23442		Processing	Mel	7/12/2023 17:25	AB23442-45119
72	AB23442		Processing	Mel	7/12/2023 17:25	AB23442-45119
73	AB23443		Processing	Mel	7/12/2023 15:34	AB23443-45119
74	AB23443		Processing	Mel	7/12/2023 15:34	AB23443-45119
75	AB23443		Processing	Mel	7/12/2023 15:34	AB23443-45119
76	AB23443		Processing	Mel	7/12/2023 15:34	AB23443-45119
77	AB23443		Processing	Mel	7/12/2023 15:34	AB23443-45119
78	AB23443		Processing	Mel	7/12/2023 15:34	AB23443-45119
79	AB23443		Processing	Mel	7/12/2023 15:34	AB23443-45119
80	AB23443		Processing	Mel	7/12/2023 15:34	AB23443-45119
81	AB23448		Processing	Mel	7/12/2023 15:34	AB23448-45119
82	AB23448		Processing	Mel	7/12/2023 15:34	AB23448-45119
83	AB23448		Processing	Mel	7/12/2023 15:34	AB23448-45119
84	AB23448		Processing	Mel	7/12/2023 15:34	AB23448-45119
85	AB23448		Processing	Mel	7/12/2023 15:34	AB23448-45119
86	AB23448		Processing	Mel	7/12/2023 15:34	AB23448-45119
87	AB23448		Processing	Mel	7/12/2023 15:34	AB23448-45119
88	AB23448		Processing	Mel	7/12/2023 15:34	AB23448-45119
89	AB23450		Processing	Mel	7/12/2023 16:29	AB23450-45119
90	AB23450		Processing	Mel	7/12/2023 16:29	AB23450-45119
91	AB23451		Processing	Mel	7/12/2023 16:27	AB23451-45119
92	AB23451		Processing	Mel	7/12/2023 16:27	AB23451-45119
93	AB23452		Processing	Mel	7/12/2023 16:30	AB23452-45119
94	AB23452		Processing	Mel	7/12/2023 16:30	AB23452-45119
95	AB23452		Processing	Mel	7/12/2023 16:30	AB23452-45119
96	AB23452		Processing	Mel	7/12/2023 16:30	AB23452-45119
97	AB23453		Processing	Mel	7/12/2023 16:30	AB23453-45119
98	AB23453		Processing	Mel	7/12/2023 16:30	AB23453-45119
99	AB23454		Processing	Mel	7/12/2023 17:52	AB23454-45119
100	AB23454		Processing	Mel	7/12/2023 17:52	AB23454-45119
101	AB23454		Processing	Mel	7/12/2023 17:52	AB23454-45119
102	AB23454		Processing	Mel	7/12/2023 17:52	AB23454-45119
103	AB23454		Processing	Mel	7/12/2023 17:52	AB23454-45119
104	AB23454		Processing	Mel	7/12/2023 17:52	AB23454-45119
105	AB23454		Processing	Mel	7/12/2023 17:52	AB23454-45119
106	AB23455		Processing	Mel	7/12/2023 17:57	AB23455-45119
107	AB23455		Processing	Mel	7/12/2023 17:57	AB23455-45119
108	AB23455		Processing	Mel	7/12/2023 17:57	AB23455-45119
109	AB23455		Processing	Mel	7/12/2023 17:57	AB23455-45119
110	AB23455		Processing	Mel	7/12/2023 17:57	AB23455-45119
111	AB23455		Processing	Mel	7/12/2023 17:57	AB23455-45119
112	AB23455		Processing	Mel	7/12/2023 17:57	AB23455-45119
113	AB23455		Processing	Mel	7/12/2023 17:57	AB23455-45119
114	AB23455		Processing	Mel	7/13/2023 16:13	AB23455-45120
115	AB23456		Processing	Mel	7/12/2023 17:52	AB23456-45119
116	AB23456		Processing	Mel	7/12/2023 17:52	AB23456-45119
117	AB23456		Processing	Mel	7/12/2023 17:52	AB23456-45119
118	AB23456		Processing	Mel	7/12/2023 17:52	AB23456-45119
119	AB23457		Processing	Mel	7/12/2023 17:52	AB23457-45119
120	AB23457		Processing	Mel	7/12/2023 17:52	AB23457-45119
121	AB23457		Processing	Mel	7/12/2023 17:52	AB23457-45119
122	AB23457		Processing	Mel	7/12/2023 17:52	AB23457-45119
123	AB23457		Processing	Mel	7/12/2023 17:52	AB23457-45119
124	AB23457		Processing	Mel	7/12/2023 17:52	AB23457-45119
125	AB23457		Processing	Mel	7/12/2023 17:52	AB23457-45119
126	AB23458		Processing	Mel	7/13/2023 17:30	AB23458-45120
127	AB23458		Processing	Mel	7/13/2023 17:30	AB23458-45120
128	AB23458		Processing	Mel	7/13/2023 17:30	AB23458-45120
129	AB23458		Processing	Mel	7/13/2023 17:30	AB23458-45120
130	AB23458		Processing	Mel	7/13/2023 17:30	AB23458-45120
131	AB23458		Processing	Mel	7/13/2023 17:30	AB23458-45120
132	AB23458		Processing	Mel	7/13/2023 17:30	AB23458-45120
133	AB23459		Processing	Mel	7/13/2023 17:36	AB23459-45120
134	AB23459		Processing	Mel	7/13/2023 17:36	AB23459-45120
135	AB23459		Processing	Mel	7/13/2023 17:36	AB23459-45120
136	AB23459		Processing	Mel	7/13/2023 17:36	AB23459-45120
137	AB23460		Processing	Mel	7/13/2023 15:43	AB23460-45120
138	AB23461		Processing	Mel	7/13/2023 15:42	AB23461-45120
139	AB23461		Processing	Mel	7/13/2023 15:42	AB23461-45120
140	AB23461		Processing	Mel	7/13/2023 15:42	AB23461-45120
141	AB23461		Processing	Mel	7/13/2023 15:42	AB23461-45120
142	AB23461		Processing	Mel	7/13/2023 15:42	AB23461-45120
143	AB23461		Processing	Mel	7/13/2023 15:42	AB23461-45120
144	AB23461		Processing	Mel	7/13/2023 15:42	AB23461-45120
145	AB23464		Processing	Mel	7/13/2023 16:12	AB23464-45120
146	AB23464		Processing	Mel	7/13/2023 16:12	AB23464-45120
147	AB23464		Processing	Mel	7/13/2023 16:12	AB23464-45120
148	AB23464		Processing	Mel	7/13/2023 16:12	AB23464-45120
149	AB23464		Processing	Mel	7/13/2023 16:12	AB23464-45120
150	AB23464		Processing	Mel	7/13/2023 16:12	AB23464-45120
151	AB23464		Processing	Mel	7/13/2023 16:12	AB23464-45120
152	AB23464		Processing	Mel	7/13/2023 16:12	AB23464-45120
153	AB23464		Processing	Mel	7/13/2023 16:12	AB23464-45120
154	AB23464		Processing	Mel	7/13/2023 16:12	AB23464-45120
155	AB23464		Processing	Mel	7/13/2023 16:12	AB23464-45120
156	AB23464		Processing	Mel	7/13/2023 16:12	AB23464-45120
157	AB23464		Processing	Mel	7/13/2023 16:54	AB23464-45120
158	AB23464		Processing	Mel	7/13/2023 16:12	AB23464-45120
159	AB23464		Processing	Mel	7/13/2023 16:54	AB23464-45120
160	AB23464		Processing	Mel	7/13/2023 16:54	AB23464-45120
161	AB23464		Processing	Mel	7/13/2023 16:54	AB23464-45120
162	AB23464		Processing	Mel	7/13/2023 16:54	AB23464-45120
163	AB23464		Processing	Mel	7/13/2023 16:54	AB23464-45120
164	AB23464		Processing	Mel	7/13/2023 16:54	AB23464-45120
165	AB23464		Processing	Mel	7/13/2023 16:54	AB23464-45120
166	AB23464		Processing	Mel	7/13/2023 16:54	AB23464-45120
167	AB23464		Processing	Mel	7/13/2023 16:54	AB23464-45120
168	AO30385		Processing	Mel	7/13/2023 15:42	AO30385-45120
169	AO30385		Open	Mel	7/13/2023 15:18	AO30385-45120
170	AS233118		Processing	Mel	7/13/2023 12:04	AS233118-45120
171	AS233118		Processing	Mel	7/13/2023 12:04	AS233118-45120
172	AS233140		Processing	Mel	7/13/2023 16:38	AS233140-45120
173	AS233140		Processing	Mel	7/13/2023 16:38	AS233140-45120
174	AS233140		Processing	Mel	7/13/2023 16:38	AS233140-45120
175	AS233140		Processing	Mel	7/13/2023 16:38	AS233140-45120
176	AS233140		Processing	Mel	7/13/2023 16:38	AS233140-45120
177	AS233140		Processing	Mel	7/13/2023 16:38	AS233140-45120
178	AS233159		Processing	Mel	7/12/2023 16:34	AS233159-45119
179	AS233159		Processing	Mel	7/12/2023 16:34	AS233159-45119
180	AS233159		Processing	Mel	7/12/2023 16:34	AS233159-45119
181	AS233159		Processing	Mel	7/12/2023 16:34	AS233159-45119
182	AS233159		Processing	Mel	7/12/2023 16:34	AS233159-45119
183	AS233159		Processing	Mel	7/12/2023 16:34	AS233159-45119
184	AS233159		Processing	Mel	7/12/2023 16:34	AS233159-45119
185	AS233159		Processing	Mel	7/12/2023 16:34	AS233159-45119
186	AS233159		Processing	Mel	7/12/2023 16:34	AS233159-45119
187	AS233169		Processing	Mel	7/12/2023 16:36	AS233169-45119
188	AS233169		Processing	Mel	7/12/2023 16:36	AS233169-45119
189	AS233169		Processing	Mel	7/12/2023 16:36	AS233169-45119
190	AS233169		Processing	Mel	7/12/2023 16:36	AS233169-45119
191	AS233173		Processing	Mel	7/12/2023 17:26	AS233173-45119
192	AS233173		Processing	Mel	7/12/2023 17:26	AS233173-45119
193	AS233173		Processing	Mel	7/12/2023 17:26	AS233173-45119
194	AS233173		Processing	Mel	7/12/2023 17:26	AS233173-45119
195	AS233173		Processing	Mel	7/12/2023 17:26	AS233173-45119
196	AS233173		Processing	Mel	7/12/2023 17:26	AS233173-45119
197	AS233173		Processing	Mel	7/13/2023 12:23	AS233173-45120
198	AS233173		Processing	Mel	7/13/2023 16:41	AS233173-45120
199	AS233173		Processing	Mel	7/13/2023 16:41	AS233173-45120
200	AS233173		Processing	Mel	7/13/2023 16:41	AS233173-45120
201	AS233173		Processing	Mel	7/13/2023 16:41	AS233173-45120
202	AS233173		Processing	Mel	7/13/2023 16:41	AS233173-45120
203	AS233173		Processing	Mel	7/13/2023 16:41	AS233173-45120
204	AS233191		Processing	Mel	7/13/2023 16:40	AS233191-45120
205	AS233191		Processing	Mel	7/13/2023 16:40	AS233191-45120
206	AS233191		Processing	Mel	7/13/2023 16:40	AS233191-45120
207	AS233191		Processing	Mel	7/13/2023 16:40	AS233191-45120
208	AS233193		Processing	Mel	7/13/2023 16:50	AS233193-45120
209	AS233193		Processing	Mel	7/13/2023 16:50	AS233193-45120
210	BF551		Open	Mel	7/12/2023 13:16	BF551-45119
211	BF551		Processing	Mel	7/12/2023 13:25	BF551-45119
212	BF551		Processing	Mel	7/12/2023 13:25	BF551-45119
213	BF551		Open	Mel	7/12/2023 13:16	BF551-45119
214	BF551		Open	Mel	7/12/2023 13:16	BF551-45119
215	BF551		Processing	Mel	7/12/2023 13:25	BF551-45119
216	BF551		Open	Mel	7/12/2023 13:16	BF551-45119
217	BF551		Processing	Mel	7/12/2023 13:25	BF551-45119
218	BS7639		Processing	Mel	7/12/2023 13:22	BS7639-45119
219	BS7639		Processing	Mel	7/12/2023 13:22	BS7639-45119
220	BS7639		Open	Mel	7/12/2023 13:13	BS7639-45119
221	BS7639		Open	Mel	7/12/2023 13:13	BS7639-45119
222	BS7639		Processing	Mel	7/12/2023 13:22	BS7639-45119
223	BS7639		Open	Mel	7/12/2023 13:13	BS7639-45119
224	BS7639		Open	Mel	7/12/2023 13:13	BS7639-45119
225	BS7639		Processing	Mel	7/12/2023 13:22	BS7639-45119
226	BS7639		Open	Mel	7/12/2023 13:13	BS7639-45119
227	BS7639		Processing	Mel	7/12/2023 13:22	BS7639-45119
228	BS7639		Processing	Mel	7/12/2023 13:22	BS7639-45119
229	BS7639		Open	Mel	7/12/2023 13:13	BS7639-45119
230	BS7640		Open	Mel	7/12/2023 13:15	BS7640-45119
231	BS7640		Open	Mel	7/12/2023 13:15	BS7640-45119
232	BS7640		Processing	Mel	7/12/2023 13:24	BS7640-45119
233	BS7640		Processing	Mel	7/12/2023 13:24	BS7640-45119
234	BS7640		Processing	Mel	7/12/2023 13:24	BS7640-45119
235	BS7640		Processing	Mel	7/12/2023 13:24	BS7640-45119
236	BS7640		Open	Mel	7/12/2023 13:15	BS7640-45119
237	BS7640		Open	Mel	7/12/2023 13:15	BS7640-45119
238	BS7640		Open	Mel	7/12/2023 13:15	BS7640-45119
239	BS7640		Processing	Mel	7/12/2023 13:24	BS7640-45119
240	BS7640		Open	Mel	7/12/2023 13:15	BS7640-45119
241	BS7640		Processing	Mel	7/12/2023 13:24	BS7640-45119
242	BS7642		Processing	Mel	7/12/2023 13:25	BS7642-45119
243	BS7642		Open	Mel	7/12/2023 13:15	BS7642-45119
244	BS7642		Processing	Mel	7/12/2023 13:25	BS7642-45119
245	BS7642		Open	Mel	7/12/2023 13:15	BS7642-45119
246	BS7642		Open	Mel	7/12/2023 13:15	BS7642-45119
247	BS7642		Processing	Mel	7/12/2023 13:25	BS7642-45119
248	BS7642		Processing	Mel	7/12/2023 13:25	BS7642-45119
249	BS7642		Open	Mel	7/12/2023 13:15	BS7642-45119
250	BS7678		Processing	Mel	7/12/2023 13:23	BS7678-45119
251	BS7678		Open	Mel	7/12/2023 13:14	BS7678-45119
IHC

Cell Formulas
Range	Formula
F2:F251	F2	=IF(AND(OR(C2="Processing",C2="Open"),B2<>"Hemepath"),TEXTJOIN("-",TRUE,A2,INT(E2)),"-")

Sorry for the delay in my response. i didnt realize you responded. i truely appreciate all the effort you put in trying to help with this. unfortunately this is just a really tricky one-off. apparently needing to count rows(unique(filter())) with multiple criteria and where you have 2 unique columns isnt very common. maybe this will help someone else.

1.) in the original post i needed unique values from both A and O but with a helper column it became A and E. The filter array was originally only A:A but with multiple unique columns it needed to be the 1st and last unique columns plus my criteria so i built the filter function:​

1.) FILTER(IHC!$A$3:$E$40000,(IHC!$Q$3:$Q$40000=Summary!B9)*((IHC!$M$3:$M$40000="Open")+(IHC!$M$3:$M$40000="Processing"))*(IHC!$G$3:$G$40000<>"Hemepath"))​

2.) Because i have multiple unique columns i needed to count I needed to wrap the whole thing in another filter() where the above base formula is now the array and true/false the columns to include. Since i need a combo unique value from both A and E it became (1,0,0,0,1).​

2.) FILTER(FILTER(IHC!$A$3:$E$40000,(IHC!$Q$3:$Q$40000=Summary!B9)*((IHC!$M$3:$M$40000="Open")+(IHC!$M$3:$M$40000="Processing"))*(IHC!$G$3:$G$40000<>"Hemepath")),{1,0,0,0,1})​

​

3.) From there wrap the whole thing again in the rows(unique()) functions to get the unique counts so I ended up with this​

3.) ROWS(UNIQUE(FILTER(FILTER(IHC!$A$3:$E$40000,(IHC!$Q$3:$Q$40000=Summary!B9)*((IHC!$M$3:$M$40000="Open")+(IHC!$M$3:$M$40000="Processing"))*(IHC!$G$3:$G$40000<>"Hemepath")),{1,0,0,0,1})))​

Another example would be if i needed unique values from B and C and K then the array portion would be B:K in the first fiter and the include of the second filter would be (1,1,0,0,0,0,0,0,0,1).