Filter by formula?

[BBoi09]

Hello,

I would like to filter a column based on whether or not it is 'greater than' or 'less than' an adjacent cell. e.g:

should the value in A1 be less than B1, it will show up in the results of a filter. and so on for A2 and B2, A3 and B3...

Any ideas? Have I missed something?

 

[ChrisR]

Sorry, but I don't see how that can possibly work?

So, say this is your data

A1 = 10 B1 = 14
A2 = 14 B2 = 12
A3 = 12 B3 = 16
A4 = 11 B4 = 10

What would you expect to see if you filterted on column A?

 

[ChrisR]

I think I've just clicked onto what you're looking for...........

Add an extra column into C and in C1, for instance, put A1<B1

Copy this down for all your rows

Then column C will now contain either True or False (I.e. True if A is lower than B, false if not)

So you can then just filter on column C on either true or false

Hope this helps
Chris

 

[BBoi09]

<b1
Chris....you're nearly as smart as me. </b1


Thanks.