Hi All,
Would like to check if formulas can be auto arrange the data in ascending?
My company do not allow Macro.
Thank in advance.
Hi All,
Would like to check if formulas can be auto arrange the data in ascending?
My company do not allow Macro.
Thank in advance.
formulas never arrange/move original data it would only advise order
can you not just sort the data?
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Yes it can wihth helpcolumns and the functions Rank and index/match.
But I prefer the solution of humdingaling (sort the data).
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
rank index match would not actually move data by itself though
it may duplicate and sort/arrange the newly created data but not move original data as such
@humdingaling
You totaly right about that.
I just intend to inform cyee, that there are other options.
I would solve it, as already said, with the solution you provided.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks