Formula to return the rows with data

[Chris Fawcett]

Hi all,

I have a spreadsheet which is formed from IF and VLookup formulas. The spreadsheet is over 50 rows and 4 columns with the returned data on each row as either data or the whole row blank "" .

Is there a formula I can use on a different sheet to return the rows with only data on? e.g over the 50 rows only 6 rows have data. In a second sheet I want return the 6 rows with data on rows 1 to 6? .

Regards

Chris

[Chris Fawcett]

Sorry solved this myself using RANK :-)