I've a table with hidden rows. B4-B2341 is populated with urls. I'm trying to use the aggregate function to populate column A with row numbers, starting with 1 at A4 and ignoring hidden rows. So far no success with =AGGREGATE(2,5,A$1,A1)+1 in A4 & copied to A2341. Thanks for your help!!!!!!!!!!!!