LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
DT DT is offline
external usenet poster
 
Posts: 20
Default mininum with referance

Hi,
I have three diff files with the data something like this.
first file
1.xls
12
34
56
78
45

2.xls
21
22
28
35

3.xls
25
66
33
58

i want to use some function which can find the minimum value from each row
of this file and then put the file name of the min value
eg for first row if 12 is the cheapest value , function should return 1.xls

please let me know if this is possible.

 
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
Circular Referance John Vickers Excel Discussion (Misc queries) 2 February 15th 06 08:56 AM
Showing Mininum $ for items woody Excel Worksheet Functions 2 November 1st 05 09:03 AM
cell referance darsg Excel Programming 1 May 13th 05 02:36 PM
How to referance a GroupName Garry[_7_] Excel Programming 3 October 5th 04 01:24 PM
Cross Referance Nathan[_3_] Excel Programming 1 November 7th 03 06:56 AM


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