psychic duck
New Member
- Joined
- Nov 8, 2010
- Messages
- 20
NFL 51
NBA 67
NFL 43
NHL 35
In this table I want to be able to find the highest number, but only with the text "NFL" to the left of the number.
So it therefore doesn't include 67 which is the highest answer but gives the value 51 which is the highest answer with NFL to the left of it.
I want it in a formula not in filter.
NBA 67
NFL 43
NHL 35
In this table I want to be able to find the highest number, but only with the text "NFL" to the left of the number.
So it therefore doesn't include 67 which is the highest answer but gives the value 51 which is the highest answer with NFL to the left of it.
I want it in a formula not in filter.