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
- How to convert row to column in notepad++ ✓ - Excel Forum
- If cell contains text then return value in another cell ✓ - Excel Forum
- How to increment numbers when value changes in another column? - Excel Forum
- Run macro when cell value changes - Guide
2 replies
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
767
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!
