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