Getting Max and Min Date from a Range, based on some condition

[Chetan]

Hi All,


I have the machine serial number wise printed data on perticular Dates.

I wanted to have the machine serial number wise summary wherein, i could figure out the first and last date of printouts taken from the machine with count of prints.

Ex.

My data looks like:

[pre]

Serial Number	Print Date	Number of Prints
3259223333	01-Jan-13	22
10-Jan-13	28
29-Jan-13	49
3315718227	02-Jan-13	29
04-Jan-13	35
26-Jan-13	98
3316014940	05-Jan-13	29
31-Jan-13	68
28-Jan-13	61
30-Jan-13	66
3316015653	01-Jan-13	47
08-Jan-13	50
09-Jan-13	55
31-Jan-13	76
26-Jan-13	67
3316027112	31-Jan-13	109
29-Jan-13	92
01-Jan-13	79
10-Jan-13	84
and the summary looks like:


Min		Max
Serial Number	Date	Number of Prints	Date	Number of Prints
3259223333	01-Jan-13	22	29-Jan-13	49
3315718227	02-Jan-13	29	26-Jan-13	98
3316014940	05-Jan-13	29	31-Jan-13	68
3316015653	01-Jan-13	47	31-Jan-13	76
3316027112	01-Jan-13	79	31-Jan-13	109

[/pre]
as of now i am using pivot table. and from Report filter i am choosing one by one machine serial numbers.

Any help would highly appreciated. It will reduce my much time.


Thanks,

Chetan

 

[Faseeh]

Hi Chetan,


Please see this file:


http://dl.dropbox.com/u/60644346/Chetan_Pivot%20Sample.xlsx


Regards,

 

[Chetan]

Hi Faseeh,


Thanks a ton..


Allow me some time to check and confirm the excel file shared by you.


Cheers !!!


Thanks,

Chetan

 

[Faseeh]

Hi chetan,


You are welcome..