trying to add more columns in the NCAA Tournament Tracker but it won't keep
the formulas correct. Any help

Just what exactly is the/a

"NCAA Tournament Tracker"?
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

"NCAA Tourney Commissioner" <NCAA Tourney
wrote in message
...
trying to add more columns in the NCAA Tournament Tracker but it won't keep
the formulas correct. Any help

Maybe...

http://office.microsoft.com/en-us/as...132401033.aspx
or
http://office.microsoft.com/en-us/te...800721033.aspx
for the men's

and
http://office.microsoft.com/en-us/te...800711033.aspx
for the women's

And if the OP is trying to add columns to the "Results tracker" worksheet,
tools|Protection|unprotect sheet (there isn't a password, well, for the men's
version anyway--didn't check the women's).



RagDyeR wrote:

Just what exactly is the/a

"NCAA Tournament Tracker"?
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

"NCAA Tourney Commissioner" <NCAA Tourney
wrote in message
...
trying to add more columns in the NCAA Tournament Tracker but it won't keep
the formulas correct. Any help

--

Dave Peterson

RD

A Template from the Template Gallery.

http://office.microsoft.com/en-us/te...CT011377241033


Gord

On Wed, 16 Mar 2005 07:29:03 -0800, "RagDyeR" wrote:


Just what exactly is the/a

"NCAA Tournament Tracker"?

Thanks to you both for showing me exactly what kind of sheltered life I've
been living!<g

Never realized Redmond engaged in all this subtle marketing hype.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
RD

A Template from the Template Gallery.


http://office.microsoft.com/en-us/te...CT011377241033


Gord

On Wed, 16 Mar 2005 07:29:03 -0800, "RagDyeR"
wrote:


Just what exactly is the/a

"NCAA Tournament Tracker"?

Add the columns where?

Internally? To the right or left of existing columns?

What happens to the formulas when you do add a column?


Gord Dibben Excel MVP

On Wed, 16 Mar 2005 06:25:03 -0800, "NCAA Tourney Commissioner" <NCAA Tourney
wrote:

trying to add more columns in the NCAA Tournament Tracker but it won't keep
the formulas correct. Any help

Dear Mr. Commish:

Because of the way the formulas are laid out (consecutive rows referring to
non-consecutive rows on another sheet) the traditional copy/paste will not
work. I added enough columns to have 20 players in my pool. I edited the
formulas in the last column for Player 5 to read:

=IF('NCAA Men''s Bracket 2005'!$D8=L4, 1, 0) NOTE the addition of the '$'.
I had to manually edit each cell in the column (all the way down to row 78).
I also had to edit the score for a win for succeeding rounds, as we weight a
later round win as 2, 4, 8, 16 and 32 points as the rounds increase.

Also note that the developer Merged some cells, that also makes the copying
more difficult. I undid the merging while I was manipulating the data.

I then copied and pasted my updated formulas out to fill my 20 players.

HTH


"Gord Dibben" wrote:

Add the columns where?

Internally? To the right or left of existing columns?

What happens to the formulas when you do add a column?


Gord Dibben Excel MVP

On Wed, 16 Mar 2005 06:25:03 -0800, "NCAA Tourney Commissioner" <NCAA Tourney
wrote:

trying to add more columns in the NCAA Tournament Tracker but it won't keep
the formulas correct. Any help