Excel Gurus come inside

Dr_Jones · Post by **Dr_Jones** » Thu May 25, 2006 1:24 am

Hi all,

I have a bit of a problem I can't figure out although I think I might be missing something very obvious.

Basically I have this data for example formatted like this
A B C
1 1 2 SAMPLE1
2 2 5 SAMPLE2
3 3 6 SAMPLE3
4 4
5 5
6 6

I want to be able to align Column B's numbers with those in A and take C along for the ride.

jonowong · Post by **jonowong** » Thu May 25, 2006 1:49 am

whats wrong with copy and paste?

Dr_Jones · Post by **Dr_Jones** » Thu May 25, 2006 1:54 am

Sorry my formatting didn't really work out in the post

Basically Column A is in order 1 2 3 4 etc and column B may not have all numbers say 2 4 9 11 etc I want to marry up the two. Sorry if I'm not explaining too well...my brain hurts.

thecook · Post by **thecook** » Thu May 25, 2006 2:37 am

huh? merge cells? adding them together?

Dr_Jones · Post by **Dr_Jones** » Thu May 25, 2006 3:12 am

No as in I want to align 1 up with 1 and 5 with 5 etc, one column has consecutive numbers and I want to align the other column with the consecutive numbers. At the moment I've gone through and inserted rows until it lines up but this is very time consuming.

I have a column of numbers in a random format that I want to align against the numbers in another column. Not all numbers are present all the time.

SILVERFISH · Post by **SILVERFISH** » Thu May 25, 2006 11:04 am

you're not gonna be able to get a blank field to know
it's supposed to fit into an ascending number range...
try this -

* delete out all your sequential numbering in column A

* highlight all the information you want to sort

* press the A-Z with downward arrow button (sort ascending)
(information in column c should stay next to its appropriate column b number)

* use insert row to put the appropriate gaps where the missing numbers are (ie. 6 <insert row here> 8 )

* once your happy with b & c, number column a
(set the first cell (eg. cell A1) as 1 and the cell below as =A1+1... then just copy the formula to all the cells below)

hope that works for ya... pm me if you need more info