Morning Zac,
I would not suggest carrying out a process like this for such a large
data set in Excel.
My suggestion would be to perform your pivot table in Access and
report through Excel.
The only other alternative is to consolidate your data before pivoting
it and even this has limitations in
Hi,
I do not even see a way to get all of the data into a single work
sheet. V7 is 1m rows, yes? Given that you are not going to be able to
bring it all in, how many groups of data will you have? Can you bring
your data in as you want to do sub-totals, groups? If you have a lot
of groups and sub-t
Hi All,
Pls help me to modify the code with the following request
*1. Active cell - I should accept the active cell reference from the user n
the same varible will be very ever necessary.*
*ActiveCell*.FormulaR1C1 = _
"=VLOOKUP(RC[-6],'[SAMPLE
file.xls]PMSRegisterEC.rpt'!R11C2:R91C11,10,
Hi Zahid,
Upgrade to Excel 2007, this wil provide you to analyze 1 million rows, and
16000 columns.
Else user SQL Server 2008 Analysis server.
Thanks
On Sun, Jun 20, 2010 at 12:28 PM, Chaudhry Zahid Ali <
chaudhry.zahid@gmail.com> wrote:
> Dear All,
>
> I have to apply pivot on a data that
Hi Sumit,
is that attachment file can you tell to password of sheet2 please.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join ou
Dear All,
I have to apply pivot on a data that reaches approx 1.5m rows and is spread
on 15 columns. If I divide the data in two parts of 0.8m rows each, I can
not do a complete analysis. Any suggestions??
Regards,
ZAC
--
Hi Fabio,
Can you explain about your below formul, i didn't understand how is it
working or if you have a document about that can you share with us..
SUMPRODUCT(VALUE(MID(A5;{3;4;5;6;7;8;9};1));{8;7;6;5;4;3;2})
Thank you.
--
-