I have a large number of rows numbered and would like to populate them from lowest to highest
please help see attachment
Thanks guys
I have a large number of rows numbered and would like to populate them from lowest to highest
please help see attachment
Thanks guys
Enter array formula in H1 and copy across and down
Formula:Please Login or Register to view this content.
***Array formula
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER.
You will know the array is active when you see curly braces { } appear around your formula.
If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Please see attached file.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Thanks it worked fine there is one more the columns O & P to be done
the same way lowest to highest in in R & S
Thanks
I also need Columns O & P lowest to highest in R & S see attachment
Thanks
Basically the same formula
Enter in R1 and copy across and down
Formula:Please Login or Register to view this content.
Enter array formula with CSE
Or try this ...
In H2:
=SMALL($A2:$F2,COLUMNS($A2:A2))
In R2:
=SMALL($O2:$P2,COLUMNS($O2:O2))
Normal Enter.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks