How to sort on two condition with VBA?

[orhanceliloglu]

Hello Everyone,

I have a table as below. I am not good at VBA, so I searched and applied some sorting tricks but its not giving me the exact result I am looking for.

Basically, I have a Column D where its checking the cases >> If(and(B2=0,C2<>0) and putting TRUE - FALSE accordingly. My goal is, having employees who has FALSE row on top but with all related employee rows.

Any advice how can do this ?

Capture.PNG

Thanks a lot
Orhan

[LeoTaxi]

Try

Please Login or Register  to view this content.

Kind regards
Leo

[karmapala]

LeoTaxi,

I'm sorry if I'm following this thread. I test your code and it works nicely.
Thank you LeoTaxi as I learn something new from you.

But I don't know why I need to change the formula in column D
without apostrophe for the false and true ---> =IF(AND(B6=0,C6<>0),FALSE,TRUE)

I wonder why if the formula ---> =IF(AND(B6=0,C6<>0),"FALSE","TRUE")
then the calculation formula in column E doesn't work ?

Thank you once again.

[orhanceliloglu]

Thank you very much LeoTaxi. This is the exact code I am looking for.

@karmapala, you are right. It didnt work in first try. As far as I can understand, formula in E column is looking for exact "FALSE" value in order to do the countif. But column D value is actually >> "=IF(AND(B6=0,C6<>0),"FALSE","TRUE")" although the result is "FALSE" itself. So, just before the countif code, added an additional code which makes copy paste with values for column D, it worked perfectly.

That was my work around. Hope it helps.

Thanks