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: 113
Default Problem with MATCH () function . . .

FIRST, is it possible to use the MATCH () function on an unsorted range of
data? We just need a match from the range, regardless of whether it is the
first, last, or inbetween match. In turn, this match echos the column
heading label associated with that amount using an INDEX () function.

SECOND, is it possible to return all the matches in an unsorted series, grab
their associated column headings, and then concatenate them into one string?

Any help would be appreciated . . .

 
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
Problem with using match function Montu Excel Worksheet Functions 1 December 29th 07 06:12 PM
Match function problem SJC Excel Worksheet Functions 3 September 14th 07 06:02 PM
Match function problem [email protected] Excel Worksheet Functions 3 October 4th 06 07:39 PM
MATCH function problem LACA Excel Discussion (Misc queries) 10 May 22nd 06 01:39 AM
Problem with match function nander Excel Discussion (Misc queries) 4 April 18th 06 10:08 PM


All times are GMT +1. The time now is 01:51 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"