How to calculate automatic min. value inside many cells?
How to calculate automatic min. value inside many cells in the correct simple way. I do not like to put all the time If function to compare all values inside many cells.
Another issue is how to take this min. value and calculate with defined monthly quantity.
Need help.
=min(a1:a10)
Entia non sunt multiplicanda sine necessitate
Can be taken cell location where is actually min. value?
Each min. value has its defined seller, shop...which are quoted at the top of column.
use shg's formula for each column of data
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks