I have this formula currently
COUNTIFS('RAW Data 2'!$R$2:$R$10000,"*"&$BG3&"*",'RAW Data 2'!$O$2:$O$10000,">="&(TODAY()-$BI$1))
Range R2:R10000 contains a list of values where my value in BG3 may be an exact text string match, or a partial text string match
Range O2:O10000 contains a list of dates/times where among my criteria is I'm also counting if the date/time date in that range is more recent than today's date minus however many days I want to look back defined in cell BI1
I want to add a 3rd criteria where I look at range 'RAW Data 2'!$B$2:$B$10000 as well, and only count IF BG3 is a full or partial match in range R2:R100000, and the date/time in range O2:O10000, is more recent than today's date minus however many days I define in BI1, AND ensure we only count unique values in range B2:B10000 when the rest of the criteria matches.
Basically I might have cases where I have multiple matches where the date/time is in my date/time range I'm looking for, and there is a partial or full match in range R2:R10000, but there are multiple matches / dupes of what's found in B2:B10000. I don't want to count dupes of what's found in B2:B10000 when the rest of the criteria matches. Only count once per unique value found in B2:B10000
Anyone know how to add that into my formula?
COUNTIFS('RAW Data 2'!$R$2:$R$10000,"*"&$BG3&"*",'RAW Data 2'!$O$2:$O$10000,">="&(TODAY()-$BI$1))
Range R2:R10000 contains a list of values where my value in BG3 may be an exact text string match, or a partial text string match
Range O2:O10000 contains a list of dates/times where among my criteria is I'm also counting if the date/time date in that range is more recent than today's date minus however many days I want to look back defined in cell BI1
I want to add a 3rd criteria where I look at range 'RAW Data 2'!$B$2:$B$10000 as well, and only count IF BG3 is a full or partial match in range R2:R100000, and the date/time in range O2:O10000, is more recent than today's date minus however many days I define in BI1, AND ensure we only count unique values in range B2:B10000 when the rest of the criteria matches.
Basically I might have cases where I have multiple matches where the date/time is in my date/time range I'm looking for, and there is a partial or full match in range R2:R10000, but there are multiple matches / dupes of what's found in B2:B10000. I don't want to count dupes of what's found in B2:B10000 when the rest of the criteria matches. Only count once per unique value found in B2:B10000
Anyone know how to add that into my formula?
thank you so much!
