View Single Post
 
Old 09-09-2019, 12:14 PM
wheddingsjr wheddingsjr is offline Windows 7 64bit Office 2016
Advanced Beginner
 
Join Date: Mar 2017
Posts: 76
wheddingsjr is on a distinguished road
Default 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
Attached Files
File Type: xlsx Sample Data.xlsx (18.0 KB, 7 views)
Reply With Quote