EXCEL FORMULA

[SURESH]

Dear friends,

anyone can tell me which formula will help me to know which is the last
entered cell.

For example:
My data is A1:P109

so the formula should say the last entered row/cell is 109

thanks in advance

best regards,
suersh tp

[Don Guillett]

try this array formula (entered with ctrl+shift+enter) for either text or
number
=INDEX(A1:A65535,MAX((ISNUMBER(A1:A65535)+ISTEXT(A1:A65535))*ROW(INDIRECT("1
:65535"))))

--
Don Guillett
SalesAid Software
donaldb@281.com
"SURESH" <way2suresh@hotmail.com> wrote in message
news:%234d%23zw3jFHA.3256@TK2MSFTNGP12.phx.gbl...
> Dear friends,
>
> anyone can tell me which formula will help me to know which is the last
> entered cell.
>
> For example:
> My data is A1:P109
>
> so the formula should say the last entered row/cell is 109
>
> thanks in advance
>
> best regards,
> suersh tp
>
>

[Don Guillett]

Since you asked for the row number instead, use this
=MAX(IF(ISBLANK(A1:A10000),0,ROW(A1:A10000)))

--
Don Guillett
SalesAid Software
donaldb@281.com
"Don Guillett" <donaldb@281.com> wrote in message
news:ueZyUV4jFHA.4028@TK2MSFTNGP10.phx.gbl...
> try this array formula (entered with ctrl+shift+enter) for either text or
> number
>
=INDEX(A1:A65535,MAX((ISNUMBER(A1:A65535)+ISTEXT(A1:A65535))*ROW(INDIRECT("1
> :65535"))))
>
> --
> Don Guillett
> SalesAid Software
> donaldb@281.com
> "SURESH" <way2suresh@hotmail.com> wrote in message
> news:%234d%23zw3jFHA.3256@TK2MSFTNGP12.phx.gbl...
> > Dear friends,
> >
> > anyone can tell me which formula will help me to know which is the last
> > entered cell.
> >
> > For example:
> > My data is A1:P109
> >
> > so the formula should say the last entered row/cell is 109
> >
> > thanks in advance
> >
> > best regards,
> > suersh tp
> >
> >
>
>