half)
The formulas are array, so they're entered with Shift+Ctrl+Enter, which
automatically puts in the curley brackets and makes them work properly.
Regards - Dave.
> Subject: RE: $$Excel-Macros$$ Need help with a formula
> Date: Thu, 19 Aug 2010 21:40:38 -0400
> From: rebecca.mat
Thanks, Michael!
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On
Behalf Of Michael Hayes
Sent: Thursday, August 19, 2010 2:37 PM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Need help with a formula
Beckie or is it Becky
> ________
>
> From: excel-macros@googlegroups.com
> [mailto:excel-mac...@googlegroups.com] On Behalf Of Dave Bonallack
> Sent: Thursday, August 19, 2010 12:27 AM
> To: excel-macros@googlegroups.com
> Subject: RE: $$Excel-Macros$$ Need help with a
-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Need help with a formula
Hi Becky,
If XL has put NA in a cell, you must already have a formula there.
You'll need to send a sample workbook so we can see get the whole
picture.
Regards - Dave.
> Date: Wed, 18 Aug 2010 12:15:30 -0700
&
ack wrote:
> Hi Becky,
>
> If XL has put NA in a cell, you must already have a formula there. You'll
> need to send a sample workbook so we can see get the whole picture.
>
> Regards - Dave.
>
> > Date: Wed, 18 Aug 2010 12:15:30 -0700
> > Subject: $$Excel-Macros$$
Hi Becky,
If XL has put NA in a cell, you must already have a formula there. You'll need
to send a sample workbook so we can see get the whole picture.
Regards - Dave.
> Date: Wed, 18 Aug 2010 12:15:30 -0700
> Subject: $$Excel-Macros$$ Need help with a formula
> From
I am trying to create a formula:
For a given range which most values are "NA", I want the cell to
return the value of the cell that is above the first cell that
contains value <0 (not NA).
--
--
Some important links f
