Looking for the correct formula

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

09-09-2019, 12:23 PM

wheddingsjr wheddingsjr is offline

Windows 7 64bit Looking for the correct formula

Office 2016

Advanced Beginner

Join Date: Mar 2017

Posts: 76

Correction...the formula I used is:

=IF($B3<MAX(IF($A$2:$A$30=$A3,$B$2:$B$30)),"","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 11:45 AM.