there are more solutions for you reference.
Hi, Please test attached file, hope it helps. Please note that these are array formulas. Clark
There are more interesting functions for your reference 🙂
amisandip said Thank you Clark. It's so simple yet awesome! Don't know how to say 'thank', but will try to help others in this forum. I'm very ...
Hi, Please try this one. If the count of the biggest number in range A2:D2 equals to the number of numbers greater than 0, the formula returns TRUE...
Hi Robin, Please try this: A3=IF(AND(MOD(A2,1)>=$B$2,MOD(A2,1)<=$C$2+1),"Yes","No") In excel, one day=24 hours="24:00"=1, use formula M...
Hi, Please test the atached file. You can enter new strings in column A and add more keywords in column E. Clark
GaryTibble said Hi Please find the attached spreadsheet. The Worksheet in particular that I cannot access is "Operation WWW" Hi, Please r...
IF you upload the file, i may help you to unprotect the sheet.
Pivot table solution
You may also try this =SUM((A$2:A$14=K2)*(MATCH(A$2:A$14&B$2:B$14,A$2:A$14&B$2:B$14,)=ROW($1:$13)))
L2=SUM((A$2:A$14=K2)/COUNTIFS(A$2:A$14,A$2:A$14,B$2:B$14,B$2:B$14)) Ctrl+shift+enter run the formula
Please refer to attached file with a helper column.
=COUNTIFS(A:A,E2,B:B,F2) =SUM((A2:A14=E3)*(B2:B14=F3)),apply Ctrl+Shift+Enter