christianna
New Member
- Joined
- Jul 20, 2008
- Messages
- 6
I have a file with 4 columns and about 21 rows (Excel 2010). The first table in the sheet holds number of occurances in column A and then column B is the name of the occurance. In column E I use the Large function (=LARGE($A$4:$A$23,1), =LARGE($A$4:$A$23,2), etc.) in each of the rows to create a descending list of the occurances (creating a Pareto diagram). In column D, I am trying to pull in the corresponding name of each occurance using the Vlookup command (=VLOOKUP(E4,$A$4:$B$21,2,FALSE), =VLOOKUP(E5,$A$4:$B$21,2,FALSE), etc). The problem is that when there are multiple occurances with the same number of occurances (15 missing information, 15 stockouts) it is only pulling the first name of the occurance into the D column.
So, if there's a number 15 in A4 with the occurance name of missing info in B4 and a number 15 in A5 with the occurance name of stockouts in B5, the E column is right, and D4 is right (shows missing information), but D5 doesn't show stockouts, it repeats missing information. Hope that makes sense. Here's a summary of the cells:
A4 = 15
B4 = missing info
A5 = 15
B5 = stockouts
D4 = =LARGE($A$4:$A$23,1) ***15 is the largest number in the list
E4 = =VLOOKUP(E4,$A$4:$B$21,2,FALSE)
D5 = =LARGE($A$4:$A$23,2)
E5 = =LARGE($A$4:$A$23,2)
Since I'm trying to use this info to create a Pareto diagram, I need the name of the occurance to be accurate. Is there a better way to do this or how can I make this work?
So, if there's a number 15 in A4 with the occurance name of missing info in B4 and a number 15 in A5 with the occurance name of stockouts in B5, the E column is right, and D4 is right (shows missing information), but D5 doesn't show stockouts, it repeats missing information. Hope that makes sense. Here's a summary of the cells:
A4 = 15
B4 = missing info
A5 = 15
B5 = stockouts
D4 = =LARGE($A$4:$A$23,1) ***15 is the largest number in the list
E4 = =VLOOKUP(E4,$A$4:$B$21,2,FALSE)
D5 = =LARGE($A$4:$A$23,2)
E5 = =LARGE($A$4:$A$23,2)
Since I'm trying to use this info to create a Pareto diagram, I need the name of the occurance to be accurate. Is there a better way to do this or how can I make this work?