$$Excel-Macros$$ Re: Pls help

I dont think if there is any direct way you can do this , if dont have any blank cells in your data, 1) Select your data 2) Repalce your value to blanks by Checking "Match Entire Cell Contents" in Find Replace dialoge box , 3). Press CTRL+G ( Go to) 4) Press ALT+S (Special) 5) Press K ( Blanks)

$$Excel-Macros$$ Re: Pls Help Me on this

Brother send a sample sheet. On Fri, Oct 19, 2012 at 3:30 PM, अनिल नारायण गवली wrote: > suppose there is one two excel file > one is A > second is B > in A file there is 2 fields like (Shiptocode) and (Productcode). > in B file there is 5 fields like (Shiptocode) and (Productcode)and(Type) > Typ

Re: $$Excel-Macros$$ Re: Pls help me on this.

ly took me longer to write this "rant" than it did to throw > together the code. > > hope this helps get you started. > > > *Paul* > > ----------------- > *“Do all the good you can, > By all the means you can, > In all the ways you ca

$$Excel-Macros$$ Re: Pls help me on this.

Pls somebody help me on this On Monday, October 15, 2012 5:37:44 PM UTC+5:30, अनिल नारायण गवली wrote: > > Dear Groups and Noorian, > > I want a macro that import other worksheets in a excel workbook by using > filedailogbox . > > 1) when filedailogbox opens i have to select the required file a

$$Excel-Macros$$ Re: pls help with matching postal codes

pls help with this-- can you put in the formula? On Mon, May 7, 2012 at 12:09 AM, Sara Lee wrote: > > > -- > > *col i *in Sheet 2 needs to be filled up > > by looking up *col h *in sheet 2 in sheet 1 *col c* value- either exact > or next closest- i.e for every value in col h sheet 2, i

Re: $$Excel-Macros$$ Re: pls help for dis

Please share your sample sheet.. Thanks On Tue, May 8, 2012 at 8:59 AM, rohit patel wrote: > > > On Thu, Apr 16, 2009 at 10:46 AM, rohit patel wrote: > >> i just want to link dis 1 sheet (Vendor April .09 demo) to Receiving >> status(supplier)mar.09 demo, i just want dat if we entered the data

$$Excel-Macros$$ Re: pls help for dis

