Prev: Excell Spreedsheets
Next: Segrigation of different datas from one colum
From: Ziggy on 25 Mar 2010 13:04
On Mar 24, 9:31 pm, "Ashish Mathur" <mathurash...(a)hotmail.com> wrote:

Or this



=INDIRECT("N"&MAX(IF($N$80:$N$122<>0,ROW($N$80:$N$122))))

Substitute the "N" for your column and also adjust the ranges.
From: Ziggy on 25 Mar 2010 15:17
On Mar 25, 11:04 am, Ziggy <ziggy...(a)xmission.com> wrote:
> On Mar 24, 9:31 pm, "Ashish Mathur" <mathurash...(a)hotmail.com> wrote:
>
> Or this
>
> =INDIRECT("N"&MAX(IF($N$80:$N$122<>0,ROW($N$80:$N$122))))
>
> Substitute the "N" for your column and also adjust the ranges.

I should have stated this is an ARRAY formula and needs the Cntrl-Alt-
Enter
From: Ziggy on 26 Mar 2010 11:05
On Mar 25, 1:17 pm, Ziggy <ziggy...(a)xmission.com> wrote:
> On Mar 25, 11:04 am, Ziggy <ziggy...(a)xmission.com> wrote:
>
> > On Mar 24, 9:31 pm, "Ashish Mathur" <mathurash...(a)hotmail.com> wrote:
>
> > Or this
>
> > =INDIRECT("N"&MAX(IF($N$80:$N$122<>0,ROW($N$80:$N$122))))
>
> > Substitute the "N" for your column and also adjust the ranges.
>
> I should have stated this is an ARRAY formula and needs the Cntrl-Alt-
> Enter

Should be Ctrl-Shift-Enter.. sorru bout that
First  |  Prev  | 
Pages: 1 2
Prev: Excell Spreedsheets
Next: Segrigation of different datas from one colum