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 over would be the last row (Carlton)
1 Reply
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, "")
