"Large" function in Excel

davidhall80

Well-known Member
Joined
Jul 8, 2006
Messages
663
I am using the Large function to return the 30 largest values from one tab to another. I am than Vlooking up these values to bring back the name of the client...The problem is some of the values are the same...thus returning the same customer name twice instead if returning 2 seperate customer names....Make sense...Any suggestions.
 

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

mortgageman

Well-known Member
Joined
Jun 30, 2005
Messages
2,015
I am using the Large function to return the 30 largest values from one tab to another. I am than Vlooking up these values to bring back the name of the client...The problem is some of the values are the same...thus returning the same customer name twice instead if returning 2 seperate customer names....Make sense...Any suggestions.

Could you sort the data and then add a counter? Then you could use the large function to return the counter which would of course be unique.
 

Forum statistics

Threads
1,181,412
Messages
5,929,784
Members
436,692
Latest member
ModestMuse

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top