Re: $$Excel-Macros$$ Problem

pls find the same. On Mon, Jul 5, 2010 at 4:31 PM, neil johnson wrote: > Hi , > > I have problem in this sheet. Please solve it . Please find the attached > sheet > > > Thanks and Regards > > -- > > -- > Some impo

$$Excel-Macros$$ Re: Excel Programming

On 5 Jul., dtenz wrote: > I have name cells A1 to D1 as Number Num1 Num2 and Num3.   What? The cells A1 to D1 contain _four_ values. How do they correspond to Num1, Num2, and Num3? Please be as precise as possible. > Now I have > data in Col A from A1 to around A500 depending on the file.  What I

Re: $$Excel-Macros$$ GNATT CHART

Give search on Google with Filetype:xls, you will get many options... I wish it will work for you. Anand On Tue, Jul 6, 2010 at 10:55 AM, zafnu wrote: > Hi, > Can u please help me to create a '*Gnatt Chart*' in excel. your immediate > action is highly appreciated. > > Thanks & regards > Zafnim

Re: $$Excel-Macros$$ GNATT CHART

the true name is : Gantt Chart see: http://office.microsoft.com/en-us/excel-help/create-a-gantt-chart-in-excel-HA001034605.aspx Tamas > Hi, > Can u please help me to create a '*Gnatt Chart*' in excel. your immediate > action is highly appreciated. > > Thanks & regards > Zafnim backer. > > -- > -

Re: $$Excel-Macros$$ Running Count for particular data

Good! On Tue, Jul 6, 2010 at 8:55 AM, WizExcel wrote: > This is just too good Ayush , > thanks for the explanation. > > > On Jul 5, 8:16 pm, Ayush wrote: > > Thanks Ankit. > > As the running count was required, The formula should have running > > range. I have used Row f(x) to return the curren

$$Excel-Macros$$ GNATT CHART

Hi, Can u please help me to create a '*Gnatt Chart*' in excel. your immediate action is highly appreciated. Thanks & regards Zafnim backer. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips

Re: $$Excel-Macros$$ Running Count for particular data

This is just too good Ayush , thanks for the explanation. On Jul 5, 8:16 pm, Ayush wrote: > Thanks Ankit. > As the running count was required, The formula should have running > range. I have used Row f(x) to return the current row number and used > the indirect f(x) to convert the test string in

$$Excel-Macros$$ How to automatically refresh a pivot table

Hi, I am pulling in data from a SQL Server database into a worksheet (Sheet1) and then trying to cause a pivot table to automatically update on another sheet (Sheet2) once the data in Sheet1 exists. However, I get the following error: 'Error # 1004: The pivot table field name is not valid. To crea

$$Excel-Macros$$ Protecting cells

Is there a way to make sure the data in certain cells cannot be changed without Protecting the worksheet?  We have data that is received from our customer that I would like to ensure stays intact.  Certain portions of the worksheet/workbook that the data is stored in needs to be modified by ou

Re: $$Excel-Macros$$ Need index match

I made some changes thanks to your suggestion in your vlookup formula.  I got it to work with the index,match.  Thank you!! From: Nadine S To: excel-macros@googlegroups.com Sent: Mon, July 5, 2010 10:01:20 AM Subject: Re: $$Excel-Macros$$ Need index match

Re: $$Excel-Macros$$ Need index match

VLOOKUP doesn't work because the data won't always be in order and it also takes up too much memory for this file as it's already extremely large.  I need the index,match formula.  Thank you though.  I appreciate the attempt. Nadine From: Fabio Lemos To: exce

Re: $$Excel-Macros$$ Running Count for particular data

Thanks Ayush On Mon, Jul 5, 2010 at 8:46 PM, Ayush wrote: > Thanks Ankit. > As the running count was required, The formula should have running > range. I have used Row f(x) to return the current row number and used > the indirect f(x) to convert the test string into range. > The two function

Re: $$Excel-Macros$$ Re: Running Count for particular data

