.. What change to the formula in column C would i need to
make to round it off to the tenths place, instead of 2 decimal
places.
Just amend the 2 in ROUND(..,2) to ROUND(..,10)
Place instead in C1, array-entered with CSE, then copy down:
=IF(B1="","",IF(ISNUMBER(MATCH(-ROUND(A1,10)&"_"&B1,ROUND($A$1:$A$100,10)&"_"&$B$1 :$B$100,0)),"",ROW()))
(Remember to change the ranges to suit)
Now i just need to work out a way to convert the process into a macro
since its essentially exactly the same for every spreadsheet i do.
Suggest you try a new posting in .programming
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
wrote in message
ps.com...
Max,
Your solution works wonders, and achieves close to a perfect result
every time. What change to the formula in column C would i need to
make to round it off to the tenths place, instead of 2 decimal
places. I am working with foreign currencies and conversions to USD
usually throw it off a little bit.
Now i just need to work out a way to convert the process into a macro
since its essentially exactly the same for every spreadsheet i do.
I cant thank you and everyone else who has posted on this forum
enough, you guys n gals rock. Thanks so much!
-Pogster