bukaros13
New Member
Hello
I need your help with this problem, I have two sheets with data, each sheet has a column that served me for reference, I need to unify these two columns into one to eliminate the repeated data and copy to a new sheet.
I would like to have a dynamic range formula that reads these columns, which change monthly
I used this formula
=Sheet1!H4:INDEX(sheet1!H4:H1048576,COUNTA(sheet1!H:H)) but i can't add the other data
Thank you very much in advance
I need your help with this problem, I have two sheets with data, each sheet has a column that served me for reference, I need to unify these two columns into one to eliminate the repeated data and copy to a new sheet.
I would like to have a dynamic range formula that reads these columns, which change monthly
I used this formula
=Sheet1!H4:INDEX(sheet1!H4:H1048576,COUNTA(sheet1!H:H)) but i can't add the other data
Thank you very much in advance
Attachments
Last edited: