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

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 12:42 AM.