LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Les
 
Posts: n/a
Default Match function...random search?

The match function will search a random order range to find an exact match.
It will search an ascending order range to find an equal or lesser value.
And inversely it will find an equal or greater value in a descending range.
Is there a way or a function which will find a equal or greater value in a
random order range?

Thanks,
Les


 
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
Using Search with either vlookup or match and index jlowenstein Excel Worksheet Functions 1 July 22nd 05 03:18 AM
I want to use the MATCH function with the AVERAGE function but I . Miguel Excel Worksheet Functions 2 April 23rd 05 05:29 PM
Improve the search function for help DrBob Excel Discussion (Misc queries) 0 April 22nd 05 05:34 PM
VBA Search function tamato43 Excel Discussion (Misc queries) 0 March 29th 05 08:09 PM
Match function selecting first value it matches on exactly Paul K. Excel Worksheet Functions 1 February 24th 05 08:57 PM


All times are GMT +1. The time now is 11:02 PM.

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"