Re: $$Excel-Macros$$ Form tracker and new base

*Hi Anil, It was a awesome attempt, and done it, thanks for the same. But i have some again query, Please find the attached file, i have explained it clearly, i have added one more button, please find that. i want seems to be like search engine in the second form. thank you all the experts. *

Re: $$Excel-Macros$$ 2 Values in the same cell

The answer is "No" AFAICS However you could use two columns (one formatted left top and one right bottom). Put borders around the two but no border between them. If you want the gridlines to disappear you can give both cells a fill colour of white. Regards David Grugeon On 16 May 2012 05:44, j

Re: $$Excel-Macros$$ Form tracker and new base

On Wed, May 16, 2012 at 9:53 AM, Deba Ranjan wrote: > *Dear Experts, Waiting for the revert with solution. Thanks > * > > > > Thanks & Regards, > Deba Ranjan P > > > > > -- Forwarded message -- > From: Deba Ranjan > Date: Tue, May 15, 2012 at 10:22 AM > Subject: $$Excel-Mac

Re: $$Excel-Macros$$ Top Three

Hello, Thank you very much. On Tue, May 15, 2012 at 4:14 PM, Krishna Kumar wrote: > Hi > > In G1: 3 > > In H2 and copied down, > > =IF(ROWS(H$2:H2)<=$G$1,LARGE($E$2:$E$7,ROWS(H$2:H2)),"") > > In I2 and copied down, > > > =IF(N(H2),INDEX($A$2:$A$7,SMALL(IF($E$2:$E$7=H2,ROW($E$2:$E$7)-ROW($E$2)+1)

$$Excel-Macros$$ Want to use micros

Hi, I want to sort my data date & name wise can i use micros for that, if yes please help me with the formula. Thanks Reshma -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Prob

Fwd: $$Excel-Macros$$ Form tracker and new base

*Dear Experts, Waiting for the revert with solution. Thanks * Thanks & Regards, Deba Ranjan P -- Forwarded message -- From: Deba Ranjan Date: Tue, May 15, 2012 at 10:22 AM Subject: $$Excel-Macros$$ Form tracker and new base To: excel-macros@googlegroups.com *Hi Experts,

RE: $$Excel-Macros$$ Formula for discount of third item bought by a customer

I sent this out late in the evening, and it seems a problem slipped past my quality control. last minute updates to the formulas messed something up, so please be aware the results are a bit incorrect. I will fix it when I get a chance and repost. It should be in the next couple days. Asa

Re: $$Excel-Macros$$ 2 Values in the same cell

On Wed, May 16, 2012 at 1:08 AM, joseph camill wrote: > Attached is an example > > > On Wed, May 16, 2012 at 12:48 AM, wrote: > >> Hi, >> >> Is it possible to concatenate two values in one cell and seperate the >> first value to top left and second value to bottom right of the same cell. >> >> Fo

Re: $$Excel-Macros$$ 2 Values in the same cell

Attached is an example On Wed, May 16, 2012 at 12:48 AM, wrote: > Hi, > > Is it possible to concatenate two values in one cell and seperate the > first value to top left and second value to bottom right of the same cell. > > For e.g. £25m and €12m both in cell a1. And both are clearly seperate f

$$Excel-Macros$$ 2 Values in the same cell

Hi, Is it possible to concatenate two values in one cell and seperate the first value to top left and second value to bottom right of the same cell. For e.g. £25m and €12m both in cell a1. And both are clearly seperate from each other. Thanks, Joseph Sent on my BlackBerry® from Vodafone --

Re: $$Excel-Macros$$ Top Three

Hi In G1: 3 In H2 and copied down, =IF(ROWS(H$2:H2)<=$G$1,LARGE($E$2:$E$7,ROWS(H$2:H2)),"") In I2 and copied down, =IF(N(H2),INDEX($A$2:$A$7,SMALL(IF($E$2:$E$7=H2,ROW($E$2:$E$7)-ROW($E$2)+1),COUNTIF($H$2:H2,H2))),"") It's an array formula. Confirmed with CTRL + SHIFT + ENTER Kris ExcelFox

Re: $$Excel-Macros$$ ALL EXCEL FORMULA & FUNCTION

Its really valuable material and study file I have ever seen in my life...!!! User friendly Thanks friend !!! U r simply gr8. On Tue, May 15, 2012 at 6:34 PM, danial mansoor wrote: > > dear Noorani, > > do you have material for intermediate level user in which macro and other > material related

$$Excel-Macros$$ Top Three

Hello, Could you please help me in the formula. Please find attached file. Thanks in advacne. Regards, Chandra Shekar B -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem

Re: $$Excel-Macros$$ VLOOKUP HELP NEED

I hate loops :( Sub kTest() Dim r As Long With Range("b2:b" & Range("a" & Rows.Count).End(3).Row) r = .Rows.Count + .Row - 1 .FormulaR1C1 = "=index(r2c[3]:r" & r & "c[3],match(rc[-1],r2c[4]:r" & r & "c[4],0))" .Value = .Value End With End Sub Kris ExcelFox <

RE: $$Excel-Macros$$ ALL EXCEL FORMULA & FUNCTION

dear Noorani, do you have material for intermediate level user in which macro and other material related to advance is not included. plz send me. Date: Tue, 15 May 2012 15:27:57 +0530 Subject: Re: $$Excel-Macros$$ ALL EXCEL FORMULA & FUNCTION From: noorain.ans...@gmail.com To: excel-macros@

$$Excel-Macros$$ Re: VBA Libraries

Try to find C++ Excel Add-in Book online On Tuesday, 15 May 2012 10:51:58 UTC+5:30, kumar wrote: > Hi Guyz, > > I want to learn about VBA libraries (For Eg: linking VBA to other > programming languages like C/C++, writing/editing library functions etc). I > have search a lot online, but coul

Re: $$Excel-Macros$$ How to calculate WPM (Word Per Minute) in Excel (Only for numeric keys)?

At my system its working fine Try to Apply Validation of First cell to all cells , revert me if not working after that Rajan On Tuesday, 15 May 2012 02:21:12 UTC+5:30, Bullet wrote: > @ Ranjan, thanks a lot for all of your effort, but it is not working > properly, only 1st cell is workin

Re: $$Excel-Macros$$ Financial Analysis Dashboard

Not at all. Pls feel free to share Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Ashish Pradhan Sender: excel-macros@googlegroups.com Date: Tue, 15 May 2012 13:58:38 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Financial Anal

Re: $$Excel-Macros$$ Financial Analysis Dashboard

Hello Sanjib, I have managed to download the file. Will email the same to you directly to your email id. I believe the file size is more than 4mb and possibly cannot be sent through the group. I hope Hilary / Group Members / Group Admin do not have any objections to the file being sent direc

Re: $$Excel-Macros$$ Financial Analysis Dashboard

The file is blocking by the antivirous for suspecting virus. regds, Sanjib On Mon, Apr 30, 2012 at 10:07 PM, hilary lomotey wrote: > Hi Guys, > > i just completed my Financial Analysis Dashboard, pls have a look at it at > the address below > > cheers > > http://www.sendspace.com/file/tlim30 >

Re: $$Excel-Macros$$ Help me to generate Report

Deal All, I need your help on the same. Any Confusion plz let me know. Regards, Ankit On Fri, May 4, 2012 at 2:00 PM, Ankit Agrawal wrote: > Dear all, > > I have some data in one sheet and I have to generate report which format > is also on second sheet. How can we generate it. > > Thanks & R