Returning value from column b in column c, in a cell ajacent to
Solved/Closed
lawrencen
Posts
1
Registration date
Sunday 17 February 2013
Status
Member
Last seen
17 February 2013
-
17 Feb 2013 à 09:19
lawrencen - 19 Feb 2013 à 00:27
lawrencen - 19 Feb 2013 à 00:27
Related:
- Returning value from column b in column c, in a cell ajacent to
- How to delete a column in word - Guide
- Excel column number - Guide
- Tweetdeck expand column - Guide
- Excel vba find last non empty cell in column - Guide
- Excel count occurrences in column - Guide
2 responses
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
17 Feb 2013 à 11:15
17 Feb 2013 à 11:15
use combination of Max and IF statement
Kevin@Radstock
Posts
42
Registration date
Thursday 31 January 2013
Status
Member
Last seen
26 April 2014
9
18 Feb 2013 à 01:44
18 Feb 2013 à 01:44
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!
