Re: $$Excel-Macros$$ How to use data of one column by identifying available parentheses ) (

Hi David, A sample file has been shared with you Regards Shekhar Sharma On Wed, Aug 8, 2012 at 4:45 PM, David Grugeon da...@grugeon.com.au wrote: Post a sheet with a sample of the data (at least 20 rows). then we can test our formulae. On 8 August 2012 20:35, Shekhar Sharma shekhar1

Re: $$Excel-Macros$$ How to use data of one column by identifying available parentheses ) (

David, I will share that with you shortly. On Wed, Aug 8, 2012 at 4:45 PM, David Grugeon da...@grugeon.com.au wrote: Post a sheet with a sample of the data (at least 20 rows). then we can test our formulae. On 8 August 2012 20:35, Shekhar Sharma shekhar1...@gmail.com wrote: Guyz, Can

Re: $$Excel-Macros$$ How to use data of one column by identifying available parentheses ) (

and apply the same formula.. Else try this... =RIGHT(A1,LEN(A1)-IF(ISERROR(FIND((,A1,2)),LEN(A1),FIND((,A1,2)))B9IF(LEN(C9)NOT(ISERROR(FIND(),C9,1))),LEFT(C9,FIND(),C9,1)-1),) Regards RS. On 8 August 2012 16:00, Shekhar Sharma shekhar1...@gmail.com wrote: ) -- Join official facebook

Re: $$Excel-Macros$$ How to use data of one column by identifying available parentheses ) (

),) On 7 August 2012 16:48, Shekhar Sharma shekhar1...@gmail.com wrote: Hi Friends I am struggling with one problem and need your help. I have three columns available like: *Column A* *Column B* *Column C* 92683 (1 18067.0 1) (8625.11) 1) Now I would like to have a formula

Re: $$Excel-Macros$$ How to use data of one column by identifying available parentheses ) (

)FIND(),C1,1), LEFT(C1,FIND(),C1,1)-1),) On 7 August 2012 16:48, Shekhar Sharma shekhar1...@gmail.com wrote: Hi Friends I am struggling with one problem and need your help. I have three columns available like: *Column A* *Column B* *Column C* 92683 (1 18067.0 1) (8625.11) 1

