View Full Version : Solved: displaying a value
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,"")
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
"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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.