Find Highest Number

[guamlet]

I have a column of data that takes the form of a letter followed by a number (i.e. H004). Sometimes the number is followed by a period and more letters and numbers (i.e. H004.2a.3d). I want to search for the highest number in the characters before the first period (the H004) and return one number higher (i.e. H005). Any suggestions?

 

[guamlet]

Yeah, they can go up to 999. I'm such a pain...thanks for helping me out!

 

[guamlet]

Hey, I think I found a solution....its DMax! I found it while looking at Mid and Var. All I have to do is modify the example in the help file and voila!

var=DMax([LineName],"Cell Lines", [LineName] like 'H*'")

seems to work.

Thanks for all your help!

 

[Russell Hauf]

Good, that is nice & easy. Glad you got it figured out!