LinkBack URL
About LinkBacks
Hi,
Can we have total min values by row. in the attached sample file "D9" value should come in "C9" with having D column and same "E9".
pls help.
Thanks,
suresh
Hi,
Can we have total min values by row. in the attached sample file "D9" value should come in "C9" with having D column and same "E9".
pls help.
Thanks,
suresh
Hi Suresh,
If u want the minimum value from a column, use the SUBTOTAL function.
For column C, useIs this what you need?Formula:
Please Login or Register to view this content.
If my assistance has helped, there is a reputation icon * on the left hand corner below the post - you can show your appreciation to the user who has helped in resolving your requirement.
If your requirement has been solved please mark your thread as Solved.
In the menu bar above the very first post, select Thread Tools, then select "Mark this thread as Solved".
Kindly use [FORMULA] or [CODE] tags when posting your code.
Regards,
Sarang
Dear Suresh,
please check attached files for "C9"
i hope meet with your expectations.
regards
Thank you Dhona, do we have formla "E9"
Dear Suresh,
same methode basically..
please check.
=SUMPRODUCT((((B2:B8-C2:C8)*(B2:B8-C2:C8>0)))*(((B2:B8-C2:C8)*(B2:B8-C2:C8>0))<E2:E8))+SUMPRODUCT((E2:E8)*(((B2:B8-C2:C8)*(B2:B8-C2:C8>0))>E2:E8))
Regards,
JRD
Why not just use the SMALL() function?
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
Can you pls help how us small function with this example.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks