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: