#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 | 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 |