If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
I need additional players fields for the NCAA Mens Div 1 basketba.
I would like to add additional players to my ncaa tournament tracker but I
don't know how to do this. Please help |
#2
|
|||
|
|||
Exuse the cutting and pasting but this worked. Found it in another post.
Adding the $ causes a copy without incrementing. 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 "turnerjoy" wrote: I would like to add additional players to my ncaa tournament tracker but I don't know how to do this. Please help |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Additional work experience fields | Jenniferjoane | General Discussion | 1 | January 10th, 2005 06:09 PM |
Additional fields for form based parameter query/null fields | geeksdoitbetter | Running & Setting Up Queries | 2 | January 7th, 2005 10:05 PM |
update field based on the contents of three additional fields | Aldricla | Running & Setting Up Queries | 2 | September 28th, 2004 02:30 PM |
how do I have three additional fields in a form appear when a fie. | Access Forms help | General Discussions | 1 | August 31st, 2004 12:59 AM |