I am caught up on what to put in for lastrow.

"lastrow" should be the count of total rows in your range. If your range of

data was from A1:C10 then lastrow = 10. However, you'd need to change the

syntax from:

ROW(INDIRECT("1:"&lastrow))

To:

ROW(INDIRECT("1:10"))

Probably easier if you replace lastrow with ROWS(rng), where rng is your

actual range. Like this:

ROW(INDIRECT("1:"&ROWS(A1:C10)))

Also should I put my whole data range in where A1 is?

No. Use whatever is the top left cell in your range. If your data is in the

range K19:M27 the top left cell in the range is K19 then you'd use K19.

This is why you should always tell use where your real data is located. It

seems most people use "fake" ranges when they post a question and in some

circumstances the location of the data can matter in how a formula is

crafted for the best result.