Page 1 of 1
Excel Gurus come inside
Posted: Thu May 25, 2006 1:24 am
by Dr_Jones
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.
Posted: Thu May 25, 2006 1:49 am
by jonowong
whats wrong with copy and paste?
Posted: Thu May 25, 2006 1:54 am
by Dr_Jones
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.
Posted: Thu May 25, 2006 2:37 am
by thecook
huh? merge cells? adding them together?
Posted: Thu May 25, 2006 3:12 am
by Dr_Jones
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.
Posted: Thu May 25, 2006 11:04 am
by SILVERFISH
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