Hi all
I am new to forum and limited ability with Excel
I have a spreadsheet that I am trying to find the correct formula to collect and populate data into columns CM:CS from Columns
E,G,H

I have attached copy of sheet
Thanks in advance

David

See attached. Note that I've differentiated between win & place returns for winners and that your 'NTD' results need to be replaced with 0s.

Attached Files

Results Analysis.xlsm (467.6 KB, 13 views)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thanks Paul
I struggled with that formula all last night and this morning.
I still need a lot of practice with excel Formulas

One further question about the sheet when I import new data I get the following issue as per the attachment does the sheet require another module to be added in VBA for this section

Kind regards
David

As I said in my previous reply, you need to replace all the NTD results with 0s...
A simple Find/Replace will do that.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi Paul

I did the Find/Replace NTD with 0
Also did a Find/Replace #N/A with 0
but I am still getting the same results as per the last attachment

David

The most likely reason is that you have text, not just numbers, between rows 5 & 1500 in the column concerned (H).

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]