I'm still using this unefficient formula.
=SUM(COUNTIF(B3;"<"&B2);COUNTIF(C3;"<"&C2);COUNTIF(D3;"<"&D2);COUNTIF(E3;"<"&E2);COUNTIF(F3;"<"&F2);COUNTIF(G3;"<"&G2))
What about hundreds criterias?
I'm still using this unefficient formula.
=SUM(COUNTIF(B3;"<"&B2);COUNTIF(C3;"<"&C2);COUNTIF(D3;"<"&D2);COUNTIF(E3;"<"&E2);COUNTIF(F3;"<"&F2);COUNTIF(G3;"<"&G2))
What about hundreds criterias?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks