S
Sabine
Hi,
Forgiveness in advance for my English ...
In column A, dates (dtS), in B names (prN) and C numerical values (vaL),
like example below:
01/01/2008 PIERRE 3
01/01/2008 LUC 4
01/01/2008 PAUL
02/01/2008 PAUL 7
02/01/2008 PIERRE
03/01/2008 PAUL 8
03/01/2008 PIERRE
05/01/2008 LUC 8
05/01/2008 PIERRE 1
I would like a formula in a single cell (matrix) which I counted the number
of lines having the same date in column A on the same line
names research "Pierre or Luc" in column B and numerical value in column C.
In my example, the formula would result in 2 because on line 1 and 2, 8 and
9, we find the same date for Pierre or Luc in column A, Pierre or Luc in
column B, and a numerical value in front in column C of Pierre and Luc.
For conditional formatting, it would be something like:
=(NB.SI(dtS;$A2)>1)*(($B2="pierre")+($B2="luc"))*($C2<>"")
I tried this, but that does not give the expected results:
{=SOMME((NB.SI(dtS;dtS)>1)*((prN="pierre")+(prN="luc"))*(vaL<>""))}
;-(
Thanks in advance for your help,
Sabine
Forgiveness in advance for my English ...
In column A, dates (dtS), in B names (prN) and C numerical values (vaL),
like example below:
01/01/2008 PIERRE 3
01/01/2008 LUC 4
01/01/2008 PAUL
02/01/2008 PAUL 7
02/01/2008 PIERRE
03/01/2008 PAUL 8
03/01/2008 PIERRE
05/01/2008 LUC 8
05/01/2008 PIERRE 1
I would like a formula in a single cell (matrix) which I counted the number
of lines having the same date in column A on the same line
names research "Pierre or Luc" in column B and numerical value in column C.
In my example, the formula would result in 2 because on line 1 and 2, 8 and
9, we find the same date for Pierre or Luc in column A, Pierre or Luc in
column B, and a numerical value in front in column C of Pierre and Luc.
For conditional formatting, it would be something like:
=(NB.SI(dtS;$A2)>1)*(($B2="pierre")+($B2="luc"))*($C2<>"")
I tried this, but that does not give the expected results:
{=SOMME((NB.SI(dtS;dtS)>1)*((prN="pierre")+(prN="luc"))*(vaL<>""))}
;-(
Thanks in advance for your help,
Sabine