LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 41
Default Looking up the results from the function "LARGE"

Hello,

I have an array that I'm using LARGE to find the top ten values. I want to
use VLOOKUP, or what ever else suits, on these top ten values to find other
values in the array. This works fine until the top ten that LARGE yields has
2 or more values the same. How would I eliminate a value that has already
been returned/looked up in order to find the next in line?

Thanks for your time?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i enable negative results in the lcm function? Cyberscryed Excel Worksheet Functions 7 July 24th 06 01:18 PM
Can Function results be calculated? FranksBank New Users to Excel 2 February 21st 06 01:18 PM
Excel's Fourier Analysis should be a function, so that results upd BobM Excel Worksheet Functions 4 January 30th 06 03:06 PM
clock Wildman Excel Worksheet Functions 2 April 26th 05 10:31 AM
Using function results as parameters in another function Steve Haack Excel Worksheet Functions 1 April 24th 05 11:39 PM


All times are GMT +1. The time now is 04:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"