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: 18
Default match and large fumction

I use this formula
MATCH(LARGE(J$1:J$55,ROW()),J$1:J$55,0
It returns the row numbers which translates to the largest number in the
range large to small
Problem is if there numbers in the range which are duplicates,it will
return the same row number ,I need it to return the row number +1

A1 5 2
A2 6 1
A3 4 4
A4 3 3
A5 3 4 <<<<< should be 5
 
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 Match function with duplicate values in an array Richard Excel Worksheet Functions 3 April 22nd 23 07:45 PM
Is there a way MATCH() can cope with duplicate values? JimmyQ Excel Worksheet Functions 3 August 9th 06 11:25 PM
Large Index Match Lookup Qaspec Excel Worksheet Functions 3 August 20th 05 01:13 AM
Match, Index, Vlookup, Large....Help Please [email protected] Excel Worksheet Functions 3 December 15th 04 01:38 PM
Match, Index, Vlookup, Large....Help Please [email protected] Excel Worksheet Functions 0 December 14th 04 11:16 PM


All times are GMT +1. The time now is 02:57 AM.

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"