Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
beechum1
 
Posts: n/a
Default out of a group of cells, if max, then display this other cell


i have 10 non adjacent cells, that i'd like return not only the value
(%) of the highest 1 cell, but also the value for the cell 3 cells left
and 3 cells down of that highest cell in the group.

What you got on that one??

bonus.... i'd like to do that for the 3 highest.


--
beechum1
------------------------------------------------------------------------
beechum1's Profile: http://www.excelforum.com/member.php...o&userid=30489
View this thread: http://www.excelforum.com/showthread...hreadid=511448

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
How can I hide the words of a cell (or a group of cells)... Octavio New Users to Excel 15 January 22nd 06 07:50 PM
Transfer Cell Formatting for linked cells Scott Excel Discussion (Misc queries) 2 November 23rd 05 11:04 PM
How to insert a value in one cell into many cells Thomas Excel Worksheet Functions 17 October 18th 05 11:03 AM
copying cell names Al Excel Discussion (Misc queries) 12 August 11th 05 03:01 PM
Need to find the right-most cell value in a string of cells -dc- Excel Worksheet Functions 2 March 8th 05 07:28 PM


All times are GMT +1. The time now is 03:58 PM.

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"