Return the maximum of A,B,C,0,1,2,3

[Emmar01]

I am doing a document register where each document starts at Revision A. Once that document is revised, it becomes Revision B, then C, and so on. Once the document is formally approved, the revision number system changes to 0, and when Revision 0 is modified it becomes Revision 1, and so on.

Is there any (Non-VBA) method I can use the look through my document history (Revs A,B,C,0,1,2 etc)?

So if my range of cells cover A|B|C|0|1|2 etc, I'm basically looking for a variant of the MAX function to return the latest revision number/letter.

 

[Aladin Akyurek]

Care to post a bit clearer sample along with what you expect to see?

 

[István Hirsch]

Is this what you need?

Excel Workbook
	A	B
1	2	12
2	X
3	5
4	U
5	0
6	A
7	B
8	12
9	K
10	T
Sheet

 

[Emmar01]

Thanks guys, that works!

 

[István Hirsch]

You are welcome.