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: 4
Default Looking for a macro/function in an excel spreadsheet (Help)

(Note: Please point me to the correct forum if this isn't the correct
place for this question)

I'm looking for a macro or something that I can place in a cell that
will look at 2 or more (Max 12) cells and return 1. Maximum number, 2.
Minimum number.

Max
eg: 12.5 13.5 14.5 15.6 12.5 11.5 returns 15.6

Min
eg: 12.5 13.5 14.5 15.6 12.5 11.5 returns 11.5

All the cells are in the same row, but NOT every column of the row wants
to be looked at, it maybe cells A1, D1, T1, AA2, AB3 etc (Other data is
in the other cells that I do not want to look at)

Basically, the data is derrived from a csv file which I import into
excel, the data is weather information containing elements such as max
and min temperature, wind gusts etc, all taken from different synop
times 03, 06, 09, 12 hours etc.

Any help would be much appreciated

If I need to make myself clearer please e-mail me on the address below
replacing at with @ and dot with .

Thanks
--
Keith (Southend)
http://www.southendweather.net
e-mail: kreh at southendweather dot net
 
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
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Linked Spreadsheets in Excel 2003 john mcmichael Excel Discussion (Misc queries) 3 November 2nd 06 04:25 PM
Selling & Protecting An Excel Spreadsheet StephenAccountant Excel Discussion (Misc queries) 0 October 30th 06 04:38 AM
Rotating excel spreadsheet for use in photoshop/ using diamond cells tia sal2 [email protected] Excel Discussion (Misc queries) 3 October 22nd 06 02:48 AM
Delay to startup excel spreadsheet Gee Excel Worksheet Functions 2 August 2nd 05 07:30 PM


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