|
|
|
|
#1
09-10-2015, 12:46 AM
|
||||
|
||||
See attached. Note that I've differentiated between win & place returns for winners and that your 'NTD' results need to be replaced with 0s.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
|
#2
09-10-2015, 01:12 AM
|
|||
|
|||
|
Great stuff
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 Last edited by dmcg9760; 12-21-2015 at 02:14 AM.
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Excel formula required to speed up process of creating species rarefaction curves. Ecology! | Tim_F | Excel | 2 | 07-18-2014 04:56 AM |
| Excel VBA Multiple Automatic Goal Seek Required – Please Assist us | champaben | Excel Programming | 13 | 06-22-2014 05:54 AM |
| Excel 2007 - formula or macro/vba code required | wrighty50 | Excel Programming | 3 | 05-13-2012 02:24 PM |
| Formula Help Required | OTPM | Excel | 6 | 08-31-2011 02:58 AM |
| Formula problem? | markg2 | Excel | 11 | 06-10-2010 07:42 AM |
Excel formula problem/ Help required
Windows 7 64bit 
Office 2010 32bit
Hybrid Mode