Excel – how do I filter multiple tables without header?

I want to filter if any of the H I J columns contain fields greater or equal to 10.0.

I don’t want to use no Advanced filters because there are multiple tables across the way but I want to sort all of them.

*I don’t think Advanced filter will work for me.

Please help – whatever I do – this seems like voodoo – I select H I J columns to be sorted then I select some other three columns for the criteria and write >=5.0 in the first one but nothing happens.

For difference the basic Filter will be able to sort me a single column above ten.

Answer

Attribution
Source : Link , Question Author : Nemo759 , Answer Author : Community

Leave a Comment