Sorting rows based on populated columns

[rufuxinix]

Hello fundis
I have a table which I need to sort, based on column criteria i enter.
As an example I want to extract rows that are populated in columns x, y and z. There could be other columns in the row that are also populated, or not.
So the result could be
x, y, z
but it could also be, say,
a, c, x, y, z, d

Any formula or easy way to do this?

Thanks

 

[maabadi]

Select All Range go to Sort, Custom Sort, Add Levels Until wants, then Select Columns Criteria, respectively, Also tick my table Has headers (if your Data has).

 

[rufuxinix]

Select All Range go to Sort, Custom Sort, Add Levels Until wants, then Select Columns Criteria, respectively, Also tick my table Has headers (if your Data has).

Thanks but doesn't work as intended.
It will sort but will also include columns which I do not want to see
so, on the x, y, z example it will give me rows where x is present even if y and z are not present in that row

 

[maabadi]

It will sort but will also include columns which I do not want to see

You want sort only one column within Table?
If Yes. Select one cell within Table, Go to Design tab, Convert to Range,
Only Select Column that you want sort, Sort it
Then Again Press CTRL+T to Convert Range to Table

 

[rufuxinix]

You want sort only one column within Table?
If Yes. Select one cell within Table, Go to Design tab, Convert to Range,
Only Select Column that you want sort, Sort it
Then Again Press CTRL+T to Convert Range to Table

i have a table with several columns.
Ex:
a b c d e f
x x x
x x x x
x x x x x

I want to be able to extract rows that have column a, c, and e populated

The result should show me Row 1 and Row 3.

Row 2 will not be extracted because it does not meet my criteria, as Column a is not populated


.

 

[rufuxinix]

i have a table with several columns.
Ex:
a b c d e f
x x x
x x x x
x x x x x

I want to be able to extract rows that have column a, c, and e populated

The result should show me Row 1 and Row 3.

Row 2 will not be extracted because it does not meet my criteria, as Column a is not populated


.

Sorry, the text might not show properly.
Please see below. Rows 2 and 5 should be extracted

A	B	C	D	E	F	G
X		X		X	X
	X	X			X	X
X	X	X	X		X
X	X	X		X	X

 

[maabadi]

You can do it with Macro/VBA.
What is your Criteria? I don't understand?

 

[rufuxinix]

You can do it with Macro/VBA.
What is your Criteria? I don't understand?

So i would like to extract the rows I want, into a new table.
Criteria would be
I need a table with all the rows that have columns a, c, e populated
or with all the rows that have columns b, c, d populated

Do you get it?

 

[maabadi]

You can Do it With formula? E.g.at sheet2 at A1 write =Sheet1!A1 And at B1 Write =Sheet1!C1 And ... Finally drag them down.
I cann't do it with Macro until I have a criteria for setting?

Please Upload Example file & Desired results with XL2BB ADDIN(Preferable) or upload at free hosting Site e.g. www.dropbox.com , GoogleDrive or OneDrive & insert Link here.

 

[rufuxinix]

Ok, thank you.

So, from the ex table below I want to extract rows, which will appear in another sheet, based on criteria I enter.
Example
Based on the table below I want a new table with all the rows that have names in columns A, D, and F
The result would be a table with the following rows

A	B	C	D	E	F	G	H	I	J
John		George	Robert			Lisa		Joey
	Jack	Justin		Vaughan					Louis
Rodney		John	Lisa	Joey		Jack
George		Justin		Louis			Derek	Mary