TRANSFERED FROM OLD FORUM
My question for this week.
This is a follow up question to the one on filtering out all the sums except one particular value. The explanation was very clear and easy to follow.
What I would like to do is filter out a whole range of numbers – for example all the sums from 21 to 99. I have done it manually by just clicking on each value between 21 and 99 to turn it to “no”. That seems like a lot of extra work.
Is there a way to reject all the sums between 21 and 99 in one step?
Yes Bill, there is.
Left click on cell 22 and drag the cursor to your end point cell 99 and all those cells dragged over will be highlighted. Now right click on your mouse and you will get a sub menu where you will see set selected region to yes or no.
You ask, we answer...if we know the answer!
1 post • Page 1 of 1
Who is online
Users browsing this forum: No registered users and 1 guest