#1




Looking for the correct formula
Hi all I am working on a project that has 15k lines. I need to identify the lowest RVU of each section (some sections only have 2 lines, others may have more). I have tried using this formula: =IF($B6<MAX(IF($A$2:$A$30=$A3,$B$2:$B$30)),"","Y") Unfortunately, it doesn’t work. I am attaching an example of my desired outcome. Any and all assistance would be greatly appreciated. Thanks 
#2




Correction...the formula I used is:
=IF($B3<MAX(IF($A$2:$A$30=$A3,$B$2:$B$30)),"","Y") 
#3




Is this close?

#4




Hi Proud
Thanks for the assiatance, however, I need to keep the list intact, meaning I need all of the data to remain, just identifying the lowest RVU's in a particular grouping. For instance, group 1111 has 3 lines. Lines 2 and 4 should have a 'Y' in the reduction column because out of the 3 lines, those 2 are the lowest in the group. I hope I was a bit more clear as I can understand the initial post could have been misunderstood. Thanks 
#5




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




Hi jeffreybrown
Both worked perfectly. Thank you very much for your help, it is much appreciated. 
#7




You are very welcome and thanks for the feedback.

Thread Tools  
Display Modes  

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  09132016 08:59 PM 
Creating formula based on if data is correct in cell  MattMurdock  Excel  1  08062012 03:11 AM 
Can't get formula to recognize correct data  cklassen  Excel  1  05192012 01:25 AM 
Which .pst is the correct .pst  dbsoccer  Outlook  1  04082012 12:12 PM 
Crossreference together with Mathtype formula is not working correct  Santa_Clause  Word  2  02022010 04:37 AM 