whats with the problem of true & false the last one before the change gets a
false all others get true we nedd to copy the true after the false
"Max" wrote:
.. what happens if we want to add another 2 columns to filter
Just extend the criteria in the helper col to suit
Eg if you have 5 cols to check, cols A to E
Put this in say, F2:
=IF(COUNTA(A2:E2)<5,"",SUMPRODUCT((A$2:A2=A2)*(B$2 :B2=B2)*(C$2:C2=C2)*(D$2:D2=D2)*(E$2:E2=E2))1)
Copy down, rest of steps similar
Also sometimes filter by 3 columns sometime by 5
You can always do up the criteria check on 3 cols in one helper col, and
frame up the 5 cols check in another helper col. Then filter separately, etc
we realized also that the true after the false that we need because all
of
them are only when there is a difference in the cells then the last row
before the change gets the false but the change has a true like all
mojaroty
I'm clueless. Suggest you put this in as a fresh new posting.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---