Example:

A B C

1 Nick 10
2 john 15
3 jenny 15

Using a formula how do I copy and paste in a different place the rows of the
names that starts with "J" in this case row 2 and 3.


Thank you in advance. I'm getting crazy with this project

There's no formula that copies rows.

You'd have to use VBA or else do it manually.

"HERNAN" wrote:

Example:

A B C

1 Nick 10
2 john 15
3 jenny 15

Using a formula how do I copy and paste in a different place the rows of the
names that starts with "J" in this case row 2 and 3.


Thank you in advance. I'm getting crazy with this project

A simple manual workaround is to sort the data by Col B. Then highlight all
the J rows and Copy/Paste to the new location.

"Dave F" wrote:

There's no formula that copies rows.

You'd have to use VBA or else do it manually.

"HERNAN" wrote:

Example:

A B C

1 Nick 10
2 john 15
3 jenny 15

Using a formula how do I copy and paste in a different place the rows of the
names that starts with "J" in this case row 2 and 3.


Thank you in advance. I'm getting crazy with this project