Donate SIGN UP
Home > Technology > excel query!

excel query!

Avatar Image
whatwhat | 19:54 Wed 19th May 2010 | Technology
5 Answers
just wondered, if I have put a series of entries all with differant dates, is there something I can do to get excel to put them in chronological order for me? tia
prev Lost Wireless connection
  
next Blackberry Radio
Gravatar

Answers

1 to 5 of 5rss feed

Best Answer

No best answer has yet been selected by whatwhat. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
Avatar Image boxtops
Yes you can do a data sort. Click on the data box on the top bar, and ask it to sort whichever column you have entered the dates in.
19:56 Wed 19th May 2010
Avatar Image dr b
sort on the column of dates.
19:56 Wed 19th May 2010
Avatar Image boxtops
PS sorry, forgot a vital part, you need to highlight the whole of the entries you have made first, otherwise it will just sort that single column and the dates won't match your text. Ooops!
19:57 Wed 19th May 2010
Avatar Image mike11111
Simple. Highlight all the relevant data the click on Sort by the column the date enries are in
19:57 Wed 19th May 2010
Avatar Image whatwhat
Question Author
Cheers boxtops, that was easy! you learn something new every day!
20:06 Wed 19th May 2010

1 to 5 of 5rss feed

Do you know the answer?

excel query!

Answer Question >>