RE: $$Excel-Macros$$ Number sequentially, skipping blank cells

Hi, Have a look at the attached. I've started with just '1' in the first cell, then a formula after that, copied down to about row 30. Copy it down as far as you need. The appropriate sequential number will appear when you enter data into Col B cells. It is also self-correcting if you delete da

Re: $$Excel-Macros$$ Re: Number sequentially, skipping blank cells

please check this formula (written in A2) =IF(A1=COUNTA($B$2:B2),"",COUNTA($B$2:B2)) best regards, On Fri, Jan 7, 2011 at 1:06 PM, Rahul Gandhi wrote: > Can you please let us know what exactly you require in output > > On Jan 7, 4:01 am, scoobysnack88 wrote: > > Does anyone have a formula or

Re: $$Excel-Macros$$ Copy files in folder except one file

Hi Paul, Your recommendation solved my problem. I removed the If statement in the loop and also replaced this line: Do While excelFile <> "" with this: Do While ucase(excelFile) <> ucase("Combined manual timesheets.xls") and it works perfectly. Thanks a lot for your help. Na

Re: $$Excel-Macros$$ Copy files in folder except one file

Thanks Ashish. I did what you recommended and it considers the if result to be true so goes through the all lines. I added watch for excelFile and it shows me "Combined Manual Timesheet.xls" at the bottom of the page. I am not sure why it does not recognize that in the if statement. Thanks, Nasi

$$Excel-Macros$$ Re: Number sequentially, skipping blank cells

Can you please let us know what exactly you require in output On Jan 7, 4:01 am, scoobysnack88 wrote: > Does anyone have a formula or vbs to accomplish the sequential > numbering as listed here?  The rows with no information would get a > nill and the next cell would not break the number sequence

Re: $$Excel-Macros$$ Copy files in folder except one file

Hi Paul, Your recommendation solved my problem. I removed the if statement I had and replace this line: Do While excelFile <> "" with this Thanks a lot for your help. Nasim On Jan 6, 6:38 am, Paul Schreiner wrote: > I don't see where you're setting the variable: excelFile > > in the Editor

Re: $$Excel-Macros$$ Help Required

