Forum Discussion
steven Green
Aug 21, 2017Copper Contributor
Problem with a Excel formula
Hi Not sure what I've done but the only thing I've changed is the number of cells/ lines in the range from: =MAX(IF('Draw Results'!C1:C2248={3,4},'Draw Results'!D1:D2248)) to =MAX(IF('Draw Results'!...
steven Green
Oct 13, 2017Copper Contributor
Hi Sorry it took so long to reply but my laptop has been away for repair. Will try your suggestion as sson as i can. thank you
steven Green
Oct 29, 2017Copper Contributor
Hi service. Tried all you said and looked at the file you attached but still won't work.
- SergeiBaklanNov 05, 2017Diamond Contributor
Steven,
That could be something else, but i see no errors in my copy of the file. How your date is entered you may check in formula bar. If as text
you have an error, if as date
all works