Thanks Aindril , However the countif is not working correctly for my case, for instance , in the file you have sent check Sr. No. 5 of the Punjab National Bank --- there the Count Should be 1 as Punjab National Bank is appearing for the first time and so on. On Jul 5, 9:05 pm, Aindril De wro

Re: $$Excel-Macros$$ Running Count for particular data

Thanks Ayush , really appreciate the quick response On Jul 5, 7:26 pm, ayush jain wrote: > Hi Wizexcel, > > Attached is the solution. You have to use the combination of countif, > indirect and row function. > > The formula is :- *=COUNTIF(INDIRECT("$A$2:$A$" & ROW(A2)),A2)* > > Please let us know

Re: $$Excel-Macros$$ Re: Running Count for particular data

Hi Sameer, PFA the solution, Regards, Aindril On Mon, Jul 5, 2010 at 6:00 PM, Sameer Wagh wrote: > I want avoid sorting the data as far as possible . > > thanks > > > On Mon, Jul 5, 2010 at 5:49 PM, WizExcel wrote: > >> Dear Experts, >> >> want to know if there is way / function for having a

Re: $$Excel-Macros$$ Running Count for particular data

Thanks Ankit. As the running count was required, The formula should have running range. I have used Row f(x) to return the current row number and used the indirect f(x) to convert the test string into range. The two functions returns the running range and countif formula is used to count the values

Re: $$Excel-Macros$$ Running Count for particular data

Hi Ayush, This formula is perfect. I would appreciate if you would pls. explain it. Thanks, Ankit On Mon, Jul 5, 2010 at 7:56 PM, ayush jain wrote: > Hi Wizexcel, > > Attached is the solution. You have to use the combination of countif, > indirect and row function. > > The formula is :- *=CO

Re: $$Excel-Macros$$ Running Count for particular data

Hi Wizexcel, Attached is the solution. You have to use the combination of countif, indirect and row function. The formula is :- *=COUNTIF(INDIRECT("$A$2:$A$" & ROW(A2)),A2)* Please let us know if any further assistance is required. Best regards, Ayush Jain Group Manager On Mon, Jul 5, 2010 at

$$Excel-Macros$$ Re: Running Count for particular data

I want avoid sorting the data as far as possible . thanks On Mon, Jul 5, 2010 at 5:49 PM, WizExcel wrote: > Dear Experts, > > want to know if there is way / function for having a "running" count > in Excel. I have tried COUNTIF and most of the Count Functions , but > all give "total" count and

Re: $$Excel-Macros$$ Urgent help....

Hi Ankit, Please find the attached solved file. Column highlighted with yello color has the solution as requested. Thanks, Deepak On Mon, Jul 5, 2010 at 5:59 PM, Ankit Chandna wrote: > Hi, > > > hi to all ..i need a help PFA and help me to get reqired result. > > Regards, > Ankit > > -- > > ---

Re: $$Excel-Macros$$ Urgent help....

Hi find attach sheet. On Mon, Jul 5, 2010 at 5:59 PM, Ankit Chandna wrote: > Hi, > > > hi to all ..i need a help PFA and help me to get reqired result. > > Regards, > Ankit > > -- > > -- > Some important links for ex

Re: $$Excel-Macros$$ Urgent help....

check the attachment =A2&","&B2 regards ashish koul http://akoul.blogspot.com/ On Mon, Jul 5, 2010 at 5:59 PM, Ankit Chandna wrote: > Hi, > > > hi to all ..i need a help PFA and help me to get reqired result. > > Regards, > Ankit > > -- > > ---

$$Excel-Macros$$ Running Count for particular data

Dear Experts, want to know if there is way / function for having a "running" count in Excel. I have tried COUNTIF and most of the Count Functions , but all give "total" count and not the "Running" Count. Example: See below. The Count for HDFC Bank should be 1, 2 . and then finally 3. and the

$$Excel-Macros$$ graph to shape ?

