creating matching data in different columns

T

Tiff

Hi,

I am having the same problem, have you figured out a way
to do it?

Cheers.

-----Original Message-----
I have a problem creating the look of the spreadsheet I
Click to expand...
want. I have information in column A that needs to match
information in columns B through Z. But in B, not all the
information is the same.
In my sheet 1, in column A I have a list of
Click to expand...
letters/numbers that I need to line up with other columns
across my spreadsheet. For example, column A contains a
number like 08.01A, 08.01B, 08.01C, 08.24C. Column B
doesn't contain 08.01C but contains the other numbers, so
I want a blank line in that space instead. I would like
for each of my columns to match in length, filling in
blanks when the information is not there, so I can look
across the different columns and have the rows match. I
have all the information in the columns and don't what to
have to insert the blank cells by hand if the info doesn't
match across the row. There are way too many columns to
match up.
 
R

RagDyer

To do what, exactly?
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

Hi,

I am having the same problem, have you figured out a way
to do it?

Cheers.

-----Original Message-----
I have a problem creating the look of the spreadsheet I
Click to expand...
want. I have information in column A that needs to match
information in columns B through Z. But in B, not all the
information is the same.
In my sheet 1, in column A I have a list of
Click to expand...
letters/numbers that I need to line up with other columns
across my spreadsheet. For example, column A contains a
number like 08.01A, 08.01B, 08.01C, 08.24C. Column B
doesn't contain 08.01C but contains the other numbers, so
I want a blank line in that space instead. I would like
for each of my columns to match in length, filling in
blanks when the information is not there, so I can look
across the different columns and have the rows match. I
have all the information in the columns and don't what to
have to insert the blank cells by hand if the info doesn't
match across the row. There are way too many columns to
match up.
 
D

Domenic

I'm not quite sure if this is what you want, but assuming you have the
following 5 column table...

08.01A 08.01A 1 1 1
08.01B 08.01B 2 2 2
08.01C 08.24C 3 3 3
08.24C 08.01D 4 4 4
08.01D 08.24D 5 5 5
08.01E
08.24D
08.01F

Put the following formula in F1, copy across and down:

=IF(ISNA(MATCH($A1,$B:$B,0)),"",INDEX(B:B,MATCH($A1,$B:$B,0)))

Then you should get the following table...

08.01A 08.01A 1 1 1
08.01B 08.01B 2 2 2
08.01C
08.24C 08.24C 3 3 3
08.01D 08.01D 4 4 4
08.01E
08.24D 08.24D 5 5 5
08.01F

Hope this helps!
 
Top