.. 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
---