Hi,
I have an Excel with some data.
I want only rows which contain 2,500 in Column E and F both.
When i apply Filter in Column E,data of Column F having 2,500 disappears and vice versa.
Your assistance is expected.
Thank You
Hi,
I have an Excel with some data.
I want only rows which contain 2,500 in Column E and F both.
When i apply Filter in Column E,data of Column F having 2,500 disappears and vice versa.
Your assistance is expected.
Thank You
Last edited by kdraghu; 04-15-2020 at 08:38 AM.
You could add another column with the following formula in row 2 and copy down to the bottom. Then sort by True.
Please Login or Register to view this content.
Hi
Thank You for reply
I applied your formula.But every cell is reflecting FALSE
I want only entries of 2500(either in E Or F).
I have attached new file which reflects the data i require.
Thank You
You said BOTH in your opening post, which is AND. Now you are saying OR, so change it to this:
=OR(E2=2500,F2=2500)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thank You Beamernsw and AliGW
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks