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