3 linked drop down lists referenced off a table(s)??

D

DMJ62

New Member
Joined
Dec 15, 2012
Messages
3
Hi everyone,
I've been trying very hard to tackle this on my own, but this is taking a toll my nerves! I’ve been searching everywhere for answers, but feel like either I’m struggling to find the right answer. I don’t see an option to upload my file so I’ll try to rebuild it.
So here's what I’m trying to do:
1st I was able to get the 3 tier dropdown list to work between columns A-I. B2:E4 are the list dropdown that reference data in columns G-I. The list drop downs are what I want, but I don’t really like the organization of the data in G-I. I’m hoping for tables or one table. I think by using a table format will be cleaner and allow greater dynamics.

So in column L-O I made three tables to resemble the data in columns G-I. Column Q-U can be used as the list dropdown for the tables. I’m really confused on how to have the list validations link to the tables or if I even have this table with the data organized properly.

Can anyone teach me or show me an example of how to do this on the attached spreadsheet?
(first time using the MrExcel HTML maker. lol i hope

Excel 2010
A
B
C
D
E
F
G
H
I
Country
City
Street
area code
Netherlands
Britain
Germany
David
Britain
Manchester
ManchesterStreet1
Amsterdam
London
Bonn
Linda
Rotterdam
Canterbury
Berlin
Peter
Netherlands
Eindhoven
EindhovenStreet1
Eindhoven
Manchester
Munich
Amsterdam
London
Bonn
AmsterdamStreet1
LondonStreet1
BonnStreet1
AmsterdamStreet2
LondonStreet2
BonnStreet2
Rotterdam
Canterbury
Berlin
RotterdamStreet1
CanterburyStreet1
BerlinStreet1
RotterdamStreet2
CanterburyStreet2
BerlinStreet2
Eindhoven
Manchester
Munich
EindhovenStreet1
ManchesterStreet1
MunichStreet1
EindhovenStreet2
ManchesterStreet2
MunichStreet2
AmsterdamStreet1
LondonStreet1
BonnStreet1

<tbody>
[TD="align: center"] 1
[/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: center"] 2
[/TD]

[TD="align: right"] 103
[/TD]
[TD="align: right"][/TD]

[TD="align: center"] 3
[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"] 4
[/TD]

[TD="align: right"] 102
[/TD]
[TD="align: right"][/TD]

[TD="align: center"] 5
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"] 6
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"] 7
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"] 8
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"] 9
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"] 10
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"] 11
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"] 12
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"] 13
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"] 14
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"] 15
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"] 16
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"] 17
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"] 18
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"] 19
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"] 407
[/TD]
[TD="align: center"] 321
[/TD]
[TD="align: center"] 852
[/TD]

[TD="align: center"] 20
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"] 904
[/TD]
[TD="align: center"] 565
[/TD]
[TD="align: center"] 456
[/TD]

[TD="align: center"] 21
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"] 305
[/TD]
[TD="align: center"] 568
[/TD]
[TD="align: center"] 951
[/TD]

[TD="align: center"] 22
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"] AmsterdamStreet2
[/TD]
[TD="align: center"] LondonStreet2
[/TD]
[TD="align: center"] BonnStreet2
[/TD]

[TD="align: center"] 23
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"] 222
[/TD]
[TD="align: center"] 753
[/TD]
[TD="align: center"] 984
[/TD]

[TD="align: center"] 24
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"] 333
[/TD]
[TD="align: center"] 862
[/TD]
[TD="align: center"] 789
[/TD]

[TD="align: center"] 25
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"] 444
[/TD]
[TD="align: center"] 842
[/TD]
[TD="align: center"] 432
[/TD]

[TD="align: center"] 26
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"] RotterdamStreet1
[/TD]
[TD="align: center"] CanterburyStreet1
[/TD]
[TD="align: center"] BerlinStreet1
[/TD]

[TD="align: center"] 27
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"] 111
[/TD]
[TD="align: center"] 805
[/TD]
[TD="align: center"] 501
[/TD]

[TD="align: center"] 28
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"] 666
[/TD]
[TD="align: center"] 905
[/TD]
[TD="align: center"] 502
[/TD]

[TD="align: center"] 29
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"] RotterdamStreet2
[/TD]
[TD="align: center"] CanterburyStreet2
[/TD]
[TD="align: center"] BerlinStreet2
[/TD]

[TD="align: center"] 30
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"] 777
[/TD]
[TD="align: center"] 702
[/TD]
[TD="align: center"] 706
[/TD]

[TD="align: center"] 31
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"] 999
[/TD]
[TD="align: center"] 705
[/TD]
[TD="align: center"] 708
[/TD]

[TD="align: center"] 32
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"] EindhovenStreet1
[/TD]
[TD="align: center"] ManchesterStreet1
[/TD]
[TD="align: center"] MunichStreet1
[/TD]

[TD="align: center"] 33
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"] 101
[/TD]
[TD="align: center"] 103
[/TD]
[TD="align: center"] 105
[/TD]

[TD="align: center"] 34
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"] 102
[/TD]
[TD="align: center"] 104
[/TD]
[TD="align: center"] 106
[/TD]

[TD="align: center"] 35
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"] EindhovenStreet2
[/TD]
[TD="align: center"] ManchesterStreet2
[/TD]
[TD="align: center"] MunichStreet2
[/TD]

[TD="align: center"] 36
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"] 508
[/TD]
[TD="align: center"] 900
[/TD]
[TD="align: center"] 100
[/TD]

[TD="align: center"] 37
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"] 509
[/TD]
[TD="align: center"] 800
[/TD]
[TD="align: center"] 99
[/TD]

[TD="align: center"] 38
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"] 11
[/TD]
[TD="align: center"] 97
[/TD]
[TD="align: center"] 98
[/TD]

</tbody>
Sheet1​
Above is the table that works with linked dropdown list to the data on the right. Below are the tables that are (I think dynamic) but like I described I don’t know how to reference the tables so they’re dependent on the list selection. I wish I could upload my file. L I could only find instruction on converting my information into html.

Excel 2010
L
M
N
O
P
Q
R
S
T
U
Netherlands Country Table
Country
City
Street
area code
City
Address
Area Code
Column1
David
Amsterdam
AmsterdamStreet1
Amsterdam, AmsterdamStreet1, 407
Linda
Amsterdam
AmsterdamStreet1
Amsterdam, AmsterdamStreet1, 904
Peter
Amsterdam
AmsterdamStreet1
Amsterdam, AmsterdamStreet1, 305
Amsterdam
AmsterdamStreet2
Amsterdam, AmsterdamStreet2, 222
Amsterdam
AmsterdamStreet2
Amsterdam, AmsterdamStreet2, 333
Amsterdam
AmsterdamStreet2
Amsterdam, AmsterdamStreet2, 444
Rotterdam
RotterdamStreet1
Rotterdam, RotterdamStreet1, 111
Rotterdam
RotterdamStreet1
Rotterdam, RotterdamStreet1, 666
Rotterdam
RotterdamStreet2
Rotterdam, RotterdamStreet2, 777
Rotterdam
RotterdamStreet2
Rotterdam, RotterdamStreet2, 999
Eindhoven
EindhovenStreet1
Eindhoven, EindhovenStreet1, 101
Eindhoven
EindhovenStreet1
Eindhoven, EindhovenStreet1, 102
Eindhoven
EindhovenStreet2
Eindhoven, EindhovenStreet2, 508
Eindhoven
EindhovenStreet2
Eindhoven, EindhovenStreet2, 509
Eindhoven
EindhovenStreet2
Eindhoven, EindhovenStreet2, 11
Britain Country Table
City
Address
Area Code
Column1
London
LondonStreet1
London, LondonStreet1, 321
London
LondonStreet1
London, LondonStreet1, 565
London
LondonStreet1
London, LondonStreet1, 568
London
LondonStreet2
London, LondonStreet2, 753
London
LondonStreet2
London, LondonStreet2, 862
London
LondonStreet2
London, LondonStreet2, 842
Canterbury
CanterburyStreet1
Canterbury, CanterburyStreet1, 805
Canterbury
CanterburyStreet1
Canterbury, CanterburyStreet1, 905
Canterbury
CanterburyStreet2
Canterbury, CanterburyStreet2, 702
Canterbury
CanterburyStreet2
Canterbury, CanterburyStreet2, 705
Manchester
ManchesterStreet1
Manchester, ManchesterStreet1, 103
Manchester
ManchesterStreet1
Manchester, ManchesterStreet1, 104
Manchester
ManchesterStreet2
Manchester, ManchesterStreet2, 900
Manchester
ManchesterStreet2
Manchester, ManchesterStreet2, 800
Manchester
ManchesterStreet2
Manchester, ManchesterStreet2, 97
Germany Country Table
City
Address
Area Code
Column1
Bonn
BonnStreet1
Bonn, BonnStreet1, 852
Bonn
BonnStreet1
Bonn, BonnStreet1, 456
Bonn
BonnStreet1
Bonn, BonnStreet1, 951
Bonn
BonnStreet2
Bonn, BonnStreet2, 984
Bonn
BonnStreet2
Bonn, BonnStreet2, 789
Bonn
BonnStreet2
Bonn, BonnStreet2, 432
Berlin
BerlinStreet1
Berlin, BerlinStreet1, 501
Berlin
BerlinStreet1
Berlin, BerlinStreet1, 502
Berlin
BerlinStreet2
Berlin, BerlinStreet2, 706
Berlin
BerlinStreet2
Berlin, BerlinStreet2, 708
Berlin
BerlinStreet2
Berlin, BerlinStreet2, 105
Munich
MunichStreet1
Munich, MunichStreet1, 106
Munich
MunichStreet1
Munich, MunichStreet1, 100
Munich
MunichStreet2
Munich, MunichStreet2, 99
Munich
MunichStreet2
Munich, MunichStreet2, 98

<tbody>
[TD="align: center"]1
[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]2
[/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]3
[/TD]

[TD="align: center"]407
[/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]4
[/TD]

[TD="align: center"]904
[/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]5
[/TD]

[TD="align: center"]305
[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]6
[/TD]

[TD="align: center"]222
[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]7
[/TD]

[TD="align: center"]333
[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]8
[/TD]

[TD="align: center"]444
[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]9
[/TD]

[TD="align: center"]111
[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]10
[/TD]

[TD="align: center"]666
[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]11
[/TD]

[TD="align: center"]777
[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]12
[/TD]

[TD="align: center"]999
[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]13
[/TD]

[TD="align: center"]101
[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]14
[/TD]

[TD="align: center"]102
[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]15
[/TD]

[TD="align: center"]508
[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]16
[/TD]

[TD="align: center"]509
[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]17
[/TD]

[TD="align: center"]11
[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]18
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]19
[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]20
[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]21
[/TD]

[TD="align: center"]321
[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]22
[/TD]

[TD="align: center"]565
[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]23
[/TD]

[TD="align: center"]568
[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]24
[/TD]

[TD="align: center"]753
[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]25
[/TD]

[TD="align: center"]862
[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]26
[/TD]

[TD="align: center"]842
[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]27
[/TD]

[TD="align: center"]805
[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]28
[/TD]

[TD="align: center"]905
[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]29
[/TD]

[TD="align: center"]702
[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]30
[/TD]

[TD="align: center"]705
[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]31
[/TD]

[TD="align: center"]103
[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]32
[/TD]

[TD="align: center"]104
[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]33
[/TD]

[TD="align: center"]900
[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]34
[/TD]

[TD="align: center"]800
[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]35
[/TD]

[TD="align: center"]97
[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]36
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]37
[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]38
[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]39
[/TD]

[TD="align: center"]852
[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]40
[/TD]

[TD="align: center"]456
[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]41
[/TD]

[TD="align: center"]951
[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]42
[/TD]

[TD="align: center"]984
[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]43
[/TD]

[TD="align: center"]789
[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]44
[/TD]

[TD="align: center"]432
[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]45
[/TD]

[TD="align: center"]501
[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]46
[/TD]

[TD="align: center"]502
[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]47
[/TD]

[TD="align: center"]706
[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]48
[/TD]

[TD="align: center"]708
[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]49
[/TD]

[TD="align: center"]105
[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]50
[/TD]

[TD="align: center"]106
[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]51
[/TD]

[TD="align: center"]100
[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]52
[/TD]

[TD="align: center"]99
[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]53
[/TD]

[TD="align: center"]98
[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>
Sheet1
​
this is my first post on this site, so please give me friendly guidance :)
 
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

B
  • Question Question
average based on time
Replies
1
Views
577
baqer
B
J
  • Question Question
Need some help with permutation code, convert from one cell to a range
Replies
3
Views
473
johnnyL
J
L
  • Question Question
I would like to see the distribution by hour and day of these entries but don't have a clue where to start...
Replies
6
Views
1K
leanheart
L
S
  • Question Question
Filter the values.
Replies
6
Views
775
sekar_r24
S
S
  • Question Question
Consecutive points scored basketball
Replies
6
Views
5K
lrobbo314
lrobbo314

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top