LinkBack URL
About LinkBacks
I want to replace all values greater than 110 with 110 in the selected cell area. Is there a way to do that? Thanks.
I want to replace all values greater than 110 with 110 in the selected cell area. Is there a way to do that? Thanks.
easiest way is to filter each column in turn by >110 then overwrite the first cell with 110 and drag down.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
thanks but i want to select multiple columns and rows, not one column at a time. please help.
This would require VBA (or you could do it with formulas and paste special back over the original)
Try this code in a module(you can make a keyboard shortcut to it)Does that work for you?
Please Login or Register to view this content.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Improved version (thanks to Romperstomper) which takes into account that you might have error values in some of your cell selectionsPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks