PDA

View Full Version : Solved: displaying a value



Ger
02-26-2008, 07:38 AM
I'm using Excell 2003 dutch version.

How can I display the value in row 2 and 37 of page 1 on page 2 if the name is the name in column B and the value in the range D:AE is "VL" (see the example).

Ger

Bob Phillips
02-26-2008, 09:17 AM
Do you mean

=IF(AND(jaarplan!$B4=$B6,COUNTIF(jaarplan!$D4:$AE4,"VL")>1),2,"")

and

=IF(AND(jaarplan!$B4=$B6,COUNTIF(jaarplan!$D38:$AE38,"VL")>1),37,"")

Ger
02-26-2008, 01:27 PM
No,
were i'm looking for is the date in row 2 and 37 when there is the value VL by the listed names.

example

if there is a name Smith abd this person has the value vl on 30-12 and 6-6 I want on the second page by the name Smith the date 30-12 and 6-6.

Ger

Ger
02-26-2008, 01:36 PM
"jaarplan" is divided in 2 parts. The first half year (row 2 to 27) and the last half of the year (row 37 to 62). I want ot know on which date a person has the value "VL". This date must be listed on "vta ovz".

See the example.

Ger