Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-13-2017, 10:57 AM
wheddingsjr wheddingsjr is offline Using the ifmin function Windows 7 64bit Using the ifmin function Office 2016
Advanced Beginner
Using the ifmin function
 
Join Date: Mar 2017
Posts: 76
wheddingsjr is on a distinguished road
Default Using the ifmin function

Hi all



I am working on a project where I have a list with multiple columns where I want to use a range of values in one column to determine the minimum in another column. It doesnt appear that I am able able to paste an example so adding an attached sample which shows the desired results. In this example, I want to use the lowest number in the "RVU" column for each set of data in the "COMBO" column and add the corresponding number in the "AMOUNT" column to the "SAVINGS" column (I manually added the numbers in the "SAVINGS" column to show what I am trying to do). The spread sheet has 106k lines so I can't manually do them all.

Thanks in advance
Attached Files
File Type: xlsx Example.xlsx (10.7 KB, 15 views)
Reply With Quote
  #2  
Old 03-13-2017, 12:39 PM
xor xor is offline Using the ifmin function Windows 10 Using the ifmin function Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

Will the lowest RVU number always be in the last row within a certain COMBO-set?
Reply With Quote
  #3  
Old 03-13-2017, 12:54 PM
wheddingsjr wheddingsjr is offline Using the ifmin function Windows 7 64bit Using the ifmin function Office 2016
Advanced Beginner
Using the ifmin function
 
Join Date: Mar 2017
Posts: 76
wheddingsjr is on a distinguished road
Default

Hi xor

yes it will. I sorted it so that the lowest RVU will always be the last one within each combo set. Also, before the question gets asked, the lowest RVU does not always produce the lowest "AMOUNT" so regardless of the "AMOUNT" the lowest RVU is still desired.
Reply With Quote
  #4  
Old 03-13-2017, 01:58 PM
xor xor is offline Using the ifmin function Windows 10 Using the ifmin function Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

Take a look at the attached.
Attached Files
File Type: xlsx IfMin.xlsx (17.8 KB, 14 views)
Reply With Quote
  #5  
Old 03-20-2017, 05:39 AM
wheddingsjr wheddingsjr is offline Using the ifmin function Windows 7 64bit Using the ifmin function Office 2016
Advanced Beginner
Using the ifmin function
 
Join Date: Mar 2017
Posts: 76
wheddingsjr is on a distinguished road
Default

Thanks XOR, it worked perfectly. I appreciate the help.
Reply With Quote
  #6  
Old 03-20-2017, 07:16 AM
xor xor is offline Using the ifmin function Windows 10 Using the ifmin function Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

Thanks for your response.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Using the ifmin function Restrict Editing function disable insert textbox function IanM_01 Word 5 11-21-2015 02:29 AM
IF Function Azleenda Excel 2 11-10-2015 10:06 PM
Using the ifmin function #REF! Error in calling VBA function disappears when function is copied lcaretto Excel Programming 2 05-26-2014 07:19 PM
Creating a graph for Future Value function (FV function) bmoody Excel 2 11-06-2013 10:52 AM
Using the ifmin function Sum Function teza2k06 Excel 3 02-06-2013 08:29 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:51 PM.


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