Thread: Help create this formula:
View Single Post
 
Old 05-02-2020, 06:29 AM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
  
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,977
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default
OK, if you are changing the Month in E2 and want the calculation in D2 then put this formula in D2
Code:
=IF(COUNTIFS(OFFSET(G1,1,MATCH(E2,H1:L1,0),21,2),B3)>0,"Yes","No")
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote