Hi, does anyone know if these function arguments work in Excel 2010 as I cannot seem to get the desired result when applying them. I have currently got:
=MIN(IF(G2:G2320=G2323,K2:K2320)) as I try to find the minimum value in the K column of values in the range of G2:G2320 that have the same value of cell G2323. This returns the good old #VALUE! display though.
Any assistance would be greatly appreciated.
Thanks.
That's an array formula and needs to be entered using CTRL+SHIFT+ENTER.
If posting code please use code tags, see here.
hi plannerg, did you press CTRL + SHIFT + ENTER? press F2 to go inside the cell & press those keys. upload the file if this doesn't work for you. to upload, press "Go Advanced" beside the "Post Quick Reply" button & click on the paperclip icon
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
post deleted
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