LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 29th 04, 09:39 AM
Posts: n/a
Default Recalculation takes too long - help!!!!

Hi Deepak

the fact that you've used Australian states in your example gave your
(probable) location away

if your data can be rearranged as follows
St, TerId, TerName, shpcod, col4, mnth, custId, product
NSW, N0, Name1, ABC, 01, 2004-09, 27974955, A
NSW, N0, Name1, ABC, 01, 2004-09, 27974955, B

either manually or via the use of code you would make life much easier and
be able to avail yourself of all the features of excel lists (data form /
filtering / subtotals) and pivot tables.

is this a possiblity?

PS which side of the country are you on?

"agarwaldvk" wrote in message


No, I tried to use the Pivot Table but I don't think that in this
instance, its going to be of any help (unless there is somethere here
that I am not seeing).

The reason I say this is this :-

The raw data is in 9 columns - 2 of these contain the product
decription (in other words, their name). The 75 odd products that I
mention are the unique values of these product names across the full
range (35000 rows and these 2 columns). I am not interested in the
count or sum by these column headings (which I suppose Pivot Table
works with) - more so I am interested in the count of the unique values
of each of the product names.

Having said this, the arrangement of the raw data would look something
like so :-

St, TerId, TerName, shpcod, col4, mnth, custId, prod1,

NSW, N0, Name1, ABC, 01, 2004-09, 27974955, A, B
NSW, N1, Name2, BCD, 02, 2004-08, 27974956, C, B
VIC, N0, Name1, ABC, 02, 2004-09, 27974951, A, D
NSW, N0, Name3, PQR, 05, 2004-08, 27974952, E, B
WA, W0, Name4, KLM, 01, 2004-07, 27974952, A, D
QLD, Q0, Name2, ART, 04, 2004-07, 27974959, C, F
VIC, V0, Name7, NHY, 02, 2004-09, 27974954, E, B

Now what I am after is the count of product 'A' by month by state by
outlet code. Similarly, the count of product 'B' by month by state by
outlet code and so on!

Hopefully, this is clarify matters a trifle more! If Pivot Table can do
this, I am more than willing to give it a go!

Best regards

Deepak Agarwal
(And by the way how did you guess, I am an Aussie? Good to know you

agarwaldvk's Profile:
View this thread:

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Find nth instance of a character in a string Francis Hayes (The Excel Addict) Excel Discussion (Misc queries) 7 January 21st 05 04:44 PM
Excel 2003 - long closing time when have many add-ins installed David Welch Excel Discussion (Misc queries) 0 January 11th 05 03:38 PM
Calculating Time in XP takes forever Dan Excel Discussion (Misc queries) 3 December 22nd 04 11:06 PM
How long have macros been available in Excel? warner Excel Discussion (Misc queries) 3 December 8th 04 03:28 AM
Long Text Entry jaspikes Excel Discussion (Misc queries) 1 December 3rd 04 11:38 PM

All times are GMT +1. The time now is 05:17 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017