How can I make a Index entry where the subscripts are respected in the INDEX?

i need to get the Highest Scores from Cell BB6 to BD27 which are merged , and after achieving the result i need that how many Balls have been Played to reach this Score , and then if Possible to get the Player Name , can any One help

At first this is the German forum, the English one is here:

http://answers.microsoft.com/en-us/office/forum/excel

You missed to specifiy the search criterium for MATCH.

If you have merged cells you have to change the selected cell references to the first column:

G73: =INDEX(AZ6:AZ27,MATCH(F73,BB6:BB27,0))

So the player name is in the same row:

I73: =INDEX(E6:E27,MATCH(F73,BB6:BB27,0))

Andreas.

Are you using the full feature software/drivers as supplied by the printer maker or are you relying on the default win update drivers, I some how think you are using the latter.
<br />I have no issues on any PC, as I'm using the full feature software from HP
<br />

Lösung von Fei Xue (Original in diesem Thread:
http://social.msdn.microsoft.com/Forums/office/en-US/ff941cb2-9e27-46f4-9b27-6dfc4c7366c6/visio-2013-how-do-i-get-automatically-numbered-shapes-in-a-crossfunctional-flowchart?forum=officegeneral)

--- schnipp ---

Hi,

According to your description, you want to automatically numbered shapes.

I suggest you select the shapes you wanted numbered and using the code below to numbered the shapes:

Sub autoNumShape()

Dim index As Integer

index = 1

For i = 1 To Application.ActiveWindow.Selection.Count

If TypeOf Application.ActiveWindow.Selection.Item(i) Is Shape Then

Application.ActiveWindow.Selection.Item(i).Text = "PS-" & index & Application.ActiveWindow.Selection.Item(i).Text

index = index + 1

End If

Next i

End Sub

Screen Shot:



You can get more detail about Visio Object Model from link below:

Visio Object Model Reference

Best regards

Fei

--- schnapp ---

Are you able to open the files?

Is the problem that when you are only able to open the files in Read Only mode?

Where your files save to a CD or DVD? If so, the "Read Only" attribute may have been set on and can be turned off by right clicking on a file in Windows Explorer or the File Explorer and then left click on Properties.,

Thanks a lot for the reply! If you dont mind, I would like to elobarate my question in english. First problem is that I would like to add a word document (coverpage) to my word document. This coverpage is already prepared. But I have to merge this two word documents. How is it possible? The second problem is when I add a header in the coverpage, it appears in the other pages also. How can I fix the header just in the first page? Third problem is that I have deleted some references in the bibliography, when I update the bibliography, the deleted references don't disappear. How can I fix it?
<br />Kind regards
<br />