So guys hypothetically i want to copy values in column B to let's say D.After that i want to be able to sort column D.And every time values in column B change i want to automatically refresh and sort values in D.Is that possible?
Copy&Sort.xlsx
So guys hypothetically i want to copy values in column B to let's say D.After that i want to be able to sort column D.And every time values in column B change i want to automatically refresh and sort values in D.Is that possible?
Copy&Sort.xlsx
Try this one in D3
=SMALL($B$3:$B$11,ROW()-2)
And drag down to D11
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
copy paste below in D3 and drag down
=IFERROR(SMALL(INDIRECT("$b$3:$B$"&COUNT($B$3:$B$500)),ROW(A1)),"") will work till data filled up to B500
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
Both of you as effective as it can get!!!Thanks!!!!!!!!!!!!!!!!!!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks