Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 16
Default lookup list return diff??

lookup list with 40 items/entries and return to a different sheet and only
top ten of the list and sorted descending? used filter range and others cant
work it out..thanks in advance....
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,355
Default lookup list return diff??

Is the list you are extracting the data from sorted in increasing order?

"ronald" wrote:

lookup list with 40 items/entries and return to a different sheet and only
top ten of the list and sorted descending? used filter range and others cant
work it out..thanks in advance....

Reply
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 lookup multilple criteria and return a single value StephenAccountant Excel Worksheet Functions 1 June 9th 06 03:23 AM
return one value from list ChadTarget Excel Worksheet Functions 2 June 6th 06 06:46 PM
VLOOKUP CONDITION TO RETURN BLANK CELL WHERE LOOKUP VALUE IS NOT IN TABLE ARRAY Scott Lolmaugh Excel Worksheet Functions 3 March 9th 06 11:05 PM
lookup mutliple values to return one value David Pelizzari, IS Manager Excel Worksheet Functions 1 February 7th 06 01:26 AM
Return cell reference of lookup value bobm Excel Worksheet Functions 3 July 7th 05 08:49 AM


All times are GMT +1. The time now is 07:57 PM.

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

About Us

"It's about Microsoft Excel"