New and not exactly sure where to put this.
I have a long list of unique x coordinates and y coordinates in separate fields. I need to truncate each field to the least number of decimal places possible without having any duplicates in the list. I was thinking that the best way to do this would be to subtract each value from each other value and spit out the smallest of the differences, but not sure if Excel has any capabilities that will do this for me automatically. Any ideas?
Thanks!
you could create a helper column then subtract the two numbers and then in cell, D1 (assuming you have colA=Number, ColB=Number, ColC=Difference) you could use the MIN() function....
Ernest
Please consider adding a * if I helped
Nothing drives me crazy - I'm always close enough to walk....
or you could use an array formula....adjust the columns for your data set....enter this in an open cell and hit Ctrl+Shift+Enter (Sometimes called a CSE formula)
=MIN(A1:A6-B1:B6)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks