Formula for Last Used Cell in a Column

[Dean England]

Hey All,

I have several columns, in which, I need to find the address of the last cell used. The last cell used in each of these columns will be different, so I only need a formula for one and I can work it out for the rest. I've worked out the ADDRESS formula for another application, but I'm scrambling on this one. I could use a little of your valuable expertise on this one. I need to find the last cell used in column G, say $G$26, placed in cell Cell B1. I hope this makes sense.

Thanks for looking,

Dean

[VBA Noob]

Maybe


=ADDRESS(MAX(MATCH({"ZZZZZZZZZZZZZZZZZZZZ",9.99999999999999E+307},G:G)),7,4)

remove ,4 if you want the $ signs

VBA Noob

[Dean England]

Hey Noob,

I'm getting #N/A on this. That's more than I was getting off my efforts. Any more suggestions, other than for me to leave the room?

Dean

[VBA Noob]

Sorry,

The example I give assumed you had mixed text. If it's only numeric or only text try either of the attached

if you still have a problem this site may help

http://www.xldynamic.com/source/xld....l#last_numeric

VBA Noob

[Dean England]

Hi Noob,

Awesome! You assumed I had mixed text, because I didn't, totally, explain my needs. However, now I have something for all contingencies, in my little file. Thank you very much and have a nice rest of your day.

See ya,

Dean