How do i set up a repeating formula for data in excel?

F

Fizzle

I want to find out how i would set up a repeating formula to calculate scores
on a survey. I would like to do this witout repeating formulas for each
candidate. The questions and answers are automatically exported from
Sharepoint into an excel spreadsheet:

ID Created By 1)Define Manual Handling
1 Bob e.All of the above.
2 Emma e.All of the above.


Many thanks,

Fizzle
 
S

smartin

Fizzle said:
I want to find out how i would set up a repeating formula to calculate scores
on a survey. I would like to do this witout repeating formulas for each
candidate. The questions and answers are automatically exported from
Sharepoint into an excel spreadsheet:

ID Created By 1)Define Manual Handling
1 Bob e.All of the above.
2 Emma e.All of the above.


Many thanks,
Click to expand...
Hi Fizzle

Would you explain the layout of the data? Your example appears to have
candidate info in two columns and responses (for whom?) in another
column. Is this correct?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cumulative formula for word table 0
How do I stack data in Excel 2007? 1
How do I set up a repeating meeting in Outlook for every 25 days? 1
How do I set up a repeating meeting in Outlook but not use recurr 1
how do i set up a profit margin formula 2
How do I set up a repeating meeting in Outlook? 2
How do I insert a row without the formula changing? 1
Formula derived default values in a repeating table 1

Top