Excel formula set up

Hello! Here's what I need.


I need an excel sheet that has a data entry field for a name, then a series of seven questions, each with a dropdown box offering 3 choices.

The name is entered, then the seven questions are answered.

Each answer is then (invisibly) assigned to a score of 1, 2 or 3 depending on the answer.

After all questions are answered (and not before!) the name entered in the name entry field will appear in one of nine cells, depending on their score.


It would be great if when a name appears in a cell, the user can then repeat the exercise without the name disappearing, and the next name can then be plotted.

Beceriler: Excel

Daha fazlasını görün: formula it, data entry score, data entry exercise, excel sheet formula, excel formula, data set formula, excel repeat formula, need formula, formula sheet, questions formula, questions excel answer, nice dropdown, data entry formula, exercise excel, excel questions answer, excel exercise, import excel files great plains dynamics, aspnet crystal report set formula, dropdown excel, set formula field crystal reports, excel sheet webpage cell webservice, excel cell repeat, crystal reports set formula field, importing entries excel microsoft great plains, formula sheet excel

İşveren Hakkında:
( 0 değerlendirme ) United Kingdom

Proje NO: #6531431

65 freelancers are bidding on average £302 for this job


Let's do it. Cheers.

in 7 gün içinde555£ GBP
(56 Değerlendirme)

Hi, I'd be happy to help you with this project. Quick turnaround on most jobs. Please feel free to message me if you need to discuss any questions

in 2 gün içinde250£ GBP
(110 Değerlendirme)

Dear Sir/Madam, I'm happy to help you on this task. I am an expert in advanced excel features and formulas. If you are comfortable with my ratings and reputation, pls send me the full details. I assure you that I wil Daha fazlası

in 3 gün içinde250£ GBP
(128 Değerlendirme)

Hi, my name is Sevinc. I am a 5-star excel and vba coding expert here. pls check my profile and feedbacks first to have some idea bout the quality of my previous works. I read your excel project descriptions carefully. Daha fazlası

in 3 gün içinde250£ GBP
(101 Değerlendirme)

Hi Mate. I have previously done a very similar project in Excel before and I would be glad to share it with you to review and analyse. I shall then make one according to your specific requirements. Kindly discuss. Rega Daha fazlası

in 2 gün içinde300£ GBP
(44 Değerlendirme)

Hello Sir - I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am amo Daha fazlası

1 gün içinde 250£ GBP
(78 Değerlendirme)

Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality ou Daha fazlası

in 3 gün içinde250£ GBP
(73 Değerlendirme)

I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. In my approach you'll have opportunity to consult details with me Daha fazlası

in 2 gün içinde250£ GBP
(55 Değerlendirme)

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 215 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive Daha fazlası

in 10 gün içinde250£ GBP
(42 Değerlendirme)

Hello, The "MUST HAVE" part can be implemented using only Excel formulas and names, but the "NICE TO HAVE" part requires also VBA code. I can provide both in max 2 days. Please contact me to discuss the details. Daha fazlası

in 2 gün içinde250£ GBP
(28 Değerlendirme)

Hi: I have a question: Do you want to repeat the exercise and ensure that the name entered does not disappear but gets transferred to the Score column every time use answers all the questions? Please note that I have 1 Daha fazlası

in 3 gün içinde250£ GBP
(34 Değerlendirme)

Hi, I can help you with your requirement. I have closed more than 150 excel projects at various forums. Please provide more details to help you better. Regards Sawan

in 3 gün içinde250£ GBP
(21 Değerlendirme)

Hi, Approach: I have prepared CRM softwares before and have provided such kind of functionalities to user before. Would like to provide you sample of that. Background: I am working as Lead Pricing Analyst in a Daha fazlası

in 5 gün içinde277£ GBP
(17 Değerlendirme)

Good day, I am expert. I teach excel. I can say there is no formula in excel that I cannot handle it. I've got lots of experiences in excel automating and conditional formatting. I work with excel since 1999. Here Daha fazlası

in 3 gün içinde250£ GBP
(38 Değerlendirme)

A proposal has not yet been provided

in 3 gün içinde250£ GBP
(32 Değerlendirme)

Hi there, I've been working with Excel since before '98 and I've been using all possible versions of it. I have years of experience working with macros and writing / debugging VBA code. You may check my portfolio Daha fazlası

in 2 gün içinde250£ GBP
(31 Değerlendirme)

Hello. I am good in excel and able to deliver quality work. Please provide series of question and condition to show name on each of nine cells. I will set formula as per your requirement. Kindly refer to my related pro Daha fazlası

1 gün içinde 250£ GBP
(36 Değerlendirme)

The key to a project like this is ensuring that you get the required flexibility. The ability to easily set-up new questions & answers with the appropriate points allocated. So it is important that whoever takes on t Daha fazlası

in 3 gün içinde250£ GBP
(4 Değerlendirme)

Hello, I have such project done ([url removed, login to view]). I can adjust it to your needs in few hours and I am willing to do this for less money. Also, please check my [url removed, login to view], Tom

in 0 gün içinde250£ GBP
(14 Değerlendirme)

Hello, You appear to be asking for a relatively easy program to write and I wouldn't feel right have you pay me 250. I would be willing to do it for 150. I could incorporate your "nice to have" requests as well. Daha fazlası

in 2 gün içinde250£ GBP
(22 Değerlendirme)