I have this formula:
I know its a CSE formula, but i need it broke down to where i can understand it.
The reason i need it to edit is i need to change the "Owner=?".
1 - Can someone breakdown this Formula?
IFERROR
(Index
(First,Small
If
*
* again
(Right
(Pos,1)
<>P)
,ROW
(First)
-MIN
(ROW(First))+1
,ROW(1:1)))
,""
2 - How do you copy a workbook and all of its formulas and values to a new workbook?
3 - Also how can you edit CSE formula's in the formula bar?
(The reason i need it to edit is i need to change the "Owner=?")
Thanks for any help.
Code:
{=IFERROR(INDEX(First,SMALL(IF((Owner="Rog")*(Roster="MLB")*(RIGHT(Pos,1)<>"P"),ROW(First)-MIN(ROW(First))+1),ROW(1:1))),"")}
I know its a CSE formula, but i need it broke down to where i can understand it.
The reason i need it to edit is i need to change the "Owner=?".
1 - Can someone breakdown this Formula?
IFERROR
(Index
(First,Small
If
*
* again
(Right
(Pos,1)
<>P)
,ROW
(First)
-MIN
(ROW(First))+1
,ROW(1:1)))
,""
2 - How do you copy a workbook and all of its formulas and values to a new workbook?
3 - Also how can you edit CSE formula's in the formula bar?
(The reason i need it to edit is i need to change the "Owner=?")
Thanks for any help.
Last edited: