Excel Formulas Assistance Needed
Budget: $30 – $250 USD
I'm seeking an experienced Excel guru to help create / identify two specific formulas on my spreadsheet.
This project is URGENT. The right excel Guru can probably figure this out in less than an hour. Easy money.
The first formula is related to searching a cell for one of four words and populating an adjacent column with a correlating value, based on the word found. The four words to be searched for are "Low", "Medium", "High", and "Not currently a priority". The adjacent cells are to be populated with correlating values 1, 2, 3, and 0 (to generate a Score). The cells are currently blank, and users of the spreadsheet will fill these cells by selecting from a drop-down list (of these 4 words). The objective is to create a formula that converts their answer (in one cell) to a score (in an adjacent, hidden, cell).
The second formula involves summing (adding) the scores (easy), but then counting number of values 'summed', and dividing the total sum by the number of values counted. The objective is to write a formula that adds up the various scores, divides it by the number of answers provided (i.e., doesn't count questions they skip), and generates a total score.
In the attached image, I entered this data manually in Columns G and used a basic formula in column H. It is columns G and H that I am looking to automate based on user data entered in column F (which will initially start off blank).
I need to replicate this formula 125x, and so would also like you to walk me through the formulas.
This task requires a good understanding of data manipulation within Excel. Skills and experience ideal for this project include:
- Advanced proficiency in Excel formulas and functions
- Experience in data manipulation and analysis
- Attention to detail and ability to execute complex instructions
- Ability to work efficiently and effectively with data sets
A successful freelancer will be able to complete these tasks accurately and promptly, ensuring that the formulas perform as intended in my spreadsheet.
This project is URGENT. The right excel Guru can probably figure this out in less than an hour. Easy money.
The first formula is related to searching a cell for one of four words and populating an adjacent column with a correlating value, based on the word found. The four words to be searched for are "Low", "Medium", "High", and "Not currently a priority". The adjacent cells are to be populated with correlating values 1, 2, 3, and 0 (to generate a Score). The cells are currently blank, and users of the spreadsheet will fill these cells by selecting from a drop-down list (of these 4 words). The objective is to create a formula that converts their answer (in one cell) to a score (in an adjacent, hidden, cell).
The second formula involves summing (adding) the scores (easy), but then counting number of values 'summed', and dividing the total sum by the number of values counted. The objective is to write a formula that adds up the various scores, divides it by the number of answers provided (i.e., doesn't count questions they skip), and generates a total score.
In the attached image, I entered this data manually in Columns G and used a basic formula in column H. It is columns G and H that I am looking to automate based on user data entered in column F (which will initially start off blank).
I need to replicate this formula 125x, and so would also like you to walk me through the formulas.
This task requires a good understanding of data manipulation within Excel. Skills and experience ideal for this project include:
- Advanced proficiency in Excel formulas and functions
- Experience in data manipulation and analysis
- Attention to detail and ability to execute complex instructions
- Ability to work efficiently and effectively with data sets
A successful freelancer will be able to complete these tasks accurately and promptly, ensuring that the formulas perform as intended in my spreadsheet.