Problem with sorting data - Please help!

Hi,

I am working on a project where I am downloading data from a BMS interface. I am currently focusing on 2 different sensors but for one year the two sensors do not have the same amount of readings. I need to sort my data according to 2 columns (timestamp for each reading).

My sheet looks something like this:

Date and Time | Room Temp | Date and Time | External Temp
03/07/2011 00:15 | 19 | 03/07/2011 00:15 | 5
03/07/2011 00:30 | 19.5 | 03/07/2011 00:30 | 4
03/07/2011 00:45 | 19 | 03/07/2011 01:00 | 6
03/07/2011 02:00 | 20 | 03/07/2011 02:15 | 7

The data is not sorted correctly so I need some way of srting the data so that columns A and C will be equal and columns B is locked to column A and column D is locked to column C if that makes sense. I am willing to use Macros.

I am trying to sort manually but there is over 33,000 rows of data and I must do this for a number of sheets.

Any help on this would be greatly greatly appreciated as the deadline is rapidly approaching and this is holding me up big time!!

Thank you!

Jimmy

Hi Oeldere,

Thanks for the advice.

See attached my excel workbook.

I want to sort the data so that the timestamps (column A and C) correctly correspond to each other along with the temperature readings. From the attached file it is easy to fix the first instance by inserting cells but this may need to be done up to fifty times per sheet for plus 10 sheets.

Thank you.

Hi Hansen,

Thanks for your time!

That won't do it I am afraid.

See Cell E3 and G3 in your reply - these are not the same. I want to sort the data so that the temperature reading for each timestamp are populated to cells next to each other so that I can easily find the difference between the values by applying a simple formula.

So for example, if possible, is for the timestamp 04/07/2011 00:30 temp reading (Cell F11) to be populated next to the external temperature reading with the same timesptamp (Cell F12). It is simple to insert rows to here to do it but it is recurring a lot as there are no readings for quite a lot of timestamps.

Thanks

Hi Hansen,

That is exactly it.

Thank you very much for your help and time!! Saved me alot of time!!

Thanks again.

Sgh,

That's fantastic!

Thank you both!