I have a spreadsheet I used to use the following formula in using Excel 2007. It worked great. I'm now using Excel 2010 and it is not working. Any ideas?
=RIGHT($B1,5)="TOTAL"
I have a spreadsheet I used to use the following formula in using Excel 2007. It worked great. I'm now using Excel 2010 and it is not working. Any ideas?
=RIGHT($B1,5)="TOTAL"
I suspect it's case sensitive. Try:
=RIGHT($B1,5)="Total"
That works in Excel 2007
Regards
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks