Data Alignment in columns

N

Natemoney2

I have an excel spreadsheet that has multiple columns. Column "A" contains a
list of 9,012 unique resource codes for a Primary Manufacturing location.
Columns "B"-"EF" contain lists of resource codes for multiple "sub" plants
these lists are all different lengths and contain various combinations of
resource codes from list "A". Is there a way to align the "sub" plants lists
to the corresponding rows column "A".

"A" "B" "C"
ABC ABC ABC
DEF DEF DEF
GHI JKL
JKL JKL MNO
MNO MNO STU
PQR
STU STU
VWX

Column "A" shows the complete list
Column "B" shows what I want it to look like
Column "C" shows what it is right now
 
T

Toppers

One way:

Copy column A to a second sheet:

In B1 of second sheet:

=IF(ISNA(MATCH($A1,Sheet1!B$1:B$10000,0)),"",$A1)

Copy across to EF and down .
 
N

Natemoney2

Thanks! Works perfectly!!!

Toppers said:
One way:

Copy column A to a second sheet:

In B1 of second sheet:

=IF(ISNA(MATCH($A1,Sheet1!B$1:B$10000,0)),"",$A1)

Copy across to EF and down .
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

collapse rows into one 2
Help With Sumif 3
VlookUp or may be Match Function 2
lookup with IF criteria 2
Multiples conditions in an array 3
SEARCH IN SUMPRODUCT 8
Sorting 2
Finding duplicates 2

Top