Hi to all ! I'm wondering if it is possible to set à graph to a shape in vba ? Thx for your help -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exc

$$Excel-Macros$$ Urgent help....

Hi, hi to all ..i need a help PFA and help me to get reqired result. Regards, Ankit -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip

Re: $$Excel-Macros$$ Help needed

Hi Thanks a lot Aindril, the problem is solved. Regards Rajender Soni On Jul 5, 4:00 pm, "C.G.Kumar" wrote: > Please attach sample file. > > On Mon, Jul 5, 2010 at 2:43 PM, Rajender Soni wrote: > > > > > Hi > > > Pls revert to the issue below: > > > My rown no. is fixed - 5, column no. is cha

Re: $$Excel-Macros$$ Cell Capacity & filters

Sorry for the Typo please read "text filter with Containg option" as"custom text filter with * contains* option" Regards, Andy On Mon, Jul 5, 2010 at 5:59 PM, Aindril De wrote: > Hi Iqbal, > > I don't know the way out. > However, though it does not show up because of its length, you can still d

Re: $$Excel-Macros$$ Cell Capacity & filters

Hi Iqbal, I don't know the way out. However, though it does not show up because of its length, you can still do a text filter with Containg option and search for something unique in that string to show that up in the result. Regards, Andy On Mon, Jul 5, 2010 at 5:04 PM, Iqbal Muneeb wrote: > H

Re: $$Excel-Macros$$ Excel Programming

Hi Dtenz, I think this task can easily be done by using Excel formulas. Attached is the sheet for your reference. Please let us know if you need further assistance. Best regards, Ayush Jain Group Manager On Mon, Jul 5, 2010 at 3:41 PM, dtenz wrote: > Hi, > > I am new to excel programming. I

$$Excel-Macros$$ Cell Capacity & filters

Hi Dear ones. I need help. Cells have a capacity of 255 characters, beyond which filters do not work. Is there a wayout. I have a file where certain cells have very long strings; they donot show up in the filter. Please guide me. Thanks. -- Have a good day! Muneeb Cell: 0300 2213043 -- --

Re: $$Excel-Macros$$ Help needed

Please attach sample file. On Mon, Jul 5, 2010 at 2:43 PM, Rajender Soni wrote: > Hi > > Pls revert to the issue below: > > My rown no. is fixed - 5, column no. is changing, now i want that suppose i > click in column g, then i will get the cell value of G5, if i click on > column a, anywhere in

$$Excel-Macros$$ urgent Need Ms-Excel,MS Access & SQL Interview Tips

Dear All, I urgent need Ms-Excel,MS Access & SQL Interview Tips. kindly send all tips for the *MIS position.* Thanks, Prabhakar Thakur New Delhi +919953736776 -- -- Some important links

$$Excel-Macros$$ Excel Programming

Hi, I am new to excel programming. I am having a little trouble trying to write a small code. If I can do it, it will save me a lot of time as i need to repeat the same procedures for different files. I have name cells A1 to D1 as Number Num1 Num2 and Num3. Now I have data in Col A from A1 to

$$Excel-Macros$$ Problem

Hi , I have problem in this sheet. Please solve it . Please find the attached sheet Thanks and Regards -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter

Re: $$Excel-Macros$$ Help needed

Hi Rajender, Use the following VBA Code: Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim rg As String MsgBox Target.Address & " has been selected" 'displaying the selected cell address rg = Split(ActiveCell.Address, "$")(1) & 5 'getting the column name and createing the range col

$$Excel-Macros$$ Required Help

Hi Frnds, Could plz help me out on this I want to get information from text file - 2nd or 3rd column and paste it to a excel sheet. -- With Regards, Sekhar -- -- Some important links for excel users: 1. Follow

$$Excel-Macros$$ Help needed

Hi Pls revert to the issue below: My rown no. is fixed - 5, column no. is changing, now i want that suppose i click in column g, then i will get the cell value of G5, if i click on column a, anywhere in column a will get the cell value of cell a5. Regards Rajender Soni -- -