Dear Experts,
Is it possible to make a pivot table basis on two workbooks, while
heading are same of both workbooks? partial data or complete data may be
differ. or complete data may be same.
Regards,
Waseem Saifi
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
Yes, it is possible via Multipal consolidate ranges
Just press Alt+D+P then select Multipal consolidate ranges
.
Enjoy
Team XLS
On Sat, Aug 24, 2013 at 12:36 PM, Waseem Saifi waseemsa...@gmail.comwrote:
Dear Experts,
Is it possible to make a pivot table basis
Thanx
[?]
On Sat, Aug 24, 2013 at 2:09 PM, xlstime xlst...@gmail.com wrote:
Yes, it is possible via Multipal consolidate ranges
Just press Alt+D+P then select Multipal consolidate ranges
.
Enjoy
Team XLS
On Sat, Aug 24, 2013 at 12:36 PM, Waseem Saifi
Dear Experts,
I have a query related to Pivot Table. Pls refer to attachment.
--
Regards,
Rakesh Kumar Sharma
Contact: +91-9971024741
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
Dear Rakesh,
please see attachment.
in case of place months in ascending order. you have to do it manually.
right click on any month and move it to left, right, to beginning or to end.
Regards,
Waseem Saifi
On 7/11/13, Rakesh Kumar Sharma rakeshks@gmail.com wrote:
Dear Experts,
I have a
use this formula in c2 =DATE(YEAR(B2),MONTH(B2),1)
and fill it down then try to sort the columns of pivot table
On Thu, Jul 11, 2013 at 6:36 PM, Waseem Saifi waseemsa...@gmail.com wrote:
Dear Rakesh,
please see attachment.
in case of place months in ascending order. you have to do it