On Thu, Apr 16, 2009 at 10:46 AM, rohit patel wrote: > i just want to link dis 1 sheet (Vendor April .09 demo) to Receiving > status(supplier)mar.09 demo, i just want dat if we entered the data > in Receiving status(supplier)mar.09 demo the effect should be show in dis > file (Vendor April .09

Re: $$Excel-Macros$$ Re: pls help with sum if formula

Haseeb, *{1,-1}* Your Idea Solid. On Mon, Apr 9, 2012 at 6:41 AM, Haseeb A wrote: > =SUM(SUMIF(G3:G409,{">350",">449"},$D$3:$D$409)*{1,-1}) -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need H

$$Excel-Macros$$ Re: pls help with sum if formula

Hello Lee, One way: =SUM(SUMIF(G3:G409,{">350",">449"},$D$3:$D$409)*{1,-1}) Will sum 351-449. if you want to include 450, change 449 to 450 ___ HTH, Haseeb -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Plea

$$Excel-Macros$$ Re: Pls Help..

Send an email with the subject being what you need help with (title) to: excel-macros@googlegroups.com, and then attach file. On Feb 23, 5:30 am, кαяαηη yα∂αν wrote: > Hi..Experts, > > I need your help.I am unable to attach my file. Pls tell me where > I can attach file. > > Thnx > > Karan -

$$Excel-Macros$$ Re: Pls Help- Div by Zero error

Dear Anup Is it possible to send me the file for me to help you N.SHIVKUMAR Mobile : +919866533180 Office : +914027685310 Res.: +914040035774 Alternate Email: shiv1...@yahoo.com --~--~-~--~~~---~--~~

$$Excel-Macros$$ Re: Pls Help- Div by Zero error

Hi Anup, It is happenning because you are dividing some thing (any number) with Zero. To avoid this, you should use ISERROR function. =If(iserror(your divison formula),"",your divison formula) For better understanding, attach your spreadsheet. Thanks, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons

$$Excel-Macros$$ Re: pls help for maintain MIS

thanx ...definatly i will do this. On Sun, Aug 16, 2009 at 11:14 PM, Dilip Pandey wrote: > > Hi Umesh, > > You can discuss the same, no problem. But I would suggest if you can > go ahead and post the same to the group, marking me in the CC field. > There are many great minds who would also be i

$$Excel-Macros$$ Re: pls help for maintain MIS

Hi Umesh, You can discuss the same, no problem. But I would suggest if you can go ahead and post the same to the group, marking me in the CC field. There are many great minds who would also be intersted to help you out. Group Mail Id:- excel-macros@googlegroups.com Thanks, Dilip Kumar Pandey

$$Excel-Macros$$ Re: pls help- i need to get the column name in the fields

Hi, I wrote this formula for ur purpose. =IF(RANK($A2,$A2:$D2,1)=F$1,$A$1,IF(RANK($B2,$A2:$D2,1)=F$1,$B$1,IF(RANK($C2,$A2:$D2,1)=F$1,$C$1,$D$1))) See the attached sheet for reference. Let me know if this helps. On Sat, May 9, 2009 at 8:53 PM, subs wrote: > > ca1 ca2 ca3 ca4 > > > 12 123 1 2

$$Excel-Macros$$ Re: Pls help me..

Please find attached the file.. there are 2 ways it can be done and both the formulas are in the file.. Ajit From: excel-macros@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of ram bhagath Sent: Tuesday, November 04, 2008 6:27 PM To: excel-macros@googlegroups.com Subject: $$Excel-Mac

$$Excel-Macros$$ Re: Pls help me..

Dear Ram Use Pivot Table, it is simpler then vlookup Regards On Tue, Nov 4, 2008 at 11:57 PM, ram bhagath <[EMAIL PROTECTED]> wrote: > Hi all,, > > I have attached the file, and explained the proble there only. I wanted to > pick amount from another table by formula. I tried with vlookup i di

$$Excel-Macros$$ Re: Pls help me..

Hi, Probably you cannot find any proper formula for your problem. Following function may help you. [tools->Macro->visual basic editor] will get you to macro editor [insert-> module] and copy paste the following function. You need to see how the function is used as formula in the attached file. '--

$$Excel-Macros$$ Re: Pls help me..

Hi, Check the attached XL to see if it does what you need. Regards - Dave. Date: Tue, 4 Nov 2008 18:27:22 +0530From: [EMAIL PROTECTED]: [EMAIL PROTECTED]: $$Excel-Macros$$ Pls help me.. Hi all,, I have attached the file, and explained the proble there only. I wanted to pick amount from ano

$$Excel-Macros$$ Re: Pls help me..

Hi Ram, Solution is attached herewith in EXCEL. Use of Pivot table may give you this solution. Regards, Hitesh Dhare +919824004308 New * Email ID: [EMAIL PROTECTED] From: excel-macros@googlegroups.com [mailto:[EMAIL PROTEC

$$Excel-Macros$$ Re: Pls help me..

Chk attached file Regards Harish Upadhyay On 11/4/08, ram bhagath <[EMAIL PROTECTED]> wrote: > > Hi all,, > > I have attached the file, and explained the proble there only. I wanted to > pick amount from another table by formula. I tried with vlookup i didnt get > answer. Pls help me. > > Reg

$$Excel-Macros$$ Re: Pls Help

Use this, but change from currency format. ' ' Main Function * ' Function SpellNumber(ByVal MyNumber) Dim shillings, Cents, Temp Dim DecimalPlace, Count ReDim Place(9) As String Place(2) = " Thousand

$$Excel-Macros$$ Re: Pls Help

Try the attached file. -Original Message- From: excel-macros@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Sleek Sent: Sunday, September 14, 2008 6:19 PM To: MS Excel & VBA Macros Subject: $$Excel-Macros$$ Re: Pls Help Yes it possible, but there is macro for it. the num

$$Excel-Macros$$ Re: Pls Help

Yes it possible, but there is macro for it. the numbers can go into billions to. But there is NO formula for it. Let me find the macro and give it to you. On Sep 13, 12:54 pm, "ankit varshney" <[EMAIL PROTECTED]> wrote: > Is it possible to convert any number in text. > > For Example if i ente

$$Excel-Macros$$ Re: Pls Help

Try this Link http://www.meadinkent.co.uk/xlnumberstext.htm Baloo On Sat, Sep 13, 2008 at 3:24 PM, ankit varshney <[EMAIL PROTECTED] > wrote: > Is it possible to convert any number in text. > > For Example if i entered 500 then by any folmula can excel can give output > of five thousend. > > --

$$Excel-Macros$$ Re: Pls Help

I also require this formula. On Sat, Sep 13, 2008 at 3:24 PM, ankit varshney <[EMAIL PROTECTED] > wrote: > Is it possible to convert any number in text. > > For Example if i entered 500 then by any folmula can excel can give output > of five thousend. > > -- > Ankit Varshney > 9210639227 > > > >