LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 110
Default How do I show only the cell in a row with the greatest value?

In Microsoft Excel I have a row with a different value in each cell and I am
looking to show only the cell that has the greatest value in that row. I
would like for all the other cells to be hidden in that row. I would also
like the program to do this automatically. Any ideas how to complete this?

Thanks!
 
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
finding greatest (or least) date associated with given value sprocideon Excel Discussion (Misc queries) 2 June 23rd 06 07:43 AM
Finding the greatest value t2true Excel Discussion (Misc queries) 4 March 21st 06 01:48 AM
Greatest to smallest Dug Excel Discussion (Misc queries) 3 December 4th 05 06:58 PM
Displaying Greatest to Least? Losse Excel Discussion (Misc queries) 2 July 14th 05 08:22 PM
How to filter by greatest of Ruthless Techno Wienee Excel Worksheet Functions 2 November 9th 04 05:17 PM


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