MINCUS1308
05-27-2015, 06:10 AM
Without using VBA, is there a way to do the following?
Given the following table I would like to determine the largest number for any individual given the 'Type #'.
Name
Type 1
Type 2
Taylor
1
9
Josh
2
8
Kyle
3
7
Kyle
4
6
Bob
5
5
Josh
6
4
Taylor
7
3
Taylor
8
2
Bob
9
1
So if I looked for Taylor, 'Type 1' the cell would return: 8
Josh: 6
Bob: 9
Kyle: 4
And if I looked for Taylor, 'Type 2' the cell would return: 9
Josh: 8
Bob: 5
Kyle: 7
The general idea is to have a table populated by the most recent entry in a much larger table.
Given the following table I would like to determine the largest number for any individual given the 'Type #'.
Name
Type 1
Type 2
Taylor
1
9
Josh
2
8
Kyle
3
7
Kyle
4
6
Bob
5
5
Josh
6
4
Taylor
7
3
Taylor
8
2
Bob
9
1
So if I looked for Taylor, 'Type 1' the cell would return: 8
Josh: 6
Bob: 9
Kyle: 4
And if I looked for Taylor, 'Type 2' the cell would return: 9
Josh: 8
Bob: 5
Kyle: 7
The general idea is to have a table populated by the most recent entry in a much larger table.