# A simple Excel Formula required (see project description)

Hi.

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.

Cheers,

Chris.

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

Taidot: Excel

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

Projektin tunnus: #4229435

## Myönnetty käyttäjälle:

deepbluetech

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)
5.1

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

mrbrave

Lets start....

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

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

Hi I can do your excel formulas :)

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

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)
1.7
elimayu

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)
0.0
beckymatteo

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)
0.0
chsaha

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)
0.0