On Fri, 22 Nov 2013 22:10:34 -0800 (PST), Nitya Satheesh wrote:

Thanks a Lot!!! That worked great!!!

I have one more query with respect to the same problem.What if I wanted to add one more column of data.

In addition to my previous response, if you are using my formulas, it is simple to adapt them to your requirements.

For the number of days for 1234, with

F2: 1234
G2: =COUNTIF(Column_a,F2)

And for the Max and Min of the values in column_b, merely adapt the formula I previously posted for the Max and Min of the values in column A:

e.g.

F6: 1
G6 (MIN): =VLOOKUP(F6,column_b:column_c,2,FALSE)
H6 (MAX): =LOOKUP(2,1/(column_b=F6),column_c)

You should be able to figure out how to use 2, 3 and 5678.

If you want different results, you will need to, as I mentioned before, be specific as to how you want the results presented.