Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Minimum value location


-----Original Message-----
I an writing a macro to do a bunch of calculation and
place the result in a column. I want to be able to ID
the row with the minimum value. what is the easist way
to do that?
.
=MATCH(MIN(array),array,0)

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
MINIMUM Pam M Excel Worksheet Functions 4 August 31st 09 04:06 PM
Macro - save to current location vs excel default location leezard Excel Discussion (Misc queries) 0 October 28th 08 03:04 PM
Minimum value look up [email protected] Excel Worksheet Functions 3 October 7th 08 02:35 AM
How to lookup the minimum, 2nd minimum and 3rd minimum......... Mark McDonough Excel Worksheet Functions 8 July 15th 06 09:39 PM
Minimum but One?? twogoodtwo Excel Worksheet Functions 3 November 29th 05 02:52 PM


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