@@ExcelInsights oh thanks for the reply i actually already changed your counta to countif with the value size measured from a common value and changed the second value which you had to start down on that common value in the front. =countifs(offset(Roster!$F$1,match(A31,Roster!F:F,0),match(CasualTracker!$B$1,Roster!$G$1:$1,0),COUNTif(Roster!$B:$B,A31),14),"dropped")
nice function, what if you wanted to take it further and capture P for only John as an example
You have to use COUNTIFS
ruclips.net/video/NJUWO9xWUfk/видео.htmlsi=FcBuBMunC6lH4wgl
@@ExcelInsights oh thanks for the reply i actually already changed your counta to countif with the value size measured from a common value and changed the second value which you had to start down on that common value in the front. =countifs(offset(Roster!$F$1,match(A31,Roster!F:F,0),match(CasualTracker!$B$1,Roster!$G$1:$1,0),COUNTif(Roster!$B:$B,A31),14),"dropped")