Returning value from column b in column c, in a cell ajacent to
Solved/Closed
lawrencen
Posts
1
Registration date
Sunday February 17, 2013
Status
Member
Last seen
February 17, 2013
-
Feb 17, 2013 at 09:19 AM
lawrencen - Feb 19, 2013 at 12:27 AM
lawrencen - Feb 19, 2013 at 12:27 AM
Related:
- Returning value from column b in column c, in a cell ajacent to
- Display two columns in data validation list but return only one - Guide
- If cell contains date then return value ✓ - Excel Forum
- Excel formula to check if cell contains a date - Excel Forum
- How to delete column in word - Guide
- If cell A1 has text then cell B2 has today's Date ✓ - Excel Forum
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Feb 17, 2013 at 11:15 AM
Feb 17, 2013 at 11:15 AM
use combination of Max and IF statement
Kevin@Radstock
Posts
42
Registration date
Thursday January 31, 2013
Status
Member
Last seen
April 26, 2014
9
Feb 18, 2013 at 01:44 AM
Feb 18, 2013 at 01:44 AM
Hi lawrencen
Assuming your data is in A1:B15 including headers. In C2:
=IF($B2=MAX($B$2:$B$15),$B2,"") & copy down.
Kevin
@ rizvisa1. You are not very helpful!
Assuming your data is in A1:B15 including headers. In C2:
=IF($B2=MAX($B$2:$B$15),$B2,"") & copy down.
Kevin
@ rizvisa1. You are not very helpful!
