Hi,
there is a formula (got it in this forum) that may help
=sum(if(countif(a:f;"name of cells where your numbers are");1;))
crtl+shift+enter
rgds
"mikey69" wrote:
I have downloaded an excel file from 'Lotto Draw History'
(https://www.national-lottery.co.uk/p...iles/Lotto.csv) and want to
sort the data so I can quickly check whether my numbers have previously
won any large amount in the past.
I am struggling to do this and would appreciate any help.
TIA,
Mike
--
mikey69
------------------------------------------------------------------------
mikey69's Profile: http://www.excelforum.com/member.php...o&userid=13237
View this thread: http://www.excelforum.com/showthread...hreadid=318884