Search results

Hello to all, I'm using an INDIRECT formule to refer to a cell reference in another tab. When the name of the tab is 1 word (example: table1), there is no problem at all. I get the specific cell content from the tab with name table1. The problem arises when the name consists of more then one...

Hi Faseeh, This works great! I'm sure I didn't manage to make this. Thank you very much! Brems

Hi Faseeh, The solution you offer seems fine to me. VBA isn't necessary at this stage. For the future, I may be looking back in the way I need to organise my data in order to work with it more easily. Thanks in advance.

Hi Faseeh, It changes from time to time. Not daily regards

Hi, On a daily basis I'm putting in some data in an excel sheet. I've made an example file to clarify... We have 10 categories For each category there's an amount of emails that comes in daily: IN For each category there's an amout of emails that gets processed daily: OUT And of course...

Hi Hui, Works perfect! Thanks a lot. Learned something from it. ;-)

Hi Hui, Thanks for your welcome. I posted the sample sheet on google docs and have set the properties to shared. https://docs.google.com/spreadsheet/ccc?key=0AkUCb6qKhWrZdEVhRnJ0d1NzcHN3aEd5Y3JjYzl3Tmc

Hi, I want to calculate the weighted average pricing of each category and therefore I use SumProduct but instead of selecting the cells for each category I want to use SumIfs together with SumProduct to do it for me. It would be more correct and much quicker. Below is an example of the data...