Hi guys, as the title suggests I have 5 columns with dates and would like to put them into one column, order is not important here.
Is there a quick way to do this avoiding cut & paste?
Hi guys, as the title suggests I have 5 columns with dates and would like to put them into one column, order is not important here.
Is there a quick way to do this avoiding cut & paste?
Last edited by pickslides; 01-08-2012 at 08:05 PM.
Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind.
If it is valid dates, try SMALL function.
Say, B:F contains dates. So try this in A2,then copy down.
=SMALL(B:F,ROWS(A$2:A2))
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
Thx Haseeb, this worked fine
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks