Forum Discussion
Counting and sorting
Hello, I have a excel list containing some data in this form "0.0033MF 50V" (this is into a single cell), both MF and V values vary separately. I sorted them by both values and now i need to know...
I've attached a copy of the file, you'll know what i mean when you'll see it
THORs_Hand , another variant is to use FREQUENCY as explained here, array formula is like
=SUM(IF(FREQUENCY(IF(LEN(A2:A1000)>0,MATCH(A2:A1000,A2:A1000,0),""), IF(LEN(A2:A1000)>0,MATCH(A2:A1000,A2:A1000,0),""))>0,1))
and in attached file