PC Review

Reply

Rate Thread

ALIGNING TWO ARRAYS OF DATA VALUE

sunan

Guest

Posts: n/a

20th Jun 2008

This si about comparing two sets of separate data into one aligned worksheet
as folows:
XXX 300
YYY 250
ZZZ 175
XXX 312
YYY 267
ZZZ 177
to be aligned:

XXX 300 312
YYY 250 267
ZZZ 175 177

Can we do it the simple way?
thanks,
sunan

--
sunan

Reply With Quote

Herbert Seidenberg

Guest

Posts: n/a

21st Jun 2008

Try Pivot Table.
No formulas needed.
http://www.savefile.com/files/1621696

Reply With Quote

Reply

« Countif fields with ** | Have a chart line completely disappear for a Series... »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
RE: aligning data	Shane Devenshire	Microsoft Excel New Users	0	3rd Mar 2009 03:20 AM
aligning data	jos.bogg@wheel.co.uk	Microsoft Excel Programming	2	21st Sep 2006 05:17 PM
Aligning decimal numers to the centre of the cell and aligning dec	=?Utf-8?B?UmFtZXNoIEJhYnU=?=	Microsoft Excel Misc	1	1st Jul 2006 10:33 PM
Aligning rows of data from multiple data sets in columns	e abor	Microsoft Excel Discussion	1	29th Jun 2006 09:21 AM
Re: Re-aligning data	Dave Peterson	Microsoft Excel Misc	1	24th Aug 2003 10:10 PM

Features

Forums Startup Database Reviews Articles FAQ / Guidelines About Us

Advertising

Newsgroups

Windows Vista Windows XP Microsoft Word Microsoft DotNet Windows 2000 AntiSpyware Microsoft Access Microsoft Excel Microsoft Outlook Hardware

All times are GMT +1. The time now is 06:45 AM.