Search results

Thanks Cyril. I will have to include instructions that no one will read. :(

Chandoo has already fixed the problem: http://chandoo.org/wp/2011/10/19/split-excel-file-into-many/ I use this technique every day. It's a little slow if you have more than 10K rows and 8 splits, like I do, but it's smooth and awesome. You can then add code to Email the file automatically.

Some carriers allow you to SMS someone through Email. Check their carrier's database to see if they have this feature. Then you can just send an Email to the phone.

I would do the ParamArray, but I need the argement names to appear, as they must be entered in a specific order. I'm glad I'm on the right track, but I still can't get the arguement names to appear. It's a minor issue, but one I'd like to resolve. If you want, I can send you a heavily...

Unfortunately, that's the way I was set up to begin with. Here is partial code: Function Status(Arg1 As Date, Arg2 As Date, Arg3 As Date, Arg4 As Date, Arg5 As Date, Arg6 As Date, Arg7 As Date, Arg8 As Date, Arg9 As Date, Arg10 As Date) As String Dim RetStatus As String ' RetStatus =...

Thanks to all the help from Chandoo's articles and everyone's advice here, I've completed my first user-defined function. It has 10 arguements, which must be selected in the correct order. When I select the function, I want the arguements to appear like so: =UDF(arg1, arg2, arg3, ...) Any...

Have you considered using HLOOKUP instead of VLOOKUP?

set the table array by using a named range. As for the column, you will need to have a row of the column numbers. That way, you can change the reference as you move across the columns. Assume you have a table called "datatable" from D3 to H12, so the table has 10 columns. From B3 to B12...

All, I just saw these responses, let me go back to my original file. I will post shortly.

I did it without the array formula in Excel 2007: =AVERAGEIF(A1:A100,"<"&PERCENTILE(A1:A100,0.95))

It sounds like there are two variables to consider: # of sheets # of clients If the number of sheets per client is constant (i.e. 3 sheets per client), then the macro can ask for both variables and then create all of the sheets at one go. Otherwise, you should make the user run the macro...

Select A1:A120 Open conditional formatting Select New Rule Select Use a formula to determine which cells to format In the formula window enter this formula: =OR($I1>60,$M1>60,$Q1>60,$U1>60) then select the format you want below. Good luck.

Do your whole presentation in Excel. That's what I do. :)

I thought that would work, except I'm not summing, I'm counting order status. For example, how many Word orders does the Chandoo division have. Some weeks its zero, but I still need the Word column header to appear.

Yet another question for the gang. I'm using Chandoo's excellent Split an Excel File into Many Tutorial - http://chandoo.org/wp/2011/10/19/split-excel-file-into-many/ - to divide a large report by division. I ran into a small problem which may be an Excel 2007 quirk: I have my data...

All, In my excel challenge, I have a report that produces multiple pivot tables. However, because of a reorg, I need to produce multiple versions of the same report for each new division. These pivot tables have Column Headings like "Word, Excel, PowerPoint, Acess, OneNote, Bob" But not...

I echo Prasad's suggestion. It's the only way to make it work now. I think in 2003 you could reuse fields as row, column or page, but now you can't.

I'm afraid I don't understand your requirements. 1. If you divide 365/EndDate-StartDate), you will end up with a number greater than 1 for a fraction of the year. For example, if you use today's date (Feb. 07) and Apr. 1, 2011 as the start date, then YEARFRAC returns 0.85. Doing it your...

Prasad, Use the YEARFRAC function. It's =YEARFRAC(StateDate,EndDate,Basis). One thing, if you enter the date in the formula, then you have to use the DATE function. Best thing to do is have the YEARFRAC formula refer to dates in another cell.

Hui, thank you! I was afraid that SUMPRODUCT wouldn't handle the wildcards very well. Oh well, back to the multiple COUNTIFS.

I'm working on a revision of a report my team runs every week. I've decided to take the plunge into SUMPRODUCT after reading about it here. I have many different columns to look up, but basically I'm worried about two: The date of a particular action and the organization that the action...

This is a homework problem. I just looked in my old statistics textbook and found a very similar problem, right down to the wording. Snow, if you are truly a student, then you are wasting your money by posting the problems here. You will be better off puzzling through the problems yourself...

The mean and SD of what? Also, I looked at your posts and I have to ask if you are taking a statistics class? :)

Debra also covers this topic in a Contextures blog post: http://blog.contextures.com/archives/2012/01/03/change-all-pivot-tables-with-one-selection/ I used this code for my reports to manipulate three different tables at the same time.

Praveen, All you have to do is use Luke or Narayan's formula in the row where you want the data to appear. The formulas will copy the data to the top row.