|
|
You're welcome. Thanks for the feedback!
Biff
"Sam via OfficeKB.com" wrote in message
...
Hi Biff,
Thank you very much for both alternatives - great! Very much appreciated.
Biff wrote:
Assume that column 7 of ACTUAL is in column G, G2:Gn
FORECAST is in column H, H2:Hn
=IF(OR(G2="",H2=""),"",IF(ROUND(H2,0)=G2,"Yes"," "))
Copy down to enough rows to allow for future addition of data in the named
ranges.
Now, here's that same formula using the range names:
=IF(OR(INDEX(Actual,ROW(1:1),7)="",INDEX(Forecas t,ROW(1:1))=""),"",IF(ROUND(INDEX(Forecast,ROW(1:1 )),0)=INDEX(Actual,ROW(1:1),7),"Yes",""))
Cheers,
Sam
--
Message posted via http://www.officekb.com
|