Prev: Vlookup based on a unique "Text" occur
Next: Having a macro/function available in new spreadsheets
From: Mr. Low on 6 Apr 2010 10:28
Hi Max,

Your formula works.

Thanks for your help.

Low


"Max" wrote:

> Try this in C2, which will involve both the invoice number and line code:
> =IF(SUMPRODUCT(($A$2:$A$15=A2)*($B$2:$B$15=18))>0,"A","B")
> Copy down to return desired results. Success? hit YES below
> --
> Max
> Singapore
> ---
> "Mr. Low" wrote:
> > This only select the row with "18", not the the rest of the line with the
> > similar invoice number, eg, I need to select row 12 to row 15 as "A" when
> > only row 14 has the code "18". Any other solution ?
>
From: Max on 6 Apr 2010 18:55
You're welcome, Low. Glad to hear.
--
Max
Singapore

"Mr. Low" <MrLow(a)discussions.microsoft.com> wrote in message
news:C3DC3D40-46E3-471E-81A9-E3943065F759(a)microsoft.com...
> Hi Max,
> Your formula works
> Thanks for your help
> Low


First  |  Prev  | 
Pages: 1 2
Prev: Vlookup based on a unique "Text" occur
Next: Having a macro/function available in new spreadsheets