Hi all,
I have a spreadsheet that records the last issue number of a document.
ie a column of numbers that goes 1,2,3,4...etc. I then use the formula "=max(A1:A6000) that simply gives me the latest, (ie largest) number that I can then feed into various sub worksheets.
However, some people use text letters for issue control.....ie a.b,c,d...etc.
Is there any way to perform a simple calculation that will look at all the letters in a column and report the "last" one used?
Thanks,
Stu
Bookmarks