Filling in a chart from a list
I know that a pivot table would be ideal. The problem is that I have
data on the chart(targets, etc) that do not come from the list. So what I am trying to do is something like a sum of vlookups. If this cell has this value, add its value from another cell in the same row to the sum of the others with he same value. I would do that for each cell in the chart. is this possible? Thanks |
All times are GMT +1. The time now is 09:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com