Kapalı

Excel formula set up

Hello! Here's what I need.

MUST HAVE:

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.

NICE TO HAVE:

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: 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

Bu iş için 64 freelancer ortalamada £303 teklif veriyor

jaylancer43

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 Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(546 Değerlendirme)
8.2
seaanddream

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 Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(237 Değerlendirme)
7.4
zExcel

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 %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(249 Değerlendirme)
7.6
Khurramz

Hello! I understood that you want the name to be appeared depending upon questions completed. Can do this easily. Please send me chat and we can talk in detail.

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(302 Değerlendirme)
7.2
svet63

Let's do it. Cheers.

in %bids___i_period_sub_35% gün içinde555%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(57 Değerlendirme)
6.5
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work every day to excel. I have much experience with spreadsheets, formulas and macros. I am also an orderly, neat, methodical and committed person with my wo Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(178 Değerlendirme)
6.7
hdlong66

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 Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(111 Değerlendirme)
6.7
aarifakhtar

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 Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(152 Değerlendirme)
6.9
priyal1997

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 Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(176 Değerlendirme)
6.7
maverick44000

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 Fazla

in %bids___i_period_sub_35% gün içinde300%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(67 Değerlendirme)
6.7
chriskerpini

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 Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(60 Değerlendirme)
6.4
SiroosJafary

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 Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(69 Değerlendirme)
6.0
dpune

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 Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(115 Değerlendirme)
6.2
avinav606lx

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 Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(140 Değerlendirme)
6.3
Nawaz091993

Greetings! I am an excel formula expert and I can complete your task with utmost ease. Please do see my reviews given by client "Nalcro" to have an idea what I am capable of :)

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(63 Değerlendirme)
5.7
nagybatonyi

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 Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(62 Değerlendirme)
5.7
dragos1910d

A proposal has not yet been provided

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(85 Değerlendirme)
5.7
tomislav1975

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 %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(34 Değerlendirme)
5.3
rousseauassoc

Hi I feel I am well placed to help you with your project as I have many years experience with developing this kind of tool. I have put a small sample file together to create the kind of file you are looking for a Daha Fazla

in %bids___i_period_sub_35% gün içinde350%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(11 Değerlendirme)
5.4
vikas0903

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 Fazla

in %bids___i_period_sub_35% gün içinde277%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(38 Değerlendirme)
5.6