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"?

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

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"?