Sorting

[Charlie]

What I need to do is a bit hard to describe so I'll give an example:

A B C D E F

1400 data1 data1 data1 data1 data1
data1 data1 data1 data1 data1
data1 data1 data1 data1 data1
2130 data2 data2 data2 data2 data 2
data2 data2 data2 data2
0900 data3 data3 data3 data3 data3
data3 data3

How can I sort by column A and have the data for each time sort along with
it? I need to be able sort column A by a different time throughout the day.

Thanks,
Charlie

 

[Debra Dalgleish]

You could enter the data from column A in every row,

http://www.contextures.com/xlDataEntry02.html

and use Conditional Formatting to hide the duplicates:

http://www.contextures.com/xlCondFormat03.html#Duplicate

Then you'll be able to sort, and the rows will stay together.