You are welcome Noor.
Not sure if you received the attachment as I am not seeing that in the web
portal hence sending that again. :)
Regards,
DILIPandey
On Mon, Oct 21, 2013 at 8:33 AM, Mohd Noor Ibrahim <MohdNoor@ptp.com.my>wrote:
> **
>
>
> HI DILIPandey,****
>
> ** **
>
> Thanks and very much appreciated****
>
> ** **
>
> *From:* ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] *On
> Behalf Of *DILIPandey
> *Sent:* Sunday, October 20, 2013 2:32 PM
> *To:* ExcelVBA@yahoogroups.com
> *Subject:* Re: [ExcelVBA] Find from multiple range****
>
> ** **
>
> ****
>
> Hi Noor,
>
> See the below fine where I have used below formula to achieve the desired
> result:-
>
>
> {=IF(SUMPRODUCT(($B$2:$B$7<=$F$2)*($C$2:$C$7>=$F$2)*ROW($C$2:$C$7))>=1,1,"not
> found")}
>
> On Fri, Oct 18, 2013 at 7:05 AM, Mohd Noor Ibrahim <MohdNoor@ptp.com.my
> >wrote:
>
> > **
> >
> >
> > HI All,****
> >
> > ** **
> >
> > I need help****
> >
> > ** **
>
> >
> > I have a list of list that I want to check if its fall between below
> table
> > ,****
> >
> > ** **
>
> >
> > Example : abcd3501099 if falls between below range will return as 1 , and
> > the list continues..****
> >
> > ** **
> >
> > ** **
> >
> > ** **
> >
> > ****
> >
> > Range1****
> >
> > Range2****
> >
> > *abcd*
> >
> > *3501070*
> >
> > *3517069*
> >
> > *abcd*
> >
> > *1270420*
> >
> > *1273919*
> >
> > *abcd*
> >
> > *9443430*
> >
> > *9443439*
> >
> > *wrst*
> >
> > *3598110*
> >
> > *3638109*
> >
> > *wrst*
> >
> > *1567260*
> >
> > *1572259*
> >
> > *wrst*
> >
> > *9877010*
> >
> > *9887009*
> >
> > ** **
> >
> > ** **
> >
> > Best Regards,****
> >
> > MOhdnoor****
>
> >
> > Disclaimer: This e-mail and any attachment(s) hereto is only for the use
> > of the intended recipient(s) and may contain information that is
> > confidential and/or privileged under applicable laws.
> > If you are not the intended recipient(s), any use of, reliance on,
> > reference to, disclosure of, alteration to or copying of the information
> > for any purpose is prohibited.
> > Any information not related to PTP's official business is solely the
> > author's and does not necessarily represent PTP's view and is not
> > necessarily endorsed by PTP.
> > PTP shall not be liable for any loss or damage caused by viruses
> > transmitted through this e-mail or its attachments.
> > PTP is not responsible for any unauthorised changes made to the
> > information or for any subsequent effects caused as a result of such
> > changes.
> >
> > If you have received this e-mail by error, please notify the sender by
> > replying this email and discard all its contents immediately.
> >
> >
> >
>
> --
> Thanks & Regards,
>
> DILIP KUMAR PANDEY,
> mvp<https://mvp.microsoft.com/en-us/mvp/Dilip%20Kumar%20Pandey-4039851>
>
> MBA,BCA,B.Com(Hons)
> UAE +971 528225509 India +91 9810929744
> dilipandey@gmail.com, dilipandey@yahoo.com
>
> Skype: dilipandey | Gtalk: dilipandey | Yahoo: dilipandey
>
> [Non-text portions of this message have been removed]****
>
> ****
>
> Disclaimer: This e-mail and any attachment(s) hereto is only for the use
> of the intended recipient(s) and may contain information that is
> confidential and/or privileged under applicable laws.
> If you are not the intended recipient(s), any use of, reliance on,
> reference to, disclosure of, alteration to or copying of the information
> for any purpose is prohibited.
> Any information not related to PTP's official business is solely the
> author's and does not necessarily represent PTP's view and is not
> necessarily endorsed by PTP.
> PTP shall not be liable for any loss or damage caused by viruses
> transmitted through this e-mail or its attachments.
> PTP is not responsible for any unauthorised changes made to the
> information or for any subsequent effects caused as a result of such
> changes.
>
> If you have received this e-mail by error, please notify the sender by
> replying this email and discard all its contents immediately.
>
>
>
--
Thanks & Regards,
DILIP KUMAR PANDEY,
mvp<https://mvp.microsoft.com/en-us/mvp/Dilip%20Kumar%20Pandey-4039851>
MBA,BCA,B.Com(Hons)
UAE +971 528225509 India +91 9810929744
dilipandey@gmail.com, dilipandey@yahoo.com
Skype: dilipandey | Gtalk: dilipandey | Yahoo: dilipandey
[Non-text portions of this message have been removed]
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (14) |
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar