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!!
Bookmarks