I want to set a summary page of data collected per part numbers. I want to
add alike cells that have the same part number. The user chooses a part
number from a list. The user will choose a part number for each column to
collect data; some part numbers may be repeated (only one part number per
column). I want to create a summary page that will calulate the data based
on part number. My only problem is that I need to set the headers correctly
without repeated the same part number twice. Below is a very small example
of my problem.

A B C D E F

1 Part #3 Part #1 Part #4 Part #4 Part #2 Part #3

The desired results would be:

G H I J
1 Part #1 Part #2 Part #3 Part #4

The part numbers are all in one row (C3 thru DR3), No headers. The data
will not be in any order and will change periodically. Unfortunately, The
part numbers are both text and numerical.

Hi,

You need to clarify - what calculation do you want to make? Why are the
entries in columns G:J overlapping the entries in columns C3 thru DR3?

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Obrien21" wrote:

I want to set a summary page of data collected per part numbers. I want to
add alike cells that have the same part number. The user chooses a part
number from a list. The user will choose a part number for each column to
collect data; some part numbers may be repeated (only one part number per
column). I want to create a summary page that will calulate the data based
on part number. My only problem is that I need to set the headers correctly
without repeated the same part number twice. Below is a very small example
of my problem.

A B C D E F

1 Part #3 Part #1 Part #4 Part #4 Part #2 Part #3

The desired results would be:

G H I J
1 Part #1 Part #2 Part #3 Part #4

The part numbers are all in one row (C3 thru DR3), No headers. The data
will not be in any order and will change periodically. Unfortunately, The
part numbers are both text and numerical.

In my example, A:F will be the cells where the user chooses a part number.
G:J will be the summary of data collected under A:F and fills out
automatically based on the choices made in A:F.

The headers are used in the summary section so I can add the alike part
numbers data. (i figured that part out)

I just can't seem to keep the part number from repeating in the summary
section if it was choosen by the user more than once, This would cause me to
have the same data in multiple summary columns. Maybe this example will
explain what I'm trying to do a little better.

The user enters part numbers in A:G
A B C D E F
G
Part #2 Part #1 Part #3 Part #2 Part #4 Part #5 Part #1

The summary page needs to look at the row, pull out the unique part numbers
and list them individually in the summay section without repeating any of
them. So, the entries above will produce the following results in the
summary section (in this example, H:L)

H I J K L
Part #1 Part #2 Part #3 Part #4 Part #5

Thanks for your time!


"Shane Devenshire" wrote:

Hi,

You need to clarify - what calculation do you want to make? Why are the
entries in columns G:J overlapping the entries in columns C3 thru DR3?

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Obrien21" wrote:

I want to set a summary page of data collected per part numbers. I want to
add alike cells that have the same part number. The user chooses a part
number from a list. The user will choose a part number for each column to
collect data; some part numbers may be repeated (only one part number per
column). I want to create a summary page that will calulate the data based
on part number. My only problem is that I need to set the headers correctly
without repeated the same part number twice. Below is a very small example
of my problem.

A B C D E F

1 Part #3 Part #1 Part #4 Part #4 Part #2 Part #3

The desired results would be:

G H I J
1 Part #1 Part #2 Part #3 Part #4

The part numbers are all in one row (C3 thru DR3), No headers. The data
will not be in any order and will change periodically. Unfortunately, The
part numbers are both text and numerical.

I figured it out.

{=IF(ISERROR(MATCH(0,COUNTIF(DS$3:DT3,$C$3:$DR$3&" "),0)),"",INDEX(IF(ISBLANK($C$3:$DR$3),"",$C$3:$DR $3),MATCH(0,COUNTIF(DS$3:DT3,$C$3:$DR$3&""),0)))}

NOTE: This is an array formula. (CTRL+SHIFT+ENTER). The first cell in the
summary section must be equal to the 1st cell the user makes a part #
selection/input. In my case cell DT3 would have the formula =C3 and cells
after DT3 would have the above formula. This pulls out unique values and
won't allow duplicate #'s.

"Obrien21" wrote:

In my example, A:F will be the cells where the user chooses a part number.
G:J will be the summary of data collected under A:F and fills out
automatically based on the choices made in A:F.

The headers are used in the summary section so I can add the alike part
numbers data. (i figured that part out)

I just can't seem to keep the part number from repeating in the summary
section if it was choosen by the user more than once, This would cause me to
have the same data in multiple summary columns. Maybe this example will
explain what I'm trying to do a little better.

The user enters part numbers in A:G
A B C D E F G
Part #2 Part #1 Part #3 Part #2 Part #4 Part #5 Part #1

The summary page needs to look at the row, pull out the unique part numbers
and list them individually in the summay section without repeating any of
them. So, the entries above will produce the following results in the
summary section (in this example, H:L)

H I J K L
Part #1 Part #2 Part #3 Part #4 Part #5

Thanks for your time!


"Shane Devenshire" wrote:

Hi,

You need to clarify - what calculation do you want to make? Why are the
entries in columns G:J overlapping the entries in columns C3 thru DR3?

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Obrien21" wrote:

I want to set a summary page of data collected per part numbers. I want to
add alike cells that have the same part number. The user chooses a part
number from a list. The user will choose a part number for each column to
collect data; some part numbers may be repeated (only one part number per
column). I want to create a summary page that will calulate the data based
on part number. My only problem is that I need to set the headers correctly
without repeated the same part number twice. Below is a very small example
of my problem.

A B C D E F

1 Part #3 Part #1 Part #4 Part #4 Part #2 Part #3

The desired results would be:

G H I J
1 Part #1 Part #2 Part #3 Part #4

The part numbers are all in one row (C3 thru DR3), No headers. The data
will not be in any order and will change periodically. Unfortunately, The
part numbers are both text and numerical.