Dear excel forum members
I am currently struggling with showing the first value of a group in a new column. I tried the following formula [=OFFSET($J$9;MATCH(C$10:C$126;$K$10:$K$481;0);;;1)], where J9 is the value that needs to appear in the new column L, C10 is the country and its rank, K10:K481 are the matching countries and their ranks.
How it should look:
Column K Column L
Belgium 1 1
Germany 1 1
Greece 1 1
Greece 1
France 1 1
France 1
France 1
France 1
Italy 1 1
Latvia 1 1
Ireland 3 3
Spain 3 3
Spain 3
United Kingdom 3 3
United Kingdom 3
How it looks at the moment:
Column K Column L
Belgium 1 1
Germany 1 #N/A
Greece 1 #N/A
Greece 1 #N/A
France 1 1
France 1 #N/A
France 1 #N/A
France 1 #N/A
Italy 1 1
Latvia 1 #N/A
Ireland 3 3
Spain 3 #N/A
Spain 3 #N/A
United Kingdom 3 3
United Kingdom 3 #N/A
Bookmarks