find and replace problem also duplicate Numbers

  • Thread starter Thread starter jpm
  • Start date Start date
J

jpm

I have a range of numbers d4:h10
and a second range m4:r4

I would like to compare the numbers in d4:h10 to
the numbers in m4:r4, if any number matches,
replace the matched number with * (an asterisk)
if they don't match do nothing, no changes

Another problem I have is with duplicate numbers being generated wit
the randbetween function.

If I have a range of numbers a1:a5 using randbetween 1,25
what code could I use so I don't get duplicate numbers?

any help I can get with these would be greatly appreciated

Thanks
 
I have a range of numbers d4:h10
and a second range m4:r4

I would like to compare the numbers in d4:h10 to
the numbers in m4:r4, if any number matches,
replace the matched number with * (an asterisk)
if they don't match do nothing, no changes
Click to expand...

Is it okay if the asterisks go into a different column adjacent to the
duplicate, or do they have to completely wipe out the matching numbers?
Another problem I have is with duplicate numbers being generated with
the randbetween function.

If I have a range of numbers a1:a5 using randbetween 1,25
what code could I use so I don't get duplicate numbers?
Click to expand...

This is not built into Excel.

Use the MRAND function from MOREFUNC.XLL available for download from
http://longre.free.fr/english/
 
Back
Top