Re: $$Excel-Macros$$ Match in Rows

2012-02-03 Thread dguillett1
Look in the help index for MATCH Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: qcan Sent: Thursday, February 02, 2012 11:00 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Match in Rows Hi, Not sure how to do this. Looking for a formula (pref

Re: $$Excel-Macros$$ Match in Rows

2012-02-02 Thread qcan
Bang on PERFECT. Thanks very much Viper for the quick accurate response !! On Feb 3, 12:09 am, The Viper wrote: > in ab1 > > =if(countif(a1:t1,aa1)>0,countif(a1:t1,aa1),"") > > > > > > On Fri, Feb 3, 2012 at 10:30 AM, qcan wrote: > > Hi, > > > Not sure how to do this. > > > Looking for a formul

Re: $$Excel-Macros$$ Match in Rows

2012-02-02 Thread The Viper
in ab1 =if(countif(a1:t1,aa1)>0,countif(a1:t1,aa1),"") On Fri, Feb 3, 2012 at 10:30 AM, qcan wrote: > Hi, > > Not sure how to do this. > > Looking for a formula (preferably) or a macro to find a number in a > row. Kind of like a "loto checker". > > In this case. > > - There are 20 columns