aligning data

[pthienpont]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I am trying to sort 2 sets of data listed by date and time, I was wondering if anyone knew a way to align the data in one sheet such that the date from one set of data can be in the same row as the other set. Currently i have been manually deleting lines that do not match however i am dealing with over 30,000 lines of data. Is there a more efficient way of doing this?

 

[John_McGhie_[MVP]]

Yes. You need to create a VLOOKUP formula, then fill down for 30,000 rows.

See here:

http://www.ozgrid.com/Excel/excel-vlookup-formula.htm

Hope this helps

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel
I am trying to sort 2 sets of data listed by date and time, I was wondering if
anyone knew a way to align the data in one sheet such that the date from one
set of data can be in the same row as the other set. Currently i have been
manually deleting lines that do not match however i am dealing with over
30,000 lines of data. Is there a more efficient way of doing this?

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:[email protected]