Generating a List based on enterie Totals

SuperFlySi

New Member
Joined
May 30, 2018
Messages
2
After a solution to a problem I'm having with generating a list that is populated with entries that are defined from a separate table.

So I need to generate a list that looks like this
North
East
South
South
South
South
South
West
West

From a table that is made up of values for each entire like this


North
1
East
2
South
4
West
2
Any help would be appreciated, quite a novice when it comes to Excel tbh!

Simon

<tbody>
</tbody>

<tbody>
</tbody>
 

Oscar Cronquist

Board Regular
Joined
Apr 20, 2018
Messages
200
A
B
C
D
1
North
1​
List
2
East
2​
North
3
South
4​
East
4
West
2​
East
5
South
6
South
7
South
8
South
9
West
10
West
Sheet: Sheet65

Array formula in cell D2:

=INDEX($A$1:$A$4,MATCH(FALSE, COUNTIF($D$1:D1,$A$1:$A$4)=$B$1:$B$4,0))
 

SuperFlySi

New Member
Joined
May 30, 2018
Messages
2
This is awesome, I've been at this for Hrs with no Joy. Thanks very much Oscar!

Just need to figure out how to get it to populate a table based on table title :)
 

Forum statistics

Threads
1,082,478
Messages
5,365,788
Members
400,850
Latest member
Raj_Jpr

Some videos you may like

This Week's Hot Topics

Top