Measure on the date different
 

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

Measure on the date different
 

Have you tried a pivot table?

--

HTH

Bob

"Sky" wrote in message
...
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 .......

Measure on the date different
 

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" wrote in message
...
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 .......



.

Measure on the date different
 

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" wrote in message
...
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" wrote in message
...
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 .......



.

Measure on the date different
 

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" wrote in message
...
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" wrote in message
...
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 .......



.



.