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
|