How do i set up a repeating formula for data in excel?
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 |
How do i set up a repeating formula for data in excel?
Fizzle wrote:
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, 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? |
All times are GMT +1. The time now is 01:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com