software

hello everyone,

This is my first time posting so I hope this is legible....

I have a sheet with 50,000 or so rows consisting of two colums

1. postcode
2. delivery date

i need to find out how many of each postcode there are in each delivery
date. In the past I just auto filter and select a delivery date and then
manually select each postcode to see how many of each. This can take
almost a whole day....does anyone have a better idea of how I could do
this, there are so many ways to do everything in excel there has to be
an easier and quicker way....

Any help would be really appreciated

Thank you all in advance

Jose--
jose001
------------------------------------------------------------------------
jose001's Profile: www.excelforum.com/member.php...oamp;userid=32857
View this thread: www.excelforum.com/showthread...hreadid=526690Sounds like pivot tables is what you want. See
www.contextures.com/xlPivot01.html

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;jose001quot; gt; wrote in
message ...
gt;
gt; hello everyone,
gt;
gt; This is my first time posting so I hope this is legible....
gt;
gt; I have a sheet with 50,000 or so rows consisting of two colums
gt;
gt; 1. postcode
gt; 2. delivery date
gt;
gt; i need to find out how many of each postcode there are in each delivery
gt; date. In the past I just auto filter and select a delivery date and then
gt; manually select each postcode to see how many of each. This can take
gt; almost a whole day....does anyone have a better idea of how I could do
gt; this, there are so many ways to do everything in excel there has to be
gt; an easier and quicker way....
gt;
gt; Any help would be really appreciated
gt;
gt; Thank you all in advance
gt;
gt; Jose
gt;
gt;
gt; --
gt; jose001
gt; ------------------------------------------------------------------------
gt; jose001's Profile:
www.excelforum.com/member.php...oamp;userid=32857
gt; View this thread: www.excelforum.com/showthread...hreadid=526690
gt;