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
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
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
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
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
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