Can anyone breakdown this formula?

[heybata]

I have this formula:

{=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.

 

[Somendra Misra]

Hi,

The formula will extract say first name based on the roster, owner and position.
If you want to change owner only in the formula. Click on the first cell with this formula say A5. Press F2, take you cursor to point where it is written "ROG", delete it and enter new owner like "Who". You have to put the string in double quotes. Press CSE and copy down the formula.

I think if you copy and select paste all option from paste special it will copy everything to new workbook.

Regards,

 

[heybata]

Thanks again Somendra Misra
What about this in the formula:?

(RIGHT(Pos,1)<>"P"),ROW(First)-MIN(ROW(First))+1),ROW(1:1))),"")

Thanks

 

[Somendra Misra]

@heybata
(RIGHT(Pos,1)<>"P") part will check the right one character of position, since you have RP or SP as pitcher it will check all other and give the result.

If you want pitchers than this will become (RIGHT(Pos,1)="P").

ROW(First)-MIN(ROW(First))+1) -- > this part is only generating an array for numbers {1;2;3;4;5;.......upto last row of table} . This row number is assigned to all the TRUE of IF function and this give SMALL function an array of numbers of rows where all conditions are true. Finally when you drag the formula down you need 1st result, than 2nd and so on, So 1st small will give first row, 2nd small will give second row and so on, ROW(1:1) will give 1 so first small, if you copy the formula down it will be ROW(2:2) so second small and so on.

Regards,

 

[heybata]

Thank You
I will study this further, now that i know what its doing.