Forum Discussion
KIMTI null
Dec 13, 2023Copper Contributor
Extract data based on date range
I have the datasheet with each data set recorded in the columns (not rows). This data sheet has multiple years (recorded by the date). I need to extract the data (specific rows) to another sheet by t...
mtarler
Dec 14, 2023Silver Contributor
oh my bad try this:
=TOCOL(FILTER(CHOOSEROWS('2.Know'!A1:ZZ100,3,6,8,18), ('2.Know'!A3:ZZ3>=$B$1)*( '2.Know'!A3:ZZ3<=$C$1), ""),,TRUE)
=TOCOL(FILTER(CHOOSEROWS('2.Know'!A1:ZZ100,3,6,8,18), ('2.Know'!A3:ZZ3>=$B$1)*( '2.Know'!A3:ZZ3<=$C$1), ""),,TRUE)
KIMTI null
Dec 14, 2023Copper Contributor
Thank you. All is good now.