A simple Excel Formula required (see project description)


This should be a simple excel problem to an expert unlike me.

There is currently four columns:

(Col A) is (Win/Lose)

(Col B) is (Score)

(Col C) is (1,2,3) - checks to see if Score returns either 1, 2 or 3 - it it does returns (1) else (0).

(Col D) is (Running Total) - resets after a gap of one (0) (when score doesn't return either 1,2,3)

(Col E) is (Running Total 2) - same again except resets after a gap of 2 (0, 0)

What I want to do is be able to automate this process as I have demonstrated across three worksheets to make it easier to understand. This needs to be achieved by formulas as I want to be able to easily take it from this workbook to another.

Hope to speak soon.



PS: I am a previous ScriptLance member think my account is in process of being updated.

I forgot to say the formulas needed are for Column D and Column E

Thanks for your interest

Taidot: Excel

Näytä lisää: simple excel formula required, excel formula description, formula it, excel formulas expert, excel 0 to expert, be expert in excel, be an expert in excel, excel expert 2013, what is scriptlance member, simple excel, see, i want to do excel, Excel Formulas, excel formula, excel automate, excel 2013 formula, excel 2013 expert, excel project excel expert, excel simple expert simple, project workbook excel, excel checks, simple excel formula, required gap, description excel expert, think excel

Tietoa työnantajasta:
( 10 arvostelua ) London, United Kingdom

Projektin tunnus: #4229435

Myönnetty käyttäjälle:


Hi Chris, had a look at the Excel file. I can provide an Excel formula or macro based solution to meet your requirement. Let me know.

£20 GBP 1 päivässä
(57 Arvostelua)

8 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Lets start....

£20 GBP 0 päivässä
(77 arvostelua)

Hi Please check your message box. Done with the formula.

£20 GBP 1 päivässä
(20 arvostelua)

Hi I can do your excel formulas :)

£20 GBP 1 päivässä
(6 arvostelua)

Hi there, As a professional Excel developer, I will have no trouble getting this back to you within a day. I actually did something similar for a friend who was analysing betting patterns, so I'm confident in my abi Lisää

£20 GBP 1 päivässä
(1 arvostelu)

Manejo excel desde hace mas de 10 años y me dedique exclusivamente a perfecccionarlo y he logrado realizar proyectos y programas para empresas.

£150 GBP 15 päivässä
(0 arvostelua)

Im experienced with working with excel spreadsheets. I will do the job for you in a timely manner.

£20 GBP 15 päivässä
(0 arvostelua)

Hi Chris, I will make this in formulas and you just need to click a button to see the result. Waiting for your response... Chrres....

£20 GBP 2 päivässä
(0 arvostelua)