Excel Client:ElemIndex: Difference between revisions

From CoPlanner 10
Jump to navigationJump to search
VisualWikitext
Created page with '==ElemIndex(Dimension, Element)== This returns the position (order) at which the element is located. ===Parameter=== {| style=cellspacing="1" cellpadding="5" border="1" width…'
 
No edit summary
 
(4 intermediate revisions by the same user not shown)
Line 1: Line 1:
==ElemIndex(Dimension, Element)==
==[[Excel_Client:Functions_(Formulas)|Function]]==


This returns the position (order) at which the element is located.
<span {{CoPFormel}}>ElemIndex(Dimension, Element)</span>


===Parameter===
This [[Excel_Client:Functions_(Formulas)|function]] returns the position (order) at which the element is located.


{| style=cellspacing="1" cellpadding="5" border="1" width={{{breite|50%}}}
{| class="wikitable" width={{{breite|80%}}}
|- {{Tabellentitel}}
| width="150px"|Parameter
| Description
|-
|-
|width="200pt" style=background-color:#f6f6f6 |'''Dimension''' 
|Dimension
|The dimension to which the operation applies.  
|The dimension to which the operation applies.  
|-
|-
|style=background-color:#f6f6f6 |'''StartElement '''
|StartElement
|The element whose position is sought.
|The element whose position is sought.
|}
|}


 
==Example ==
===Example ===
<span {{CoPFormel}}>ElemIndex("Zeit";"FEB 2005")</span><br>
 
returns 2
{| style=cellspacing="1" cellpadding="5" border="1" width={{{breite|50%}}}
|-
|width="200pt" style=background-color:#f6f6f6 |'''Function'''
|style=background-color:#f6f6f6 |'''Result '''
|-
|ElemIndex(„Zeit“;“FEB 2005“)
|2
|}
 


__NOEDITSECTION__
__NOEDITSECTION__
[[Category:Excel_Client_Formulas|ElemIndex]]
[[Category:Excel_Client_Formulas|ElemIndex]]
[[de:Excel_Clien:ElemIndex]]
[[de:Excel_Client:ElemIndex]]

Latest revision as of 13:56, 15 April 2014

Function

ElemIndex(Dimension, Element)

This function returns the position (order) at which the element is located.

Parameter Description
Dimension The dimension to which the operation applies.
StartElement The element whose position is sought.

Example

ElemIndex("Zeit";"FEB 2005")
returns 2

Retrieved from "https://copsupport.coplanner.com/help10_en/index.php?title=Excel_Client:ElemIndex&oldid=14788"