Sorting Data
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 |
All times are GMT +1. The time now is 06:52 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com