Forum Discussion

Copper Contributor

Nov 12, 2021

Solved

Ignore duplicates with multiple criteria and between 2 dates

Hi all I'm doing a training db and need to specify how many learners completed specific, accredited courses between 2 dates that are on a second sheet. I have a list of names in Column A (some d...

Tester Training Database 2.xlsx22 KB

excel

Formulas and Functions

Juliano-Petrukio

Nov 12, 2021

Jules_Rapley

=COUNTA(
       UNIQUE(
             FILTER('Training DB'!A2:A27,
                     ('Training DB'!B2:B27="Yes")*
                     ('Training DB'!C2:C27<>"Legacy")*
                     ('Training DB'!G2:G27="Completed")*
                     ('Training DB'!F2:F27>=A1)*
                     ('Training DB'!F2:F27<=A2),""
                    )
              )
         )

Solved-Tester Training Database 2.xlsx24 KB

Juliano-Petrukio

Bronze Contributor

Nov 12, 2021

If you can post a file it would be great

Jules_Rapley

Copper Contributor

Nov 12, 2021

Have now done so.

Juliano-Petrukio
Bronze Contributor
Nov 12, 2021
Jules_Rapley

=COUNTA( UNIQUE( FILTER('Training DB'!A2:A27, ('Training DB'!B2:B27="Yes")* ('Training DB'!C2:C27<>"Legacy")* ('Training DB'!G2:G27="Completed")* ('Training DB'!F2:F27>=A1)* ('Training DB'!F2:F27<=A2),"" ) ) )
Solved-Tester Training Database 2.xlsx24 KB
- Jules_Rapley
  Copper Contributor
  Nov 12, 2021
  Thank you so much! This is perfect!
- Jules_Rapley
  Copper Contributor
  Nov 12, 2021
  Should I add in ('Training DB'!B2:B27,"Yes") to make it accredited only? If so, where should it go?
  - Juliano-Petrukio
    Bronze Contributor
    Nov 12, 2021
    I just updated both formula and attached file. Check it out please.