Hi Jim, Forgive me, if I've not understood it correctly but you can achieve the same task using Find method. Press Ctrl+F and search the number. Why you need a macro/custom formula ?
________________________________________ Thanks & Regards Ashish Jain McKinsey India Knowledge Center (Microsoft Certified Application Specialist) (Microsoft Certified Professional) http://www.excelitems.com http://www.openexcel.com ________________________________________ On Nov 14, 7:00 pm, JimJones <sportf...@gmail.com> wrote: > I've been seeking a solution to what would appear to be a simple > problem. > > OK, I get my lotto tickets. And usually, on the site I can check the > history to see if my lotto numbers have come up. > That's fine if you have only one ticket you're checking, but what if > you play the same five tickets every week? > > In my Excel spreadsheet, I have the 5 tickets I play (6 numbers for > each ticket) in separate cells, in five different rows. > So, there are 6 columns of numbers. > > Instead of entering these numbers on the website, to search past > results, I want to just enter the actual winning number > to compare to my 5 numbers. So, I see the simplest code that one > could provide for this task. > > Thank you. > > JJ -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
