View and replace 'unique' and 'distinct' numbers using macros in excel...

rohanp

New Member
Joined
Aug 3, 2010
Messages
4
hey, hope you're doing good..

i need some help with excel macros.. is it possible to record 'unique' numbers and replace them.. like if i wish to change 17 to 30 is it possible to do that without changing 170 to 300 ? i do realize i can change 170 first but there are lots of numbers and it gets VERY complicated.. so if there was a way of searching for distinct numbers and replace them that would be great.

thanks a lot, take care :)
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Sandeep Warrier

Well-known Member
Joined
Oct 31, 2008
Messages
2,676
Hi and welcome to the Board!

If you are using the regular Find/Replace then click on the options button and place a check against "Match entire cell contents".

Note that this will not work if you have other text along with the number you want to replace.

You can record this action to get syntax.
 

rohanp

New Member
Joined
Aug 3, 2010
Messages
4
wow, thanks a lot sanjay, that seemed to work like a charm :)

take care, have a nice day
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,168,111
Messages
5,857,448
Members
431,880
Latest member
kar2rost

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top