Need a hand with matching cells

[austin397]

I need 5 horizontal cells to automatically fill in based on the information that might be in 10 vertical cells without the 5 horizontal cells duplicating.

https://www.dropbox.com/sh/l8fcalyjlbjrlh4/AAALvRoEbTDq4tGhk5BclGURa?dl=0

The link will take you to my dopbox where you can download a sample that should clarify what I am meaning.

Thank you in advance!

 

[My Aswer Is This]

If you want help here I suggest you explain in detail with column numbers etc. Do not just expect us to look at you sheet and understand what you want. I never click on links.

 

[austin397]

I dont know how to explain it. Thats why in my sheet I have arrows and descriptions.

 

[austin397]

The best description I can offer is that I want cells AB1:AF1 to autofill in based on information that MIGHT in cells L6:L26 without dublicating the values. So if Cell L6 has the text TEE in it and cell L12 has the text 90 FAB in it then I need cell AB1 to fill in with TEE and cell AC1 to fill in with 90 FAB. But then if Cell L10 also has TEE in it, I dont want AD1 to fill in with TEE since it is already in cell AB1.

I hope that clears it up.

Thank you!

 

[austin397]

I am still looking for an answer to this question. Can anyone help me?

 

[hiker95]

austin397,

Does the workbook in your reply #1 contain a macro/macros?

I have had problems in the past when attempting to download an Excel file with macros, with the xls file extension.

Please remove all macros, and, then repost on dropbox.


We would like more information. Please see the Forum Use Guidelines in the following link:

http://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html


See reply #2 at the next link, if you want to show small screenshots, of the raw data, and, what the results should look like.

http://www.mrexcel.com/forum/about-board/508133-attachments.html#post2507729

 

[austin397]

Thans for the reply, sorry it took so long to reply.

The workbook doesn't contain macro's but don't worry about that anymore.

Excel 2007

	A	B	C	D	E	F

<tbody>
[TD="align: center"]1[/TD]
[TD="align: right"][/TD]
[TD="align: center"]Fab 1:[/TD]
[TD="align: center"]Fab 2:[/TD]
[TD="align: center"]Fab 3:[/TD]
[TD="align: center"]Fab 4:[/TD]
[TD="align: center"]Fab 5:[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #8DB4E3, align: center"][/TD]
[TD="bgcolor: #8DB4E3, align: center"][/TD]
[TD="bgcolor: #8DB4E3, align: center"][/TD]
[TD="bgcolor: #8DB4E3, align: center"][/TD]
[TD="bgcolor: #8DB4E3, align: center"][/TD]

[TD="align: center"]3[/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]

[TD="align: center"]4[/TD]
[TD="align: center"]Fabs[/TD]
[TD="bgcolor: #D8D8D8, align: center"]-[/TD]
[TD="bgcolor: #D8D8D8, align: center"]-[/TD]
[TD="bgcolor: #D8D8D8, align: center"]-[/TD]
[TD="bgcolor: #D8D8D8, align: center"]-[/TD]
[TD="bgcolor: #D8D8D8, align: center"]-[/TD]

[TD="align: center"]5[/TD]
[TD="bgcolor: #FFFF00, align: center"][/TD]
[TD="bgcolor: #D8D8D8, align: center"][/TD]
[TD="bgcolor: #D8D8D8, align: center"][/TD]
[TD="bgcolor: #D8D8D8, align: center"][/TD]
[TD="bgcolor: #D8D8D8, align: center"][/TD]
[TD="bgcolor: #D8D8D8, align: center"][/TD]

[TD="align: center"]6[/TD]
[TD="align: center"]Tee[/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]

[TD="align: center"]7[/TD]
[TD="align: center"]Tee[/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]

[TD="align: center"]8[/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]

[TD="align: center"]9[/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]

[TD="align: center"]10[/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]

[TD="align: center"]11[/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]

[TD="align: center"]12[/TD]
[TD="align: center"]90 Degree[/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]

[TD="align: center"]13[/TD]
[TD="align: center"]Angle Fab[/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]

[TD="align: center"]14[/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]

[TD="align: center"]15[/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]

[TD="align: center"]16[/TD]
[TD="align: center"]4" Side Outlet[/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]

[TD="align: center"]17[/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]

[TD="align: center"]18[/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]

[TD="align: center"]19[/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]

</tbody>

sample​

So I need cells B2:F2 to auto fill when a cell is filled out in one of the cells from A6:A19 but the cells B2:F2 should only show up once where as the cells A6:A19 may have duplicates as seen on the chart.

When I enter "Tee" into A6, it should auto-fill "Tee" into B2. When I enter "Tee" into A7, it should not auto-fill a second time. When I enter "90 Degree" into A12 it should auto-fill "90 Degree" into cell C2.

Does this make more sense?

 

[austin397]

The table got a little messed up so here it is again...

Excel 2007
	A	B	C	D	E	F
1		Fab 1:	Fab 2:	Fab 3:	Fab 4:	Fab 5:
2
3
4	Fabs	-	-	-	-	-
5
6	Tee
7	Tee
8
9
10
11
12	90 Degree
13	Angle Fab
14
15
16	4" Side Outlet
17
18
19
sample

 

[hiker95]

austin397,

Can we have another screenshot of what the results should look like?

 

[austin397]

Sorry, guess I should have know to do that as well.

Excel 2007
	A	B	C	D	E	F
1		Fab 1:	Fab 2:	Fab 3:	Fab 4:	Fab 5:
2		Tee	90 Degree	Angle Fab	4" Side Outlet
3
4	Fabs	-	-	-	-	-
5
6	Tee
7	Tee
8
9
10
11
12	90 Degree
13	Angle Fab
14
15
16	4" Side Outlet
17
18
19
sample

Thanks!