What combo of figures = X?
Tony,
I was interested to find a solution for the same problem that you posed, and was disappointed when I found, like you, that Peo's solution wasn't working. After doing some intensive searching on the web I finally found what to do. Instead of #VALUE! in D2, it should be =SUMPRODUCT(A2:A7,B2:B7). Give it a try, and hopefully you'll get the result that you're after. BTW, I tried the Harlan Grove macro and it worked brilliantly (after a little help from someone else in the newsgroup!!). HTH Regards, John hi, thanks for replying. I am trying Peo's solution, but it is not working. I follow all instructions to the letter and use his example data, but the "change" in column B does not occur. One thing is that I get an error if I just enter "#VALUE!" in D2, it says it must be a forumula...so I have been entering "=#VALUE!"...other than that, I am doing just what the instructions say, and no luck... |
All times are GMT +1. The time now is 10:45 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com