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 ra
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
wow you did it thanks alot your input helped alot
l am grateful
On Sat, Mar 31, 2018 at 1:57 PM, Will Sob wrote:
> ok will try that and see how it works
>
>
> On Sat, Mar 31, 2018 at 1:55 PM, Rabindra Thapa
> wrote:
>
>> if you not need extra column just add
ok will try that and see how it works
On Sat, Mar 31, 2018 at 1:55 PM, Rabindra Thapa
wrote:
> if you not need extra column just add all fromula in one cell
>
> *Regards,*
>
>
>
> *For quick responds click here for Message *
>
> On Sat, Mar 31, 2018 at 3:51 PM, Will
Ok thanks
On Sat, 31 Mar 2018, 13:50 Rabindra Thapa, wrote:
> Formula is ok for you!
>
>
>
> *Regards,*
>
>
>
> *For quick responds click here for Message *
>
> On Sat, Mar 31, 2018 at 3:38 PM, Will Sob wrote:
>
>> Thanks, what I meant is using I
nds click here for Message *
>
> On Sat, Mar 31, 2018 at 12:33 PM, Will Sob wrote:
>
>> Thanks for your response, In column S l have to copy and paste it on
>> Column T and do it manually would like formula that puts a comma in between
>> like row Row S39 to look like 6,14,23
in this task !
>
> *Regards,*
>
>
>
> *For quick responds click here for Message *
>
> On Thu, Mar 29, 2018 at 7:07 PM, Will Sob wrote:
>
>> I need the help with formula to retrieve the data highlighted in yellow
>> from the List of data (E10:J52) and for t
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?
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?
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
> https://www.linkedin.com/messaging/thread/608648864613
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 23
o 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*
> -
>
> --
> *From:*
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 wrote:
> i keep getting #Name result
>
> On Mon, Nov 2, 2015 at 8:28 PM, Paul Schreiner
> wrote:
>
>> Dates should be dis
people
> you can,As long as ever you can.” - John Wesley*
> -----
>
> --
> *From:* Will Sob
> *To:* "excel-macros@googlegroups.com"
> *Sent:* Monday, November 2, 2015 3:09 PM
>
> *Subject:* Re: $$Excel-Macros$$ I need the fo
people
> you can,As long as ever you can.” - John Wesley*
> -----
>
> --
> *From:* Will Sob
> *To:* "excel-macros@googlegroups.com"
> *Sent:* Monday, November 2, 2015 3:09 PM
>
> *Subject:* Re: $$Excel-Macros$
>
> *Paul*
> -
>
>
>
>
>
>
>
> *“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*
> -
&g
1:19 PM, ashish koul wrote:
> check this see if it helps
>
> On Sun, Nov 1, 2015 at 6:26 PM, Will Sob wrote:
>
>> 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
>>
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
=TI
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 appeared within the
>> range D5:I32
>>
>>
>>
>>
&
Yes it is by macros l like your code but it just won't work
On 16 Mar 2015 07:27, "Will Sob" 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 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
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
>> wrote:
>>
>>> Check this attachment achieve
ps://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 wro
l'm sorry please see attachment
On Sun, Mar 15, 2015 at 2:45 AM, sahemur khan 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) c
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 forum
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 @
https://www.faceboo
!!
>
>
> On Wed, Jun 11, 2014 at 2:17 AM, Will Sob wrote:
>
>> thanks it did work but it did not build the triplets i specify
>>
>> it just calculated it to 18424
>>
>>
>> On Tue, Jun 10, 2014 at 6:19 AM, Vaibhav Joshi wrote:
>>
>>> He
w thread as per forum rule so that you get attention
>> & proper resolution of your solution..
>>
>> Did this code worked proper;y previously ?
>>
>> Cheers!!
>>
>>
>> On Tue, Jun 10, 2014 at 1:24 AM, Will Sob wrote:
>>
>>> Dear Ex
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 to put together a formula that takes say a 6/49 lotto and point out
say I want to find the most occurring triples, it finds them and show how
many times
29 matches
Mail list logo