Generating a List based on enterie Totals

[SuperFlySi]

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
[TABLE="width: 48"]
<tbody>[TR]
[TD="width: 64, bgcolor: transparent, align: left"]North
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: left"]East
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: left"]South
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: left"]South
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: left"]South
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: left"]South
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: left"]South
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: left"]West
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: left"]West

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


[TABLE="width: 152"]
<tbody>[TR]
[TD="width: 139, bgcolor: transparent, align: left"]North
[/TD]
[TD="width: 64, bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: left"]East
[/TD]
[TD="bgcolor: transparent, align: right"]2
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: left"]South
[/TD]
[TD="bgcolor: transparent, align: right"]4
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: left"]West
[/TD]
[TD="bgcolor: transparent, align: right"]2
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: left"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: left"]Any help would be appreciated, quite a novice when it comes to Excel tbh!

Simon
[/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Oscar Cronquist]

[Table="width:, class:head"][tr=bgcolor:#E0E0F0][th] [/th][th]

A​

[/th][th]

B​

[/th][th]

C​

[/th][th]

D​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

1​

[/td][td]North[/td][td]

1​

[/td][td][/td][td]List[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

2​

[/td][td]East[/td][td]

2​

[/td][td][/td][td]North[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

3​

[/td][td]South[/td][td]

4​

[/td][td][/td][td]East[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

4​

[/td][td]West[/td][td]

2​

[/td][td][/td][td]East[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

5​

[/td][td][/td][td][/td][td][/td][td]South[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

6​

[/td][td][/td][td][/td][td][/td][td]South[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

7​

[/td][td][/td][td][/td][td][/td][td]South[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

8​

[/td][td][/td][td][/td][td][/td][td]South[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

9​

[/td][td][/td][td][/td][td][/td][td]West[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

10​

[/td][td][/td][td][/td][td][/td][td]West[/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Sheet65[/td][/tr][/table]

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]

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