Help create this formula:

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Help create this formula:

05-02-2020, 07:49 AM

andysvision andysvision is offline

Windows 7 64bit Help create this formula:

Office 2007

Novice

Join Date: Jan 2017

Posts: 8

Quote:

Originally Posted by Guessed

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")

WORKS PERFECT!!!!

Thank you!

Last edited by andysvision; 05-02-2020 at 11:28 AM.

Tags

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to create a simple formula	ep2002	Excel	1	09-06-2017 11:00 PM
Help to create this formula:	andysvision	Excel	7	01-05-2017 02:35 PM
How to create mileage formula	maxliv	Excel	4	08-15-2016 08:13 AM
Create formula for entire column	tdodson	Excel	2	10-27-2015 09:38 PM
Please help me create this formula...	doublejoy	Excel	1	08-22-2009 03:04 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:42 AM.