Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FOrmula Copy and Paste
OK I have a horse racing game that I am trying to setup. I have over 150
people coming and want my program to go smooth as silk. Trying to save some time instead of doing one formula for each one, hoping to copy and paste for all 150 guests names. Thanks A B C D E F G 1 highsteppin 1 2 Roundabout 2 3 4 last name first name horse name win place show 5 SMITH JOHN HIGHSTEPPIN 1 0 0 6 JOHNSON BOB ROUNDABOUT 0 1 0 =IF(C5=C1,1,0) THIS IS THE FORMULA IN E5, AND IN F5 AND G5, I NEED TO KNOW HOW TO COPY THIS FORMULA AND PASTE IT INTO E6, F6, G6, BUT FOR IT TO READ IF(C6=C1,1,0), AND IF(C7=C1,1,0) AND SO ON DOWN THE LIST OF 150 PEOPLE. I NEED THE FORULA TO UPDATE THE FIRST PART, BUT MAKE REFERENCE TO THE C1 AND C2. THANKS WHOEVER IS GOING TO HELP ME. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FOrmula Copy and Paste
Confused at Work wrote:
OK I have a horse racing game that I am trying to setup. I have over 150 people coming and want my program to go smooth as silk. Trying to save some time instead of doing one formula for each one, hoping to copy and paste for all 150 guests names. Thanks A B C D E F G 1 highsteppin 1 2 Roundabout 2 3 4 last name first name horse name win place show 5 SMITH JOHN HIGHSTEPPIN 1 0 0 6 JOHNSON BOB ROUNDABOUT 0 1 0 =IF(C5=C1,1,0) THIS IS THE FORMULA IN E5, AND IN F5 AND G5, I NEED TO KNOW HOW TO COPY THIS FORMULA AND PASTE IT INTO E6, F6, G6, BUT FOR IT TO READ IF(C6=C1,1,0), AND IF(C7=C1,1,0) AND SO ON DOWN THE LIST OF 150 PEOPLE. I NEED THE FORULA TO UPDATE THE FIRST PART, BUT MAKE REFERENCE TO THE C1 AND C2. THANKS WHOEVER IS GOING TO HELP ME. Look at "Switch between relative, absolute, and mixed references" in the help file. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FOrmula Copy and Paste
If you have the same formula
=IF(C5=C1,1,0) in E5, F5, and G5 Then use this instead =IF(C5=$C1,1,0) But if you have =IF(C5=C1,1,0) in E5 and =IF(C6=C1,1,0) in F5 ... then use =IF(INDIRECT("C"&COLUMN())=$C1,1,0) "Confused at Work" wrote: OK I have a horse racing game that I am trying to setup. I have over 150 people coming and want my program to go smooth as silk. Trying to save some time instead of doing one formula for each one, hoping to copy and paste for all 150 guests names. Thanks A B C D E F G 1 highsteppin 1 2 Roundabout 2 3 4 last name first name horse name win place show 5 SMITH JOHN HIGHSTEPPIN 1 0 0 6 JOHNSON BOB ROUNDABOUT 0 1 0 =IF(C5=C1,1,0) THIS IS THE FORMULA IN E5, AND IN F5 AND G5, I NEED TO KNOW HOW TO COPY THIS FORMULA AND PASTE IT INTO E6, F6, G6, BUT FOR IT TO READ IF(C6=C1,1,0), AND IF(C7=C1,1,0) AND SO ON DOWN THE LIST OF 150 PEOPLE. I NEED THE FORULA TO UPDATE THE FIRST PART, BUT MAKE REFERENCE TO THE C1 AND C2. THANKS WHOEVER IS GOING TO HELP ME. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FOrmula Copy and Paste
gOT IT WORKING THANKS EVERYONE
"Glenn" wrote: Confused at Work wrote: OK I have a horse racing game that I am trying to setup. I have over 150 people coming and want my program to go smooth as silk. Trying to save some time instead of doing one formula for each one, hoping to copy and paste for all 150 guests names. Thanks A B C D E F G 1 highsteppin 1 2 Roundabout 2 3 4 last name first name horse name win place show 5 SMITH JOHN HIGHSTEPPIN 1 0 0 6 JOHNSON BOB ROUNDABOUT 0 1 0 =IF(C5=C1,1,0) THIS IS THE FORMULA IN E5, AND IN F5 AND G5, I NEED TO KNOW HOW TO COPY THIS FORMULA AND PASTE IT INTO E6, F6, G6, BUT FOR IT TO READ IF(C6=C1,1,0), AND IF(C7=C1,1,0) AND SO ON DOWN THE LIST OF 150 PEOPLE. I NEED THE FORULA TO UPDATE THE FIRST PART, BUT MAKE REFERENCE TO THE C1 AND C2. THANKS WHOEVER IS GOING TO HELP ME. Look at "Switch between relative, absolute, and mixed references" in the help file. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can't copy/paste the formula | Excel Discussion (Misc queries) | |||
Copy / Paste Formula | Excel Discussion (Misc queries) | |||
copy and paste formula | Excel Discussion (Misc queries) | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
formula for copy and paste | New Users to Excel |