Results 1 to 15 of 15

Macro to select minimum and replace value to other cell in same row

Threaded View

Osiriz Macro to select minimum and... 02-16-2012, 03:31 PM
p24leclerc Re: Macro to select minimum... 02-16-2012, 04:55 PM
tom1977 Re: Macro to select minimum... 02-16-2012, 05:01 PM
Osiriz Re: Macro to select minimum... 02-16-2012, 06:10 PM
Osiriz Re: Macro to select minimum... 02-16-2012, 06:22 PM
Osiriz Re: Macro to select minimum... 02-16-2012, 06:22 PM
tom1977 Re: Macro to select minimum... 02-16-2012, 06:28 PM
Osiriz Re: Macro to select minimum... 02-16-2012, 06:36 PM
tom1977 Re: Macro to select minimum... 02-16-2012, 06:58 PM
Osiriz Re: Macro to select minimum... 02-16-2012, 07:56 PM
p24leclerc Re: Macro to select minimum... 02-16-2012, 11:07 PM
Osiriz Re: Macro to select minimum... 02-17-2012, 10:43 AM
p24leclerc Re: Macro to select minimum... 02-17-2012, 11:35 AM
Osiriz Re: Macro to select minimum... 02-18-2012, 06:02 AM
Osiriz Re: Macro to select minimum... 02-18-2012, 06:05 AM
  1. #1
    Registered User
    Join Date
    02-16-2012
    Location
    Porto, Portugal
    MS-Off Ver
    Excel 2010
    Posts
    9

    Macro to select minimum and replace value to other cell in same row

    Hi all!

    This is my first post, so please be gentle! :D

    This is my problem:

    I want to automatically select the minimum value in a column and then replace the value on other cell on the same row. Something like this:

    Name Owned Cost
    A 10 9
    B 50 3
    C 20 5

    So, I want the macro to find the minimum on the "Cost" column (3), and then add a value (for instance 5) to the column "Owned" on the same row, so the value goes from 50 to 55.

    I have a very long list, so doing it manually takes a lot of time. I use formulas to get the minimum cell and corresponding names on the same row: =ÍNDICE(B2:B233;CORRESP(MÍNIMO(F2:F233);F2:F233;0)).
    But then I have to sum 5 to the adjacent cell manually, that's the time consuming part!

    Sorry but my Excel is in Portuguese, but if needed I think I can give the formula names in English.
    Any ideas how to get a macro for this?

    Sorry for the long text and thanks in advance!!
    Last edited by Osiriz; 02-18-2012 at 06:06 AM. Reason: Solved

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1