I need to take a column that is in this format:
1/1/06
1/1/06 total
1/4/06
1/4/06
1/4/06 total
2/7/06
2/7/06 total
and so on

and make it into a column heading automatically, so that any time the
dates are changed or the totals move or anything, the dates at the top
row automatically change with it

1/1/06 1/4/06 2/7/06, etc

in column c1:m1 and c2:m2 I put these formulas
c1=SMALL($A$2:$A$50,B2+1)
c2=COUNTIF($A$2:$A$50,C1)+B2

there is nothing in column b, but in column d-m it calculates the
occurances of all previous dates to know where to start the SMALL
function from


--
elfudge35
------------------------------------------------------------------------
elfudge35's Profile: http://www.excelforum.com/member.php...o&userid=30457
View this thread: http://www.excelforum.com/showthread...hreadid=501237