Re: $$Excel-Macros$$ extracting numbers

Have not seen the workbook but you can modify the formula as below to extract everything after "_POV_" =MID(A1,FIND("_POV_",A1)+5,Len(A1)-FIND("_POV_",A1)+5) Thanks, Upendra Singh +91-9910227325 On Thu, May 5, 2016 at 11:43 AM, Abhishek Jain wrote: > In all but one of your examples, the number

Re: $$Excel-Macros$$ Re: Query Excel File

Hi Ayush, This doesn't help. I've got the correct code: "Select Distinct [Market] from [Sheet1$A1:D5000]" or "SELECT DISTINCT [Column Heading] FROM TableName ORDER BY [ColumnHeading];", (¨`·.·´¨) Keep `·.¸(¨`·.·´¨) Smiling !! (¨`·.·´¨)¸.·´ Upendra Singh `·.¸.·´9910227325 On 23 December 2010 2

$$Excel-Macros$$ Query Excel File

Hello Friends, Below is a snapshot of code I use to query any excel worksheet having tabular data. Do somebody have idea how to query excel file if i need distinct value from a particular column or I want to use some type of query like updated? ***

Re: $$Excel-Macros$$ MACRO's

Hi Vebhav, Nothing is wrong in below code but if you want to select 3rd row from current row, you should add one line to below code: Row(Z).select. (¨`·.·´¨) Keep `·.¸(¨`·.·´¨) Smiling !! (¨`·.·´¨)¸.·´ Upendra Singh `·.¸.·´9910227325 On 20 December 2010 13:27, vebhav jain wrote: > Hi All, >

$$Excel-Macros$$ welcome to order 2010.11.20.11.10.26

Hi Im ahmed saber. these days i bought 3 iphone 4G from a website : www.ebay365.org and i get the very great price and quality products from them . i want to introduce it to you . when you went their website and tell them my name ahmed saber . you will get a very great discount . the website is ww

Re: $$Excel-Macros$$ Excel VBA Macros eBook ..Absolutely FREE worth $45

it > > > > On Tue, Nov 9, 2010 at 3:03 PM, Upendra Singh Sengar < > upendrasinghsen...@gmail.com> wrote: > >> Hi Ayush, >> >> What is the password to opent the file. >> (¨`·.·´¨) Keep >> `·.¸(¨`·.·´¨) Smiling !! >> (¨`·.·´¨)¸.·´ Upendra S

Re: $$Excel-Macros$$ Excel VBA Macros eBook ..Absolutely FREE worth $45

Hi Ayush, What is the password to opent the file. (¨`·.·´¨) Keep `·.¸(¨`·.·´¨) Smiling !! (¨`·.·´¨)¸.·´ Upendra Singh `·.¸.·´9910227325 On 8 November 2010 19:35, Ayush wrote: > Dear Group Members, > > Good news for all of you !! > > Now you can download VBA macros ebook worth $45 for free. > >

Re: $$Excel-Macros$$ Excel quiz

power means power function... (¨`·.·´¨) Keep `·.¸(¨`·.·´¨) Smiling !! (¨`·.·´¨)¸.·´ Upendra Singh `·.¸.·´9910227325 On 22 September 2010 18:15, Upendra Singh Sengar < upendrasinghsen...@gmail.com> wrote: > Mathmatically if a raise to power b is c > then > a=C raise to power 1/B

Re: $$Excel-Macros$$ Excel quiz

Mathmatically if a raise to power b is c then a=C raise to power 1/B b=C raise to power 1/A but power is not working is excel properly... (¨`·.·´¨) Keep `·.¸(¨`·.·´¨) Smiling !! (¨`·.·´¨)¸.·´ Upendra Singh `·.¸.·´9910227325 On 22 September 2010 17:55, Ayush wrote: > > Dear Group, > > A small

$$Excel-Macros$$ Re: vLOOKUP

Use Hlookup instead On 16/07/2009, Manoj Kukrej wrote: > > hI > Can we look for fist column in **1**))>> vlookup(e3,r4:y4,1,0) > > Regards > > manoj > > -- > *From:* excel-macros@googlegroups.com [mailto: > excel-mac...@googlegroups.com] *On Behalf Of *Dilip Pandey

$$Excel-Macros$$ Re: Cell reference

Use =indirect(b1&c1) On 5/6/09, Yu wrote: > > > Hi dear all, > >For instance, I wanna D1 refers to A1,so D1 has the value 10 as A1 > has. Now B1 has value"A", and C1 has value "1", I want D1 has the > formula "=A1" > >It doesn't work when I type "=B1&C1" in D1... Can anyone gives > some