J
John
Hi
I have a column of part numbers that has many duplicate
entries. (Each row denotes a different area where the
part is used). In addition to the different areas of
usage, there are three distinct global areas of usage of
the parts and these are entered in a second column against
each part number. I need to identify, by global area, the
duplicate parts within that area. This should then enable
me to analyse, by global area, the number of unique parts
used in each as a percentage of each other.
I used to do this by having the global areas in separate
worksheets and using the IF Function to place either a 1
or 0 in a cell, (IF A1=A2,0,1) but this doesn't work with
the combined worksheet due to rows being filtered out.
Excel always looks at the preceding numerical value cell
even though it may be filtered out.
Sorry for such a long and complex enquiry
John
I have a column of part numbers that has many duplicate
entries. (Each row denotes a different area where the
part is used). In addition to the different areas of
usage, there are three distinct global areas of usage of
the parts and these are entered in a second column against
each part number. I need to identify, by global area, the
duplicate parts within that area. This should then enable
me to analyse, by global area, the number of unique parts
used in each as a percentage of each other.
I used to do this by having the global areas in separate
worksheets and using the IF Function to place either a 1
or 0 in a cell, (IF A1=A2,0,1) but this doesn't work with
the combined worksheet due to rows being filtered out.
Excel always looks at the preceding numerical value cell
even though it may be filtered out.
Sorry for such a long and complex enquiry
John