Excel 2010 Preview #1: New Rank Function RANK.AVE

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 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

Hi there,

I have two columns: in A are the names of contestants; in B are the contestants scores in a competition. In a seperate worksheet, I want to set up a table of ten rows with a formula that will take the highest 10 scores, highest in B1, lowest in B10, and then in A1:A10 show the contestants' names.

Please help!!

Many thanks

Hello,
This has something to do with the Microsoft Excel's RANK function. In the table below,
Column A represents for example the scores by students.
Column B is the result using the RANK function of Excel.
Column D is their initial rank

What formula must be used to arrive at ranking in Column C?
Here, we can see that students who got scores of 27 has initial ranks of 2 and 3(see column D).
Getting the average of their ranks will become (2+3)/2=2.5.
Likewise for student who got scores of 13 has initial ranks of 5, 6, and 7(column D) therefore the average of their ranks is (5+6+7)/3=6.
How do I arrive at the ranking based on column C

A == B== C==D(initial rank)
32== 1== 1===1
27== 2 == 2.5==2
27== 2== 2.5==3
15== 4 == 4===4
13== 5 == 6===5
13== 5 == 6===6
13== 5 == 6===7
11== 8 == 8===8

****** 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

Hi -

First time poster with probably a very simple question about the use of "ISBLANK".

I have 2 columns of data (A:A), (B:B) with text values in them.

At any time either A1 is filled in and B1 is blank, or A1 is blank and B1 is filled in or both are filled in with the same value, or both are blank.

In Column C, I'd like to use the ISBLANK function for the following objectives:

1) If A1 contains a value but B1 is blank, place value of A1 in C1
2) If A1 is blank and B1 contains a value, place value of B1 in C1
3) If A1 and B1 both contain values, which they will always be the same, place that value in C1
4) If both A1 and B1 are blank, place "Fusion Direct" in C1

Will the ISBLANK function accomplish this goal, or do I need to utilize something else?

Thank you,
AG

Hey all below is a spreadsheet,
http://www46.zippyshare.com/v/90549541/file.html

In another spreadsheet in the same document i have to calculate the total sales per car category, im having some trouble with the sumif function.\

Thanks for your help.

Hi All,
I'm stumped.
I have a list of values that I would like to rank. E.g Below

Cell Value Preferred Rank
A1 95 1
A2 130 3
A3 103 2
A4 103 4
A5 95 5

What I would like to do is rank the lowest value which is 95 and compare it to a preferred rank listing. As there are two values of 95, I want A1 to show as rank 1 and A5 as rank 2 as it has a lower preferred rank.

Another example:
A1 140 1
A2 130 3
A3 103 2
A4 103 4
A5 95 5

In this case A5 is the lowest value and there are no other duplicates, so this should be ranked as 1. However cell A3 and A4 are duplicates but based on the preferred rank they show as 2 and 4. Therefore the rank order should be A5 = 1, A3 = 2 and A4 = 3.

Confusing as hell . PLease let me know if you need me to elaborate further. Not sure if this can be done, that's why i'm here posting.

Please HELP

When I move a cell in excel 2010, any function on that same sheet that has a named range as one of it's inputs will get recalculated. This is a big performance impact for me as I have a sheet with a lot of formulaes that have named ranges as inputs. Why is this happening??!! If I replace the named range with a cell name, e.g. A1, the recalculation does NOT occur.

I've read info about how excel recalculates: http://msdn.microsoft.com/en-us/library/bb687891.aspx#Y1595

and I still don't see why this is happeing. And, I've tried adding
Application.Volatile (False)
and this doesn't help. Any suggestions would be greatly appreciated!

Example:
Function etest(etest_var As String)
etest = 1
End Function

In cell A1, I have formula
=etest(etest_var)
Cell A2 is named "etest_vav"

When I move a cell ANY WHERE on the sheet, it seems excel thinks the named range "etest_var" has been modified and therefore recalculates the etest function. If I change cell A1 formula to this
=etest($A$2)
Then moving a cell on the sheet does not cause the recaculation.

I would like to copy a chart from excel to word and position it absolutely. Currently, I am able to move a chart from Excel to Work and move it incrementally using VBA. However, I would like to know if it is possible to place it absolutely (top,left) instead?

Here is my code for moving it incrementally.

Code:

Sub start_new_word_doc()

'open word template
Dim appWRD As word.Application
Dim objdoc As word.Document

Set appWRD = CreateObject("Word.Application")
appWRD.Visible = True
Set objdoc = appWRD.Documents.Open("C:\test\sample.docx")

If objdoc Is Nothing Then
        MsgBox "Unable to find the Word file.", vbCritical, "File Not Found"
        appWRD.Quit
        Set appWRD = Nothing
        Exit Sub
    End If

Call Move_Charts

objdoc.Shapes.Range(Array("Chart 1")).IncrementLeft 15
objdoc.Shapes.Range(Array("Chart 1")).IncrementTop 130

End Sub

Sub Move_Charts()

Dim word As word.Application
Dim doc As word.Document

Set word = GetObject(, "Word.Application")
Set activeDoc = word.ActiveDocument

'chart 1
    Sheets("summary").Select
    ActiveSheet.ChartObjects("Chart 1").Activate
    ActiveChart.ChartArea.Copy
    word.Selection.GoTo What:=wdGoToPage, Which:=1
    word.Selection.PasteSpecial Placement:=wdFloatOverText

End Sub

I have seen another example where the parent property is changed but i am unable to make that work. Also is there a way to designate a specific variable to the chart copied into Word. For example, Chart 1 from excel becomes "Pie Chart" in Word?

Any help is greatly appreciated!