Hi Ashish, ur macro function is awesome man... this can help me in those cases where we have large string.. :)) Hi Kantilal, pasted below is another formula through which can fulfill the same requirement... =SUBSTITUTE(TRIM(B4 & " " & C4 & " " & D4 & " " & E4 & " " & F4 & " " & G4 & " " & H4 & "

$$Excel-Macros$$ Re: How do I find the highest of the most repeating values in a list of numbers ie. the max of the modes

=MAX(MODE(A2:A12)) works in Excel 2007. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedi

$$Excel-Macros$$ Number sequentially, skipping blank cells

Does anyone have a formula or vbs to accomplish the sequential numbering as listed here? The rows with no information would get a nill and the next cell would not break the number sequence. 1 5t67 2 g786 3 1234r 4 ty765 5 24567u 6 78ytr89 7 56ytre 8

Re: $$Excel-Macros$$ How do I find the highest of the most repeating values in a list of numbers ie. the max of the modes

Thanks so much Paul. I really do need a single formula to do it but again, I'm so impressed with the assistance you and others have given me on this forum. I've actually reorganised my base data as a workaround so the need has passed but I've kept a copy of this code for future reference. Thanks

$$Excel-Macros$$ Pausing to allow calculation

Hello everyone, I have a loop in which at one point i need to draw data in via a Bloomberg terminal. This always takes a few seconds to achieve this. Without any pause, the operation is not completed before the next step (which is to copy and paste special the data somewhere else) goes ahead. This

Re: $$Excel-Macros$$ How do I find the highest of the most repeating values in a list of numbers ie. the max of the modes

thanks Ashish, really appreciated. > >From: ashish koul >To: excel-macros@googlegroups.com >Sent: Thu, 6 January, 2011 11:50:17 AM >Subject: Re: $$Excel-Macros$$ How do I find the highest of the most repeating >values in a list of numbers ie. the max of the modes > > >its array formula so u hav

Re: $$Excel-Macros$$ How to get the system name using macro

is this how you name your computer ? On Thu, Jan 6, 2011 at 3:47 PM, Daniel wrote: > Hi, > > MsgBox Environ("computername") > > Regards. > > Daniel > > -Message d'origine- > De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] > De > la part de Rajesh K R > Envoyé :

Re: $$Excel-Macros$$ Re: How to get the system name using macro

You can choose whichever cell you'd like and insert the following formula. =ReturnComputerName() On Jan 6, 12:24 pm, Rajesh K R wrote: > Hi > Thanks for the mail, let me know one thing how can get the result in > sheet 1! range"A1" > Regards > Rajesh kainikkara > > On 1/6/11, JsinSk wrote: >

Re: $$Excel-Macros$$ Help Required

check the attachement On Thu, Jan 6, 2011 at 7:49 PM, Kantilal Badale wrote: > Dear Friends, > > Please suggest solution for attached file > > Thanks > > Kantilal > > -- > > -- > Some important links for excel users

RE: $$Excel-Macros$$ How to get the system name using macro

Hi, MsgBox Environ("computername") Regards. Daniel -Message d'origine- De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De la part de Rajesh K R Envoyé : jeudi 6 janvier 2011 16:14 À : excel-macros Objet : $$Excel-Macros$$ How to get the system name using macro

Re: $$Excel-Macros$$ Re: How to get the system name using macro

Hi Thanks for the mail, let me know one thing how can get the result in sheet 1! range"A1" Regards Rajesh kainikkara On 1/6/11, JsinSk wrote: > Private Declare Function GetComputerName Lib "kernel32" _ > Alias "GetComputerNameA" _ > (ByVal lpBuffer As String, nSize As Long) As Long > > >

$$Excel-Macros$$ Re: How to get the system name using macro

Private Declare Function GetComputerName Lib "kernel32" _ Alias "GetComputerNameA" _ (ByVal lpBuffer As String, nSize As Long) As Long Function ReturnComputerName() As String Dim rString As String * 255, sLen As Long, tString As String tString = "" On Error Resume Next sLen =

$$Excel-Macros$$ Microsoft Excel Keyboard Shortcut Bible - FREE

Dear group, I hope you are aware of our page on facebook where we keep sharing tips, tricks, macros and free ebooks as well. The Page has 216 members only. In order to promote our discussexcel.com page, We have published a Keyboard Shortcut Bible (By John Franco) of Microsoft Excel. Like our

Re: $$Excel-Macros$$ How to count distinct values on the base of multiple criteria

can somebody please transfer it to 2003 version? I don't have 2007 in my company. On Jan 6, 9:40 am, Dave Bonallack wrote: > Hi Kalyan, > The attached works, with the following limitations: > That the data in Col A is always the same (as in your sample data) > That any given BP Name is not repeat

$$Excel-Macros$$ How to get the system name using macro

Hi Experts How can I get the the computer name on which the macro is running. Regards Rajesh kainikkara -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter

Re: $$Excel-Macros$$ Understand macro code in timesheet

What version of Excel are you using? Is it the "spreadsheet" application that used to come with Windows rather than an msOffice application? WAY back in Excel version... 4? they didn't use a VBA editor. Instead, you created a sheet called "macro#" and wrote your scripting there. It wasn't really V

RE: $$Excel-Macros$$ How to count distinct values on the base of multiple criteria

Hi Kalyan, The attached works, with the following limitations: That the data in Col A is always the same (as in your sample data) That any given BP Name is not repeated in more than 1 Depot (as in your sample data) If either of the above limitations are unacceptable, then it's back to the drawin

Re: $$Excel-Macros$$ Copy files in folder except one file

I don't see where you're setting the variable: excelFile in the Editor, set a breakpoint at the statement: Do While Excelfile <> "" and step through. and watch the Excelfile Variable does ever equal "Combined Manual Timesheets.xls"? I would use: If ucase(excelFile) <> ucase("Combined Manual Ti

Re: $$Excel-Macros$$ prevent copying xl files

Hi Prashant Thanks for ur mail.I think u have a good idea about this issue.I don't have good knowledge in VBA ,within my limitation what I am doing is that , 1) I have a secret file in my computer which have code number , and all the files which I want prevent coping linked with the secret file.

Re: $$Excel-Macros$$ How do I find the highest of the most repeating values in a list of numbers ie. the max of the modes

Do you care if it is done with a macro? Option Explicit Public Dict_Vals Sub CheckVals()     Dim KeyVals, R, MaxVal, MaxCnt, RowCnt     Set Dict_Vals = CreateObject("Scripting.Dictionary")     Dict_Vals.RemoveAll     RowCnt = Application.WorksheetFunction.CountA(Range("A1:A65000"))     For R =

$$Excel-Macros$$ Help Required

Dear Friends, Please suggest solution for attached file Thanks Kantilal -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our

Re: $$Excel-Macros$$ Excel Puzzle of the week

given the string is in Cell A1, use: = MONTH("01-"&LEFT(A1,3)) Paul From: ayush jain To: excel-macros@googlegroups.com Sent: Thu, January 6, 2011 1:26:42 AM Subject: Re: $$Excel-Macros$$ Excel Puzzle of the week there was Typo in example...its Decem to 12 S

Re: $$Excel-Macros$$ breaking my head last six months-PLsssssss. Help

Your terminology seems inconsistent with your sample file. You mentioned placing "X" if present and "A" if absent. But in your file, there are no "X's" or "A's". But P,L,U,E In which U and E represent Absent codes Unexcused and Excused But L in the legend says it represents Late yet in the summary

Re: $$Excel-Macros$$ How to count distinct values on the base of multiple criteria

exactly Ayush, I have already tried Paul's solution but I didn't get desired result. I am attaching the file again with expected result Please help Thanks in advance Kalyan On Thu, Jan 6, 2011 at 6:13 PM, Ayush wrote: > Right Paul, but your formula is counting duplicate values also.This user

Re: $$Excel-Macros$$ How to count distinct values on the base of multiple criteria

Dear Kalyan, Please find see attachment... Thanks, Noorain Ansari On Thu, Jan 6, 2011 at 4:43 AM, Ayush wrote: > Right Paul, but your formula is counting duplicate values also.This user > need to count only distinct values. correct ? > > Best Regards, > Ayush Jain > > -- > > --

Re: $$Excel-Macros$$ How to count distinct values on the base of multiple criteria

Interesting. The description wasn't very clear. I interpreted it to mean a simple count of Product/Depot items the problem is that the terms aren't consistent. The title attachments shows "No. of Distributor Billed?" but there is not "Distributor" column. If, we interpret "Distributor" as the "

Re: Fwd: $$Excel-Macros$$ Excel Puzzle of the week

Thanks Ashish , Manoj & Maries...Your solutions are great !! Maries, We can ignore Value formula from your solution and it still work ... like =TEXT(A11&1,"m") Till now, Manoj's formula is smallest and easiest ... Any one else wanna solve or comment on puzzle? Regards, Ayush Jain, Microsoft

Fwd: $$Excel-Macros$$ Excel Puzzle of the week

Dear Ayush Jain, Please find the attached file. this also one of way to find the months using the following formula. =TEXT(VALUE(A1&1),"m") Thank you, Regards, Maries -- Forwarded message -- From: Rohan Young Date: Thu, Jan 6, 2011 at 2:08 PM Subject: Re: $$Excel-Macros$$ Exc

Fwd: $$Excel-Macros$$ Excel Puzzle of the week

Dear Ayush Jain, Please find the attached file. this also one of way to find the months using the following formula. =TEXT(VALUE(A1&1),"m") Thank you, Regards, Maries -- Forwarded message -- From: Rohan Young Date: Thu, Jan 6, 2011 at 2:08 PM Subject: Re: $$Excel-Macros$$ Excel

$$Excel-Macros$$ Multiple Selection of cells & copying the same using macro

hi group, requesting you to tell me the macro codes for "Multiple Selection of cells & copying the same" thanks Rajesh -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :

Re: $$Excel-Macros$$ How to count distinct values on the base of multiple criteria

Right Paul, but your formula is counting duplicate values also.This user need to count only distinct values. correct ? Best Regards, Ayush Jain -- -- Some important links for excel users: 1. Follow us on TWITTER for

Re: $$Excel-Macros$$ How to count distinct values on the base of multiple criteria

Since you're using Excel2007, The simplest way (in my opinion) would be to use =countifs in Cell F7  use: =COUNTIFS($A:$A,$E7,$C:$C,F$6) (if you use the "anchors" ($) properly, you'll be able to drag the formula across and down for other products) If you want more assistance with it, try using

$$Excel-Macros$$ How to count distinct values on the base of multiple criteria

Dear experts, I have attached a file with query. Please help on that Thanks in advance Kalyan -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exce

Re: $$Excel-Macros$$ How do I find the highest of the most repeating values in a list of numbers ie. the max of the modes

Hi Kim, If you Excel 2010, then the job would be much easier. =Max(Mode.Mult(A1:A10)) This function is not available in Excel 2003. Cheers Valli On Jan 6, 11:16 am, Kim wrote: > Thanks so much Ashish but the problem is in the temporary column.  I > really need to do it in one cell only withou

Re: $$Excel-Macros$$ Emergency: Vba Code requested for PDF file has to be converted as Word Document.

You can use this site. Www.zamar.com On Thu, Jan 6, 2011 at 12:48 AM, Mariappan Kulasekaran wrote: > Hi Friends, > > As a part of my official activities, I will get incoming document as an > Ordinary PDF format. I have to covert this to a word document before I > process

Re: $$Excel-Macros$$ Description while using Macro Functions in Excel

hi Group any help thanks Rajesh On Thu, Jan 6, 2011 at 2:30 PM, Raj Mahapatra wrote: > hi all, > > any help > > > > On Wed, Jan 5, 2011 at 4:19 PM, ankur wrote: > >> hi rajesh >> very gud explantion >> >> On Thu, Dec 30, 2010 at 4:51 PM, Raj Mahapatra >> wrote: >> > hi Group, >> > >> > i wan

Re: $$Excel-Macros$$ Description while using Macro Functions in Excel

hi all, any help On Wed, Jan 5, 2011 at 4:19 PM, ankur wrote: > hi rajesh > very gud explantion > > On Thu, Dec 30, 2010 at 4:51 PM, Raj Mahapatra > wrote: > > hi Group, > > > > i want to show description of the Function while using the same in Excel > > like below screen shot. > > > > > >

Re: $$Excel-Macros$$ Excel Puzzle of the week

i agreed with Manoj see the attachment thanks & regards On Thu, Jan 6, 2011 at 12:20 PM, Manoj kumar wrote: > how about this... > > =MONTH(1&A1) > > > Regards, > Manoj Kumar > > > On Thu, Jan 6, 2011 at 12:05 PM, ayush jain wrote: > >> Wow AshishSuperfast...I liked it.. >> >> Dear group,