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: 1
Default How to find the largest value in a column?

I have 4 columns of data and 96 total rows to find the largest value in
column D based on the largest value of colum C. Here is what the information
looks like:

Col. A Col. B Col. C Col. D
1/1/05 00:00:00 1500.35 465.50
1/1/05 00:15:00 2331.52 396.45
1/1/05 00:30:00 2630.18 751.66
1/1/05 00:45:00 475.00 0.0
1/1/05 01:00:00 2630.18 756.75

In this case, I would like the number 756.75 to be displayed.

I would like any help I can get.
 
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
macro unouwanme Excel Discussion (Misc queries) 9 August 31st 06 09:38 PM
Find Largest and Return Column Name Tom321 Excel Worksheet Functions 2 March 17th 06 05:09 PM
Macro to find text string in a column and paste data in another nicolascap Excel Discussion (Misc queries) 8 March 14th 06 03:13 PM
creating a bar graph Johnfli Excel Discussion (Misc queries) 0 October 26th 05 08:16 PM
Find a empty cell in next column Michael Excel Discussion (Misc queries) 3 June 15th 05 02:18 PM


All times are GMT +1. The time now is 07:32 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"