Prev: Rules for locking controls
Next: Simple Consolidation of Worksheets
From: Sky on 2 Apr 2010 05:54
Hi,

I had a huge file of aroiund 10 000 line.
This 10 000 line only consist of 500 items.
I wish to have an analyise a information.
Example
in the file it have items, order date, recept date and qty.
Item A order 3 time on 1 Jan but recept 1 time on 1 Feb and 2 time on 15 Feb.
Item A order 2 time on 1 Feb but recept i time on 1 Mar and 1 time on 15 Mar
etc for Item B......
Ans
Item A 2 time take 30 days and 3 time 45 days.
The numbers of days can be range 25 to 30 act as 30 and 40 to 50 can act as
45.
etc for Item B .......

From: Bob Phillips on 2 Apr 2010 06:11
Have you tried a pivot table?

--

HTH

Bob

"Sky" <skyong_1976(a)yahoo.com.sg> wrote in message
news:FABD62A9-3A9B-4117-883C-D9B8175B478D(a)microsoft.com...
> Hi,
>
> I had a huge file of aroiund 10 000 line.
> This 10 000 line only consist of 500 items.
> I wish to have an analyise a information.
> Example
> in the file it have items, order date, recept date and qty.
> Item A order 3 time on 1 Jan but recept 1 time on 1 Feb and 2 time on 15
> Feb.
> Item A order 2 time on 1 Feb but recept i time on 1 Mar and 1 time on 15
> Mar
> etc for Item B......
> Ans
> Item A 2 time take 30 days and 3 time 45 days.
> The numbers of days can be range 25 to 30 act as 30 and 40 to 50 can act
> as
> 45.
> etc for Item B .......
>


From: Sky on 3 Apr 2010 09:56
Hi Bob,

Yes, but Thru out 12 month there will be a lot of transaction.
I need to compare the recept for every transaction.
Do you have any idea?


"Bob Phillips" wrote:

> Have you tried a pivot table?
>
> --
>
> HTH
>
> Bob
>
> "Sky" <skyong_1976(a)yahoo.com.sg> wrote in message
> news:FABD62A9-3A9B-4117-883C-D9B8175B478D(a)microsoft.com...
> > Hi,
> >
> > I had a huge file of aroiund 10 000 line.
> > This 10 000 line only consist of 500 items.
> > I wish to have an analyise a information.
> > Example
> > in the file it have items, order date, recept date and qty.
> > Item A order 3 time on 1 Jan but recept 1 time on 1 Feb and 2 time on 15
> > Feb.
> > Item A order 2 time on 1 Feb but recept i time on 1 Mar and 1 time on 15
> > Mar
> > etc for Item B......
> > Ans
> > Item A 2 time take 30 days and 3 time 45 days.
> > The numbers of days can be range 25 to 30 act as 30 and 40 to 50 can act
> > as
> > 45.
> > etc for Item B .......
> >
>
>
> .
>
From: Bob Phillips on 3 Apr 2010 19:18
Sorry, I don't see what impact that has on whether you use a pivot table or
not. I was suggesting a pivot table because that will quickly aggregate all
of the 10000 lines into the 500 items. If you have 500 items that you have
to compare you will need to eyeball them all whether it is in a pivot table
or some other presentation means.

--

HTH

Bob

"Sky" <skyong_1976(a)yahoo.com.sg> wrote in message
news:7899BFD8-9327-4466-BF49-2957A466A5AD(a)microsoft.com...
> Hi Bob,
>
> Yes, but Thru out 12 month there will be a lot of transaction.
> I need to compare the recept for every transaction.
> Do you have any idea?
>
>
> "Bob Phillips" wrote:
>
>> Have you tried a pivot table?
>>
>> --
>>
>> HTH
>>
>> Bob
>>
>> "Sky" <skyong_1976(a)yahoo.com.sg> wrote in message
>> news:FABD62A9-3A9B-4117-883C-D9B8175B478D(a)microsoft.com...
>> > Hi,
>> >
>> > I had a huge file of aroiund 10 000 line.
>> > This 10 000 line only consist of 500 items.
>> > I wish to have an analyise a information.
>> > Example
>> > in the file it have items, order date, recept date and qty.
>> > Item A order 3 time on 1 Jan but recept 1 time on 1 Feb and 2 time on
>> > 15
>> > Feb.
>> > Item A order 2 time on 1 Feb but recept i time on 1 Mar and 1 time on
>> > 15
>> > Mar
>> > etc for Item B......
>> > Ans
>> > Item A 2 time take 30 days and 3 time 45 days.
>> > The numbers of days can be range 25 to 30 act as 30 and 40 to 50 can
>> > act
>> > as
>> > 45.
>> > etc for Item B .......
>> >
>>
>>
>> .
>>


From: Sky on 4 Apr 2010 09:04
Hi Bob,

Could you provide me your email address so that I could show you

"Bob Phillips" wrote:

> Sorry, I don't see what impact that has on whether you use a pivot table or
> not. I was suggesting a pivot table because that will quickly aggregate all
> of the 10000 lines into the 500 items. If you have 500 items that you have
> to compare you will need to eyeball them all whether it is in a pivot table
> or some other presentation means.
>
> --
>
> HTH
>
> Bob
>
> "Sky" <skyong_1976(a)yahoo.com.sg> wrote in message
> news:7899BFD8-9327-4466-BF49-2957A466A5AD(a)microsoft.com...
> > Hi Bob,
> >
> > Yes, but Thru out 12 month there will be a lot of transaction.
> > I need to compare the recept for every transaction.
> > Do you have any idea?
> >
> >
> > "Bob Phillips" wrote:
> >
> >> Have you tried a pivot table?
> >>
> >> --
> >>
> >> HTH
> >>
> >> Bob
> >>
> >> "Sky" <skyong_1976(a)yahoo.com.sg> wrote in message
> >> news:FABD62A9-3A9B-4117-883C-D9B8175B478D(a)microsoft.com...
> >> > Hi,
> >> >
> >> > I had a huge file of aroiund 10 000 line.
> >> > This 10 000 line only consist of 500 items.
> >> > I wish to have an analyise a information.
> >> > Example
> >> > in the file it have items, order date, recept date and qty.
> >> > Item A order 3 time on 1 Jan but recept 1 time on 1 Feb and 2 time on
> >> > 15
> >> > Feb.
> >> > Item A order 2 time on 1 Feb but recept i time on 1 Mar and 1 time on
> >> > 15
> >> > Mar
> >> > etc for Item B......
> >> > Ans
> >> > Item A 2 time take 30 days and 3 time 45 days.
> >> > The numbers of days can be range 25 to 30 act as 30 and 40 to 50 can
> >> > act
> >> > as
> >> > 45.
> >> > etc for Item B .......
> >> >
> >>
> >>
> >> .
> >>
>
>
> .
>
 | 
Pages: 1
Prev: Rules for locking controls
Next: Simple Consolidation of Worksheets