LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Tammi
 
Posts: n/a
Default Find min/max in 2 combined columns

I am trying to find the lowest, highest, and average age based on a large
list. The ages are in terms of years and months, and do not rely on
birthdates.
A B
Years Months
1 2 10
2 5 6
3 4 8
4 2 9

Is this possible??
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
How do I find the cell address of the 2nd largest of a set? Mr. Snrub Excel Discussion (Misc queries) 4 May 30th 05 12:53 PM
Tab Stop across Columns [email protected] Excel Worksheet Functions 3 March 13th 05 03:45 AM
identify numbers which are listed in two columns. the_kane Excel Worksheet Functions 1 March 8th 05 06:21 AM
Filtering Text Data from Multiple columns Brad Excel Worksheet Functions 6 January 1st 05 03:32 PM
combining 3 columns of same info for a pivot table Julie Excel Worksheet Functions 0 December 15th 04 03:12 PM


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