On Sunday, November 24, 2013 6:25:50 PM UTC+5:30, Ron Rosenfeld wrote:
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.

Thank You! Sorry I was not more specific. I used The Pivot table method and just set up another Pivot table.

Thanks again.