MAX value in one coulmn based upon another column
Solved/Closed
Piggy70
Posts
3
Registration date
Wednesday May 29, 2013
Status
Member
Last seen
May 30, 2013
-
May 29, 2013 at 05:22 PM
Piggy70 Posts 3 Registration date Wednesday May 29, 2013 Status Member Last seen May 30, 2013 - May 30, 2013 at 08:55 AM
Piggy70 Posts 3 Registration date Wednesday May 29, 2013 Status Member Last seen May 30, 2013 - May 30, 2013 at 08:55 AM
Related:
- Auto serial number in excel based on another column
- Number to words in excel - Guide
- Grand theft auto 1 download - Download - Action and adventure
- How to stop auto refresh in facebook app - Guide
- Grand theft auto v free download no verification for pc - Download - Action and adventure
- Nvidia drivers auto detect - Guide
2 responses
Kevin@Radstock
Posts
42
Registration date
Thursday January 31, 2013
Status
Member
Last seen
April 26, 2014
9
May 30, 2013 at 04:30 AM
May 30, 2013 at 04:30 AM
Hi
Try the following array (CTRL+ SHIFT + ENTER to commit). Assuming the batch numbers are in A1:A14 & prices are in C1:C14, also assuming that the batch numbers are "text".
=MAX(IF(A1:A14="00015",C1:C14))
If they are numbers in column A, formatted as "00000".
=MAX(IF(A1:A14=15,C1:C14))
You might want to look at the aggregate function if you have Excel 2010>.
Try the following array (CTRL+ SHIFT + ENTER to commit). Assuming the batch numbers are in A1:A14 & prices are in C1:C14, also assuming that the batch numbers are "text".
=MAX(IF(A1:A14="00015",C1:C14))
If they are numbers in column A, formatted as "00000".
=MAX(IF(A1:A14=15,C1:C14))
You might want to look at the aggregate function if you have Excel 2010>.
Piggy70
Posts
3
Registration date
Wednesday May 29, 2013
Status
Member
Last seen
May 30, 2013
May 30, 2013 at 08:55 AM
May 30, 2013 at 08:55 AM
Thank you so much! It works beautifully!
