LinkBack URL
About LinkBacks
Here i want to count data with and without duplicate as mention in attached file
Note : I need to run attached file at google sheets.
Here i want to count data with and without duplicate as mention in attached file
Note : I need to run attached file at google sheets.
C3:C5
=SUM(--(FREQUENCY(IF(raw!$A$7:$A$20=A3,MATCH(raw!$A$7:$A$20&raw!$D$7:$D$20,raw!$A$7:$A$20&raw!$D$7:$D$20,)),ROW(raw!$A$7:$A$20)-ROW(raw!$A$6))>0))
C9
=SUM(--(FREQUENCY(IF(raw!$A$7:$A$20>0,MATCH(raw!$A$7:$A$20&raw!$D$7:$D$20,raw!$A$7:$A$20&raw!$D$7:$D$20,)),ROW(raw!$A$7:$A$20)-ROW(raw!$A$6))>0))
C10
=COUNTA(raw!$A$7:$A$20)
where is the "Count without Dublicate data" supposed to be sourced from?
based on the example provided, there is no data that would meet this condition and be count of "4"
where is the "Count with Dublicate date" supposed to be sourced from?
based on the example provided, there is no data that would meet this condition and be count of "5"
after analysing the array formulas provided by Bo_Ry, it appears that you may be seeking counts of unique rows.
here is a regular formula (enter into D3, and drag down) to obtain unique rows per name:
here is a regular formula (enter into D9) to obtain a count of total unique rows:
=SUMPRODUCT((raw!$A$7:$A$20=A3)/COUNTIFS(raw!$A$7:$A$20,raw!$A$7:$A$20&"",raw!$D$7:$D$20,raw!$D$7:$D$20&""))
=SUMPRODUCT((raw!$A$7:$A$20<>"")/COUNTIFS(raw!$A$7:$A$20,raw!$A$7:$A$20&"",raw!$D$7:$D$20,raw!$D$7:$D$20&""))
sample file is attached
Last edited by janmorris; 09-13-2021 at 01:36 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks