Looking for the correct formula

		Microsoft Office Forums > Microsoft Excel > Excel
Looking for the correct formula

09-09-2019, 04:24 PM

jeffreybrown jeffreybrown is offline

Windows 10 Looking for the correct formula

Office 2016

Expert

Join Date: Apr 2016

Posts: 673

Give this a try...

=IF(SUMPRODUCT(($A$2:$A$30=A2)*(B2<$B$2:$B$30))+1> 1,"Y","")

or

=IF(COUNTIFS($A$2:$A$30,A2, $B$2:$B$30,">="&B2)>1,"Y","")

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula	innkeeper9	Excel	2	09-13-2016 08:59 PM
Creating formula based on if data is correct in cell	MattMurdock	Excel	1	08-06-2012 03:11 AM
Can't get formula to recognize correct data	cklassen	Excel	1	05-19-2012 01:25 AM
Which .pst is the correct .pst	dbsoccer	Outlook	1	04-08-2012 12:12 PM
Cross-reference together with Mathtype formula is not working correct	Santa_Clause	Word	2	02-02-2010 04:37 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:28 PM.