I have some filtered data in sheet2 .I get column H and I data with subtotal function.
How do I auto copy filtered list data of adjoining cells of column B to G and I
please check attached file,I want to copy all adjoining cells of column H2
I have some filtered data in sheet2 .I get column H and I data with subtotal function.
How do I auto copy filtered list data of adjoining cells of column B to G and I
please check attached file,I want to copy all adjoining cells of column H2
Last edited by PandaWarrior; 05-30-2020 at 12:28 PM. Reason: new file uploaded with correction
You can take a look at the advanced filter.
please check new file ,there was an error in previous
=INDEX(Sheet2!A2:I60,MATCH(Sheet1!H2,Sheet2!G2:G60,0),MATCH(Sheet2!A1,Sheet2!A1:I1,0))
gives me data ,any other solution
Last edited by PandaWarrior; 05-30-2020 at 01:31 PM.
with large set of data about 500000 rows the formula is not giving correct result.how do I get cell data of adjoining cells of cell Sheet1!H2 ?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks