$$Excel-Macros$$ Formula to Extract or Retrieve

Please need your help in creating a formula which will do the following Would like to extract this value 48-50 based on the criteria 2 found within the range Q21:AJ21. Would like a formula retrieve 48-50 in this format from the range Q21:AJ21 based on the criteria 2 on column AL21 found in the

$$Excel-Macros$$ Formula with retrieving squential data

Need your help in creating a formula which would do following:- To retrieve the value 18-19 from the range list B9:F14 to be stored in I10 To retrieve the value 40-41 from the range list B9:F14 to be stored in I11 To retrieve the value 11-12 from the range list B9:F14 to be stored in I13 Please

Re: $$Excel-Macros$$ IF and Index, Match formula

wow you did it thanks alot your input helped alot l am grateful On Sat, Mar 31, 2018 at 1:57 PM, Will Sob <will00...@gmail.com> wrote: > ok will try that and see how it works > > > On Sat, Mar 31, 2018 at 1:55 PM, Rabindra Thapa <rabinthapa2...@gmail.com> > wrote:

Re: $$Excel-Macros$$ IF and Index, Match formula

abianfal.com>* > > On Sat, Mar 31, 2018 at 3:51 PM, Will Sob <will00...@gmail.com> wrote: > >> Ok thanks >> >> >> On Sat, 31 Mar 2018, 13:50 Rabindra Thapa, <rabinthapa2...@gmail.com> >> wrote: >> >>> Formula is ok for

Re: $$Excel-Macros$$ IF and Index, Match formula

Ok thanks On Sat, 31 Mar 2018, 13:50 Rabindra Thapa, <rabinthapa2...@gmail.com> wrote: > Formula is ok for you! > > > > *Regards,* > > > > *For quick responds click here for Message <vhr.ad...@arabianfal.com>* > > On Sat, Mar 31, 2018 at

Re: $$Excel-Macros$$ IF and Index, Match formula

t; > *For quick responds click here for Message <vhr.ad...@arabianfal.com>* > > On Sat, Mar 31, 2018 at 12:33 PM, Will Sob <will00...@gmail.com> wrote: > >> Thanks for your response, In column S l have to copy and paste it on >> Column T and do it manually would li

Re: $$Excel-Macros$$ IF and Index, Match formula

wrote: > explain more. may i help you in this task ! > > *Regards,* > > > > *For quick responds click here for Message <vhr.ad...@arabianfal.com>* > > On Thu, Mar 29, 2018 at 7:07 PM, Will Sob <will00...@gmail.com> wrote: > >> I need the help with form

$$Excel-Macros$$ F and Index, Match formula Problem

I need the help with formula to retrieve the data highlighted in yellow from the List of data (E10:J52) and for this data to appear on Column L as 14,55. How do l go about it using IF, match, or any other way. Have tried with no success Thanks -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?

$$Excel-Macros$$ IF and Index, Match formula

I need the help with formula to retrieve the data highlighted in yellow from the List of data (E10:J52) and for this data to appear on Column L as 14,55. How do l go about it using IF, match, or any other way. Have tried with no success Thanks -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?

$$Excel-Macros$$ matching and copying data from row excel worksheet to another

Hi Team, Pls I need some help matching and copying data from row excel worksheet to another. For example: finding 19, 23, 28 from the range below, a formula or helpers to copy the row to another excel sheet 2 4 19 28 41 23 23-Dec-15 19 22 28 40 44 22 22-Aug-15 14 19 24 28 33 06 06-Jun-15 19

Re: $$Excel-Macros$$ Re: matching and copying data from row excel worksheet to another

This is Good I'm pleased Thanks On Fri, Feb 12, 2016 at 12:44 PM, Mandeep Baluja wrote: > Ya I did this for consecutive sequence of 19,23,28 ,Please find the >> attached formula in the file with helper. >> > > > Regards, > Mandeep baluja >

Re: $$Excel-Macros$$ I need the formula to look up

; > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > > ---

Re: $$Excel-Macros$$ I need the formula to look up

e > you can,As long as ever you can.” - John Wesley* > --------- > > -- > *From:* Will Sob <will00...@gmail.com> > *To:* "excel-macros@googlegroups.com" <excel-macros@googlegroups.com> > *Sent:* Sunday, November 1, 2015 12:09 PM > *Subject:* Re: $$Excel-Macros$$ I need th

Re: $$Excel-Macros$$ I need the formula to look up

mes you can,To all the people > you can,As long as ever you can.” - John Wesley* > --------- > > -- > *From:* Will Sob <will00...@gmail.com> > *To:* "excel-macros@googlegroups.com" <excel-macros@goo

Re: $$Excel-Macros$$ I need the formula to look up

ll the people > you can,As long as ever you can.” - John Wesley* > --------- > > -- > *From:* Will Sob <will00...@gmail.com> > *To:* "excel-macros@googlegroups.com" <excel-macros@googlegroups.com> >

Re: $$Excel-Macros$$ I need the formula to look up

Paul I dont seem to understand these formulas given when l change the data the formula does not change On Mon, Nov 2, 2015 at 8:51 PM, Will Sob <will00...@gmail.com> wrote: > i keep getting #Name result > > On Mon, Nov 2, 2015 at 8:28 PM, Paul Schreiner <schreiner_p..

$$Excel-Macros$$ I need the formula to look up

I need the formula to look up when for example ball 33 was last drawn and then look at the date this draw occured and then calculate the difference between that date and todays date I dont know if this is possible -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

Re: $$Excel-Macros$$ I need the formula to look up

PM, ashish koul <koul.ash...@gmail.com> wrote: > check this see if it helps > > On Sun, Nov 1, 2015 at 6:26 PM, Will Sob <will00...@gmail.com> wrote: > >> I need the formula to look up when for example ball 33 was last drawn and >> then look at the date

Re: $$Excel-Macros$$ Re: Help with combination formula

, 14 March 2015 15:06:13 UTC+5:30, Will Sob wrote: Hi, Please I need help with the attached file. I want a formula that calculates how many times (10, 13, 17) combination has appeared within the range D5:I32 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2

Re: $$Excel-Macros$$ Re: Help with combination formula

the combination triplet like the I5 contain 10 , d6 contain 13,d7 contain 17 is this countable or not . ?? On Monday, 16 March 2015 10:04:17 UTC+5:30, Will Sob wrote: thanks for your reply: l have loads of values, l am trying to build a template where when l place numbers it should tell me how many

Re: $$Excel-Macros$$ Re: Help with combination formula

Yes it is by macros l like your code but it just won't work On 16 Mar 2015 07:27, Will Sob will00...@gmail.com wrote: Thanks for responding yes in a single row. H l would like to know about both methods of you can most appreciated Tell me two things is the triplet combination your

Re: $$Excel-Macros$$ Re: Help with combination formula

l'm sorry please see attachment On Sun, Mar 15, 2015 at 2:45 AM, sahemur khan sahe...@gmail.com wrote: On Saturday, 14 March 2015 15:06:13 UTC+5:30, Will Sob wrote: Hi, Please I need help with the attached file. I want a formula that calculates how many times (10, 13, 17) combination has

Re: $$Excel-Macros$$ Re: Help with combination formula

://www.facebook.com/VBAEXCELSQL?ref=hl https://www.linkedin.com/profile/view?id=312532939 On Sunday, 15 March 2015 23:04:26 UTC+5:30, Will Sob wrote: l'm sorry please see attachment On Sun, Mar 15, 2015 at 2:45 AM, sahemur khan sah...@gmail.com wrote: On Saturday, 14 March 2015 15:06:13 UTC+5

Re: $$Excel-Macros$$ Re: Help with combination formula

the values which you are trying to get On Monday, March 16, 2015 at 3:24:40 AM UTC+5:30, Will Sob wrote: thanks but it is not working when l use other values On Sun, Mar 15, 2015 at 7:11 PM, Mandeep baluja mandee...@gmail.com wrote: Check this attachment achieved with a macro. Change your

$$Excel-Macros$$ Help with combination formula

Hi, Please I need help with the attached file. I want a formula that calculates how many times (10, 13, 17) combination has appeared within the range D5:I32 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this

$$Excel-Macros$$ Formula Needed Please

Hi, Please I need help with the attached file. I want a that calculates how many times 10, 13, 17 has appeared within the range D5:I32 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @

Re: $$Excel-Macros$$ Run time error 9 subscript out of range - lotto Query

of your solution.. Did this code worked proper;y previously ? Cheers!! On Tue, Jun 10, 2014 at 1:24 AM, Will Sob will00...@gmail.com wrote: Dear Expert, Please look at this code what is wrong with it I'm not an expert in VBA but would need some of your knowledge in this matter I want