Sorting Data

[mikey69]

I have downloaded an excel file from 'Lotto Draw History
(https://www.national-lottery.co.uk/player/files/Lotto.csv) and want t
sort the data so I can quickly check whether my numbers have previousl
won any large amount in the past.

I am struggling to do this and would appreciate any help.




TIA,

Mik

 

[Guest]

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