tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone
I'm trying to find the max and min number in a column but i need it to have the last 6 letters in another column = "Excess" I say last 6 letter not last word as it can be "Legalexcess" or "Upperexcess" or just excess etc, )
the column i want the max and mins from is column AA
The Excess is in column H
prefer a formula for this if possible?
please help if you can
thanks
Tony
I'm trying to find the max and min number in a column but i need it to have the last 6 letters in another column = "Excess" I say last 6 letter not last word as it can be "Legalexcess" or "Upperexcess" or just excess etc, )
the column i want the max and mins from is column AA
The Excess is in column H
prefer a formula for this if possible?
please help if you can
thanks
Tony