Forum Discussion
how to use sum product count unique value with more condition? Many thx in advance!
Hi, all I have a question to ask for a formula I plan to use in excel: this is my situation: 1. in E column, we have 10k rows of different school name normally end with school, high school or mid...
Deleted
New formula:
=SUM(--(FREQUENCY(IF((UPPER(LEFT(A2:A8872,3))<>"USD")*(UPPER(A2:A8872)<>"UNKNOWN")*(UPPER(A2:A8872)<>"MULTIPLE")*(UPPER(A2:A8872)<>"NON-SEDGEWICK COUNTY-NOT SPECIFIED"),MATCH(A2:A8872,A2:A8872,0)),ROW(A2:A8872)-ROW(A2)+1)>0))
thank you so much sir!
so my issue is the list of the name ranges from: ** elementary, to XX High school or && academy; middle school
so my issue is the list of the name ranges from: ** elementary, to XX High school or && academy; middle school
Deleted
What exactly should be included, and what should be excluded?
- I just sent you a message thx
Deleted
New formula:
=SUM(--(FREQUENCY(IF((UPPER(LEFT(A2:A8872,3))<>"USD")*(UPPER(A2:A8872)<>"UNKNOWN")*(UPPER(A2:A8872)<>"MULTIPLE")*(UPPER(A2:A8872)<>"NON-SEDGEWICK COUNTY-NOT SPECIFIED"),MATCH(A2:A8872,A2:A8872,0)),ROW(A2:A8872)-ROW(A2)+1)>0))