Search results

alrighty, email shortly!

Hi Narayan, I have completed the majority of the variable boxes. I have placed all of the pivot fields into the table and they are pulling the stats accordingly. I just do not know how to adjust the formula correct to pull the stats from the table for the following variable boxes: Non EUR...

ah alrighty - will be working on this throughout the day. Will upload the workbook later tonight. Many many thanks again for your insight. Chuckles

heya, think I answered my own pivot table question (at least part of it) : obtaining the value's isn't an issue if I also add in trading group L2 / L3 into the columns - they are still all obtained correctly. Not sure about the ones in which multiple need to be either grouped / added however...

Hi Narayank991, Many thanks for your help so far! I'll definitely have to pick your brain a bit after I study the end result !!! ex: I never knew about the CHAR function / that you could make a drop down cell like you did in Configuration!B2 =) In regards to your question regarding width...

Hey guys, I recreated my account (forgot my password... was sent to other email addy which I don't have access too at the moment!!). Here is a link to my dropbox files with the excel sheets / powerpoint slides. https://www.dropbox.com/sh/9h66pbtzohqxwjw/Jb89FQL1ud I believe the easier...