Looking for the correct formula

[wheddingsjr]

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