Re: $$Excel-Macros$$ Excel Formula - Huge Formula - Help to simplfy

2014-02-06 Thread Swapnil Palande
Hi Brett, Instead of studying formula, it will be easy to create alternate formula if you could provide calculation steps. Regards, Swapnil. On Fri, Jan 31, 2014 at 10:41 PM, Brett Manning brettmannin...@gmail.comwrote: On Friday, January 17, 2014 6:11:10 AM UTC, Rajan_Verma wrote: i

Re: $$Excel-Macros$$ Excel Formula - Huge Formula - Help to simplfy

2014-01-31 Thread Brett Manning
On Friday, January 17, 2014 6:11:10 AM UTC, Rajan_Verma wrote: i didnt review the formula closely ,but i think you would need some mapping kind of sutff to avoid many IF() formulas. On Fri, Dec 27, 2013 at 8:03 AM, Brett Manning brettma...@gmail.comjavascript: wrote: Hello, As

Re: $$Excel-Macros$$ Excel Formula - Huge Formula - Help to simplfy

2014-01-16 Thread rajan verma
i didnt review the formula closely ,but i think you would need some mapping kind of sutff to avoid many IF() formulas. On Fri, Dec 27, 2013 at 8:03 AM, Brett Manning brettmannin...@gmail.comwrote: Hello, As requested, please find attached example spreadsheet. The formula's concerned are

$$Excel-Macros$$ Excel Formula - Huge Formula - Help to simplfy

2013-12-24 Thread Brett Manning
Hello, I have created a spreadsheet which looks at various different worksheets in the same spreadsheet in order to return the data to one central worksheet. I have then created a pivot table of this data. My formula below contains a lot of If's and Index / Match. The formula works but I

Re: $$Excel-Macros$$ Excel Formula - Huge Formula - Help to simplfy

2013-12-24 Thread Anoop K Sharma
Well, No one will get the result by studying this formula. There will definitely be number of methods to meet your requirement but for that we need your master file along with supporting files. Please do share these with elaborating your requirement. On Tue, Dec 24, 2013 at 3:38 PM, Brett

Re: $$Excel-Macros$$ Excel Formula - Huge Formula - Help to simplfy

2013-12-24 Thread Tariq Aziz
please share the worksheet On 24 December 2013 15:08, Brett Manning brettmannin...@gmail.com wrote: Hello, I have created a spreadsheet which looks at various different worksheets in the same spreadsheet in order to return the data to one central worksheet. I have then created a pivot table