Re: $$Excel-Macros$$ How to use data of one column by identifying available parentheses ) (

Guyz, Can you suggest a VBA code for the same, as I think no formula is working. I have lots of row and multiple of conditions Regards Shekhar Sharma On Wed, Aug 8, 2012 at 4:03 PM, Shekhar Sharma shekhar1...@gmail.comwrote: Sorry David, Its not working. On Tue, Aug 7, 2012 at 5:58 PM

$$Excel-Macros$$ How to use data of one column by identifying available parentheses ) (

with formula. -- Shekhar Sharma 9910010060 Life consists not in holding good cards but in playing those you hold well Before you judge another, think of your own last mistake. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members

Re: $$Excel-Macros$$ NEW RULE : No more job postings in this forum.

Welcome, your decision. However I would request you to allow Job openings related with Excel, VBA else Can we have our signatures include Searching for Job (in any of the member is looking for job)? Regards Shekhar Sharma On Sun, May 20, 2012 at 8:24 PM, Ayush Jain jainayus...@gmail.com wrote

Re: $$Excel-Macros$$ Defining Same Name For ranges available in multiple tabs

or defined names or with a macro. Provide a file and your desires. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com *From:* Shekhar Sharma shekhar1...@gmail.com *Sent:* Friday, May 11, 2012 4:59 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Defining

Re: $$Excel-Macros$$ Defining Same Name For ranges available in multiple tabs

[mailto: excel-macros@googlegroups.com] *On Behalf Of *Shekhar Sharma *Sent:* 14 May 2012 5:46 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Defining Same Name For ranges available in multiple tabs ** ** Thanks guys, it got resolved with the suggestion of =SUMIF

Re: $$Excel-Macros$$ Passing Values Between UserForms

first. Regards Sam Mathai Chacko On Fri, May 11, 2012 at 3:14 PM, Shekhar Sharma shekhar1...@gmail.com wrote: Is it possible to pass Values between UserForms? If so, what's the syntax for doing it? Let's say I'm using this code Private Sub CmdContinue_Click() Dim

Re: $$Excel-Macros$$ Interview Questions with Answers (Excel+VBA+Access+SQL Server)

Thanks so much for sharing these documents Shekhar Sharma On Fri, May 11, 2012 at 11:53 AM, Nitin Updhyay nitinupadhyay2...@gmail.com wrote: Thanks NOORAIN ANSARI Asa rossoff On Fri, May 11, 2012 at 11:47 AM, Asa Rossoff a...@lovetour.info wrote: Thank you Noorain for sharing those. I

$$Excel-Macros$$ Defining Same Name For ranges available in multiple tabs

. In my summary tab, I'd like a formula such as =SUMIF(WBS,A1,COST)...but of course this doesn't work. Any ideas on how I can solve this? -- Shekhar Sharma Life consists not in holding good cards but in playing those you hold well Before you judge another, think of your own last mistake. -- FORUM

$$Excel-Macros$$ Getting last column value via Vlookup in excel

. I've tried various combinations of MATCH, VLOOKUP and INDEX but I'm not really familiar enough with those functions to make it work. Any suggestions? Example: Sheet1 Col AColB Shekhar Sharma Sheet2 ColAColB ColC ColD Shekhar 15 2021

Re: $$Excel-Macros$$ Getting last column value via Vlookup in excel

, 2012 at 5:45 PM, Shekhar Sharma shekhar1...@gmail.comwrote: Hey guys, First of all thanks so much for helping me with resolutions. I have two sheets within an excel spreadsheet and I need to lookup a name from the first sheet and pull data through from the second sheet. I need the last

Re: $$Excel-Macros$$ Replacement of Lookup function

Thanks Asa, You rock man. Regards Shekhar Sharma On Thu, May 10, 2012 at 3:13 AM, Asa Rossoff a...@lovetour.info wrote: Hi Shekhar, Well, the prupose of the formula is, in the end, to lookup a text value based on an input value. This is best accomplished with a lookup function

Re: $$Excel-Macros$$ Rounding value of six digit

Asa and Maries, Thanks so much for providing the formulas. I was looking for the same kind of formulas. Thanks Shekhar Sharma On Sat, May 5, 2012 at 6:26 PM, Maries talk2mar...@gmail.com wrote: Try this too, =QUOTIENT(A1,1000)*1000 On Sat, May 5, 2012 at 5:47 AM, Maries talk2mar

Re: $$Excel-Macros$$ need Macro

Hi Chetan, You can create a log tab in your workbook and place the code in This workbook section of that excel on Close event to update that log with username and time. Regards Shekhar Sharma On Mon, May 7, 2012 at 1:25 AM, B.N.Chethan Kumar chetankumar1...@gmail.com wrote: Dear Excel Gurus

Re: $$Excel-Macros$$ Problem to filter in pivot table

Hi Ashish, In the pivot you can add one more entry of Stock in row as well De-select 0 and then remove Stock from row again. I think this is what you are looking for. Regards Shekhar Sharma On Tue, Apr 24, 2012 at 10:04 AM, Ashish Bhalara ashishbhalar...@gmail.comwrote: Dear expert, I

Re: $$Excel-Macros$$ Re: Help needed- Converting JPG format file to Excel file via VBA

Hi Thanks for the link, however is it possible to do this job via VBA? Regards Shekhar Sharma On Fri, Apr 20, 2012 at 8:33 PM, ChilExcel chilexcel...@gmail.com wrote: Please see http://www.minipdf.com/ I tried it and it works fine ...jpg at xls Chilexcel 2012/4/20 Shekhar Sharma

$$Excel-Macros$$ Help needed- Converting JPG format file to Excel file via VBA

Hi All, I have one JPG/Png/Gif format file, is there any way where i can convert this JPG format file to Excel file to make some changes? your reply will be greatly appriciated. -- Shekhar Sharma 9910010060 Life consists not in holding good cards but in playing those you hold well Before

Re: $$Excel-Macros$$ Re: Urgent - Pivot table

Hi, Can you provide the dummy data, as provided data is not the complete one, it seems you have provided pivot table data. Regards Shekhar Sharma On Fri, Apr 20, 2012 at 3:28 PM, Soni.Rajender soni.rajen...@gmail.comwrote: Dear Team Thanks for the reverts. Please find attached the file

Re: $$Excel-Macros$$ Re: Help needed- Converting JPG format file to Excel file via VBA

convert available information of the JPG/gif/PNG in excel for further changes as I don't want to prepare the excel again and then print. I want to use the scanned image for the correction. Thanks Shekhar Sharma On Fri, Apr 20, 2012 at 2:55 PM, Kris krishnak...@gmail.com wrote: See: http

Re: $$Excel-Macros$$ Help on inputbox

Try this, Private Sub updatemonth() Sheets(Brand).Range(C1).Select If ActiveCell.Value = Then Do Until ActiveCell.Value = Total ActiveCell.Value = Month i want ActiveCell.Offset(1, 0).Select Loop Else MsgBox No job to run End If End Sub Regards Shekhar Sharma On Wed, Aug 31, 2011 at 11:14

Re: $$Excel-Macros$$ HELP to create popup alert in Excel

for other Script names as well by following the same method or change the msg or change the value. Regards Shekhar Sharma On Fri, Apr 20, 2012 at 3:58 PM, Ketan research.ke...@gmail.com wrote: Dear Members, ** ** Here I have attached Excel file in which the data is live streaming from

Re: $$Excel-Macros$$ INCOME TAX SOFTWARE

For that you have to google the available softwares and their functionality. Regards Shekhar Sharma On Fri, Apr 20, 2012 at 6:23 PM, Tarun Mondal tarunmondal1...@gmail.comwrote: sir, i want a income tax calculating software using excel bywhich i can calculate tax and take return querterly

Re: $$Excel-Macros$$ remove a certain text from every sentence

Using: [image: image.png] would be a great and dynamic way. Shekhar Sharma 9910010060 On Thu, Nov 10, 2011 at 8:45 PM, Mukesh Kumar Jha mukeshconsci...@gmail.com wrote: ** Hi Smitha, Try below formula =RIGHT(A1,LEN(A1)-FIND(:,A1)) Thanks Mukesh - Original Message - *From

$$Excel-Macros$$ Re: Problem on opening an XLS file.

. it becomes inactive . Manual is active. Naturally no calculation is done. every time as an when the xls file is opened ,, I am to clik on exl option - then activate the auto calculation tab then ok .. Kindly help how these problems can be solved ? -- Shekhar Sharma

$$Excel-Macros$$ Re: Can any one resolve this?????

. Hope i will get the response from this group. Regards, Hemant Shah -- Shekhar Sharma 9910010060 Life consists not in holding good cards but in playing those you hold well Before you judge another, think of your own last mistake

$$Excel-Macros$$ Can somebody help me to solve this query in Ms-excel

All requirements are given in the excel attached in the mail Kindly help me to solve the same -- Shekhar Sharma 9910010060 Life consists not in holding good cards but in playing those you hold well Before you judge another, think of your own last mistake