double values for LARGE

**jed_vii** · 03-05-2007, 12:16 PM

Say I have the following numbers in a column

2
3
3
5
5
6
7

I use large to list the top three. I correctly identifies 2,3,and 3. but now I want to get a list of the values in the B col. So I use VLOOKUP to get that data. Since, there are two 3's, it will only look up one value. In a small list like this it isn't too hard to just look, but with 100's of values, is there a way to make sure I get all the values in the B col associated with the doubles in the A col.

I'm open to adding an additional column with the original values to fudge the doulbes, ie: IF(LARGE(a:a,1)=LARGE(a:a,2),a1+.1,a1), but that would do that to the others as well.

any thoughts?

-jed

**starguy** · 03-05-2007, 12:23 PM

Originally Posted by jed_vii

Say I have the following numbers in a column

2
3
3
5
5
6
7

I use large to list the top three. I correctly identifies 2,3,and 3. but now I want to get a list of the values in the B col. So I use VLOOKUP to get that data. Since, there are two 3's, it will only look up one value. In a small list like this it isn't too hard to just look, but with 100's of values, is there a way to make sure I get all the values in the B col associated with the doubles in the A col.

I'm open to adding an additional column with the original values to fudge the doulbes, ie: IF(LARGE(a:a,1)=LARGE(a:a,2),a1+.1,a1), but that would do that to the others as well.

any thoughts?

-jed

see the attached file and let me know if it helps

**jed_vii** · 03-05-2007, 12:58 PM

the helper col was a HUGE help. instead of the &, i used:

=IF(ISBLANK(D8),"",D8+(COUNTIF(D8:$D$78,D8)/10000))

And when I format the col's to two decimal points, it doesn't look weird either.

thanks,
-jed

**starguy** · 03-05-2007, 01:25 PM

Originally Posted by jed_vii

the helper col was a HUGE help. instead of the &, i used:

=IF(ISBLANK(D8),"",D8+(COUNTIF(D8:$D$78,D8)/10000))

And when I format the col's to two decimal points, it doesn't look weird either.

thanks,
-jed

pleased to know that it helped you.

**HenryCheung204** · 03-09-2007, 11:22 PM

Say I have the following:

1 check
2 checks
1 check
2 checks
2 checks

How do I find the [sum] of the above check[s] using the spreadsheet on Microsoft Excel?