Hello!

I got this formula somewhere - I think I found it online - and it does what I need it to do, but I can't figure out WHY it works! I need to incorporate it into a larger formula, but I don't know the correct syntax, since I don't get it in the first place, LOL!

I have a LONNNGG column of numbers and I need to figure out what row is the last occupied row. Trouble is, there may be some empty rows as well as the fact that there will be more rows added to the end.

Anyway, here's the formula - It looks pretty simple, so it irritates me that I can't wrap my head around it.

=MAX(MATCH(E1+306,A:A,1))
I know what MAX does and I've used MATCH in other formulas, but where the heck does 306 come from?? Is it maybe just a random number that whoever wrote the formula came up with? Or might it be a number that's specific to the worksheet they were working on and it just happens to work on my small sample sheet? It that's the case, and my actual sheet might be anywhere from 10 to 6,000 rows or more, I assume that, at some point, the formula will get "broken".

I really appreciate any "translation" to plain English that someone here can offer!

Jenny