software

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: www.excelforum.com/member.php...oamp;userid=30457
View this thread: www.excelforum.com/showthread...hreadid=501237
oh, I forgot to mention, those two formulas do what I need, but I need
them combined into one formula and I can't figure that out--
elfudge35
------------------------------------------------------------------------
elfudge35's Profile: www.excelforum.com/member.php...oamp;userid=30457
View this thread: www.excelforum.com/showthread...hreadid=501237
can anybody help? I've got this code, but I need to create a function
with it if it can't be done with current functions

Sub test()
Range(quot;a2quot;).Select
Range(Selection, Selection.End(xlDown)).Select

Index = 3
For Each rng In Selection
If rng.Offset(0, 0) lt;gt; rng.Offset(1, 0) And InStr(1,
rng.Offset(0, 0), quot;Totalquot;) = 0 Then
Cells(1, Index) = rng.Offset(0, 0)
Index = Index 1
End If
Next rng
End Sub--
elfudge35
------------------------------------------------------------------------
elfudge35's Profile: www.excelforum.com/member.php...oamp;userid=30457
View this thread: www.excelforum.com/showthread...hreadid=501237On sheet2,

A1:=Sheet1!A1
B1: =IF(ISERROR(MATCH(0,COUNTIF($A$1:A1,Sheet1!$A$1:$A $20amp;quot;quot;),0)),quot;quot;,
INDEX(IF(ISBLANK(Sheet1!$A$1:$A$20),quot;quot;,Sheet1!$A$1 :$A$20),
MATCH(0,COUNTIF($A$1:A1,Sheet1!$A$1:$A$20amp;quot;quot;),0)))

the latter is an array formula, so commit with Ctrl-Shift-Enter and copy
across.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;elfudge35quot; gt; wrote
in message ...
gt;
gt; I need to take a column that is in this format:
gt; 1/1/06
gt; 1/1/06 total
gt; 1/4/06
gt; 1/4/06
gt; 1/4/06 total
gt; 2/7/06
gt; 2/7/06 total
gt; and so on
gt;
gt; and make it into a column heading automatically, so that any time the
gt; dates are changed or the totals move or anything, the dates at the top
gt; row automatically change with it
gt;
gt; 1/1/06 1/4/06 2/7/06, etc
gt;
gt; in column c1:m1 and c2:m2 I put these formulas
gt; c1=SMALL($A$2:$A$50,B2 1)
gt; c2=COUNTIF($A$2:$A$50,C1) B2
gt;
gt; there is nothing in column b, but in column d-m it calculates the
gt; occurances of all previous dates to know where to start the SMALL
gt; function from
gt;
gt;
gt; --
gt; elfudge35
gt; ------------------------------------------------------------------------
gt; elfudge35's Profile:
www.excelforum.com/member.php...oamp;userid=30457
gt; View this thread: www.excelforum.com/showthread...hreadid=501237
gt;

I guess nobody can do it?--
elfudge35
------------------------------------------------------------------------
elfudge35's Profile: www.excelforum.com/member.php...oamp;userid=30457
View this thread: www.excelforum.com/showthread...hreadid=501237
ok, but how do I keep the total lines out of that?--
elfudge35
------------------------------------------------------------------------
elfudge35's Profile: www.excelforum.com/member.php...oamp;userid=30457
View this thread: www.excelforum.com/showthread...hreadid=501237
I only need the dates, can you do something to get rid of the total
lines?--
elfudge35
------------------------------------------------------------------------
elfudge35's Profile: www.excelforum.com/member.php...oamp;userid=30457
View this thread: www.excelforum.com/showthread...hreadid=501237