LinkBack URL
About LinkBacks
The numbers are not in sequential order and cannot be put into, any other ideas?
The numbers are not in sequential order and cannot be put into, any other ideas?
Perhaps you can use a helper column that relists your numbers in sequential order, then you can apply my previous formulas to the new range.
Use formula: =Small($A$2:$A$1000,Row(A1)) copied down to get the reordered list... adjust range to suit.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Or this in column B
=A1-SMALL(A:A,1) copied down
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks