Prev: Refresh of links in shared file.
Next: How do I save the same document in 2 different files
From: Edward on 7 Apr 2010 16:54
Hi everybody,
I have an excel worksheet
A B
John XY
John X
John Y
John G
Ed X
Ed Y
Tod XY
....
GHA

in each records I have a name in column A and some value in column C , I
want to write a fomula ( in column D ) to find every record ( an individual )
that doesn't have at least one XY in "column C" , emplyees are sorted by
thier names and there are variable number of reocords for each employee. In
this example Ed should be flagged because it doesn't have at least one XY in
column C.
Any suggestions?
--
Best regards,
Edward
From: Jacob Skaria on 8 Apr 2010 01:04
Hi Edward

Try the below formula in cell D1 and copy down as required

=IF(SUMPRODUCT(($A$1:$A$100=A1)*($B$1:$B$100="xy"))=0,"Flag","")

Incase you are using XL 2007 check out help on COUNTIFS()

--
Jacob (MVP - Excel)


"Edward" wrote:

> Hi everybody,
> I have an excel worksheet
> A B
> John XY
> John X
> John Y
> John G
> Ed X
> Ed Y
> Tod XY
> ...
> GHA
>
> in each records I have a name in column A and some value in column C , I
> want to write a fomula ( in column D ) to find every record ( an individual )
> that doesn't have at least one XY in "column C" , emplyees are sorted by
> thier names and there are variable number of reocords for each employee. In
> this example Ed should be flagged because it doesn't have at least one XY in
> column C.
> Any suggestions?
> --
> Best regards,
> Edward
 | 
Pages: 1
Prev: Refresh of links in shared file.
Next: How do I save the same document in 2 different files