I have an xls file. I open up in Excel 2007, the print preview looks fine: margin looks right
But when I open the same file in Excel 2010, the print preview doesn't look right.
It's like everything gets shifted to the left and has the wide margin on the right hand side.
Anybody knows what's causing the problem in 2010?
Thanks in advance.
I'm trying to find the 25th percentile value for a column of numbers, but I want to exclude all the "0" values from the calculation.
Do you know if there is a way to do this in Excel?
I know the standard percentile function would be =percentile(range, .25).
Thank you very much.
I am having a problem with the new version of Excel 2010. These documents will show up correctly, then when viewed in the print preview window be wrong. I have re-opened these files in older versions ( Excel 2007 and Excel 2003) and they display correctly and print correctly. In the new version of excel the text in the "Combo Boxes" are changing font size upon printing. This even holds true for the print preview window. I have also tried this on another computer which has Excel 2010 and I have the same problem. Here are some links to view the problem I've been having. Any help would greatly be appreciated!
This is a picture of the printing error.
http://i616.photobucket.com/albums/t...INT3-17-11.jpg
This is a picture of what it should look like when printed correctly.
http://i616.photobucket.com/albums/t...INT3-17-11.jpg
I want to find the percentile of my data, however I want to exclude the rows that are N/A.
I've inherited some VBA code that I'm trying to tweak but am having some problems. Basically, the objective is to look up a range of values in one worksheet ('inputsheet') and then summarize the percentile values in another spreadsheet ('outputsheet'). The latter pulls the desired percentiles from a row that is located above the target row.
Here's the code:
.Worksheets("outputsheet").Cells(5, 3).Formula = "=percentile('inputsheet'!b$3:b$1003,outputsheet!$b5*0.01)"
.Worksheets("outputsheet").Cells(5, 3).Copy
.Worksheets("outputsheet").Cells(5, 3).Range("A1:x1").Select
ActiveSheet.Paste
What is thowing me off is the next to last code [Range("A1:x1")]. I originally thought the latter was a range reference, but actually the x1 refers to highlighting one row. The problem is that not all of cells within the row are being selected so I'm missing some percentile results. For example, the cells containing the percentile values is C4:AA4, but only the cells from C5:Z5 are being highlighted (and are then filled with percentile values). Initially I thought this range format was analogous to a copy down shortcut (except its copying across) but it always misses the last column.
Any insights or alternative approaches would be appreciated.
Hi,
I would like to know if there is any formula that would help me in ranking the data. A typical scenanio would be that: The sales team has performed very well, , however we would need to identify the top 10% ,30%,40%,19%,1% team members of sales. Is there any formula wherein this can be done. I have tried percentile but some how it cannot give me accurate date. Can anyone help
****** http-equiv="Content-Type" content="text/html; charset=utf-8">****** name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 14">****** name="Originator" content="Microsoft Word 14">
Hello,
I have a program which could perfectly run on Excel 2003 Pro but not on Excel 2010 Pro.
I solved the first problem. You cannot declare a variable as dictionary anymore, you need to put Scripting.Dictionary.
But I spent more than one hour on the second one and cannot figure out the solution. I use the function Chr in the following case (I removed the code that had nothing to do with my problem):
Dim TermRInit As Integer
TermRInit = 7
Dim cRatioRefCell As String
cRatioRefCell = Chr(TermCInit + 64) & TermRInit
I receive the following compilation error:
"Compile error:
Can't find project or library"
It comes from Chr but this function is defined in Excel 2010 Help...
I really don't understand what is the problem. I think that I have to add a library but I don't know which one....
Thanks for your help.
Helo
Hello everyone!
I want to use PERCENTILE function for a part of an array with specific properties. I am attaching the file with example to illustrate.
I want to calculate percntile for column E, where values of column B are equal to 2.
Thank you inadvance for your help.
--
vb
SecureMarket
I am using the following formula to derive a percentile based on the following condition:
I am asking excel to look for all occurances of ABX in column C in the cell range 94 - 100063 and if it finds ABX to then to use the value in colum AC for that entry to calculate the 25th percentile. I also want the formula to ignore blank cells. The formula seems to do that. The problem I have is when there are zero instances of ABX in the cell range I just want the formula to return N/A in the cell where the formula resides. With the current formula I get the #NUM! in the case of zero entries. How can I modify the formula to return N/A or zero instead of #NUM!.
{=PERCENTILE(IF(C94:C100063="ABX",AC94:AC100063,""),0.25)}
In need of a solution here...
I have several sheets in a workbook containing different sets of data. I then have one master sheet which references specific cells from all of these data sheets so only the info I need is displayed in an organized manner on one sheet.
The first problem I ran into was that when I referenced the cells from other sheets, if the cell is blank, the reference would display a 0, instead of blank. So to fix this I did an IF statement, where if the cell was "" then it would display "". This fixed the problem until I started charting the condensed data on the one master sheet (which references the other sheets using the IF statement). When I plotted this data, the empty strings "" would be plotted as a value of 0, instead of being left off the plot. There are option to plot "gaps" as zero, or as nothing, and I told it to plot it as nothing... only problem is that it doesn't see it as a gap, it sees it as "" which then plots as 0.. making my line graphs fall to zero, when it is far more accurate in my case to have these data points not displayed.
So I changed the IF statements to place #N/A in the cells instead of "", which fixed the problem for the charts.
NOW I am trying to take averages and perform statistics functions on this set of data and I am having some issues, as taking the average of a range containing #N/A cells will simply yield #N/A. I was able to use DAverage(), DMin(), DMax() and DStDev() with a criteria of #N/A to fix the problem, but I am also in need of quartile or percentile data. Unfortunately there is no DQuartile function (that I am aware of).
If there any kind of DQuartie or QuartileIF statement that I am unaware of?? Any suggestions on how I could do this? Thanks.
