Forum Discussion
Formula or V lookup?
Is there a way for me on a separate sheet, pull the rows and columns A-L only, for the rows that contain a number greater than 2 in column C. (So in the photo above the only row that would transpose ...
Let's say the sheet with the data is named Data Sheet, and the rows you want to extract from are 3 to 200.
Copy the header row(s) to another sheet.
In the cell in column A below these headers. enter the formula
=FILTER('Data Sheet'!A3:L200, 'Data Sheet'!C3:C200>2, "")