Microsoft Office Forums Looking for the correct formula

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-09-2019, 12:14 PM
wheddingsjr wheddingsjr is offline Looking for the correct formula Windows 7 64bit Looking for the correct formula Office 2016
Advanced Beginner
Looking for the correct formula
 
Join Date: Mar 2017
Posts: 45
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, 3 views)
Reply With Quote
  #2  
Old 09-09-2019, 12:23 PM
wheddingsjr wheddingsjr is offline Looking for the correct formula Windows 7 64bit Looking for the correct formula Office 2016
Advanced Beginner
Looking for the correct formula
 
Join Date: Mar 2017
Posts: 45
wheddingsjr is on a distinguished road
Default

Correction...the formula I used is:


=IF($B3<MAX(IF($A$2:$A$30=$A3,$B$2:$B$30)),"","Y")
Reply With Quote
  #3  
Old 09-09-2019, 12:51 PM
ProudLiberal's Avatar
ProudLiberal ProudLiberal is offline Looking for the correct formula Windows 7 64bit Looking for the correct formula Office 2010 64bit
Novice
 
Join Date: Jun 2017
Posts: 16
ProudLiberal is on a distinguished road
Default

Is this close?
Attached Files
File Type: xlsx Sample Data.xlsx (17.2 KB, 4 views)
Reply With Quote
  #4  
Old 09-09-2019, 01:13 PM
wheddingsjr wheddingsjr is offline Looking for the correct formula Windows 7 64bit Looking for the correct formula Office 2016
Advanced Beginner
Looking for the correct formula
 
Join Date: Mar 2017
Posts: 45
wheddingsjr is on a distinguished road
Default

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
Reply With Quote
  #5  
Old 09-09-2019, 04:24 PM
jeffreybrown jeffreybrown is offline Looking for the correct formula Windows 10 Looking for the correct formula Office 2016
Expert
 
Join Date: Apr 2016
Posts: 549
jeffreybrown will become famous soon enoughjeffreybrown will become famous soon enough
Default

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","")
Reply With Quote
  #6  
Old 09-10-2019, 03:31 AM
wheddingsjr wheddingsjr is offline Looking for the correct formula Windows 7 64bit Looking for the correct formula Office 2016
Advanced Beginner
Looking for the correct formula
 
Join Date: Mar 2017
Posts: 45
wheddingsjr is on a distinguished road
Default

Hi jeffreybrown

Both worked perfectly. Thank you very much for your help, it is much appreciated.
Reply With Quote
  #7  
Old 09-10-2019, 04:10 AM
jeffreybrown jeffreybrown is offline Looking for the correct formula Windows 10 Looking for the correct formula Office 2016
Expert
 
Join Date: Apr 2016
Posts: 549
jeffreybrown will become famous soon enoughjeffreybrown will become famous soon enough
Default

You are very welcome and thanks for the feedback.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Looking for the correct formula 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
Looking for the correct formula Creating formula based on if data is correct in cell MattMurdock Excel 1 08-06-2012 03:11 AM
Looking for the correct formula 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
Looking for the correct formula Cross-reference together with Mathtype formula is not working correct Santa_Clause Word 2 02-02-2010 04:37 AM


All times are GMT -7. The time now is 01:51 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft