Excel-sort paragraphs in a doc(s):egAll on heart on one page?
 

In Dos, you can save a whole file and then sort with the FIND command and it
will pull out all the lines (paragraphs) that have the search word in them.
Excel sorts by columns, but normally you put one words in each column... but
can you have for example, Heart in Column A Row 2 / Heart, lungs, kidney in
column B Row 2/ and Conjestive Heart Failure in Column C Row 3...plus a lot
of other things...and have Excel sort to put each thing with heart together?

Excel-sort paragraphs in a doc(s):egAll on heart on one page?
 

Not without using a dummy column with a formula that gets all your sort
values in a single column.

--
Regards,
Tom Ogilvy


"denny" wrote in message
...
In Dos, you can save a whole file and then sort with the FIND command and
it
will pull out all the lines (paragraphs) that have the search word in
them.
Excel sorts by columns, but normally you put one words in each column...
but
can you have for example, Heart in Column A Row 2 / Heart, lungs, kidney
in
column B Row 2/ and Conjestive Heart Failure in Column C Row 3...plus a
lot
of other things...and have Excel sort to put each thing with heart
together?

Excel-sort paragraphs in a doc(s):egAll on heart on one page?
 

Maybe you don't have to actually put them together.

Maybe it would be good enough to just hide the rows you don't want to see?

Apply Data|filter|autofilter to your whole range
Use the dropdown arrow over column A and choose Custom
then
contains
(scroll down in that list)
and type in
heart



denny wrote:

In Dos, you can save a whole file and then sort with the FIND command and it
will pull out all the lines (paragraphs) that have the search word in them.
Excel sorts by columns, but normally you put one words in each column... but
can you have for example, Heart in Column A Row 2 / Heart, lungs, kidney in
column B Row 2/ and Conjestive Heart Failure in Column C Row 3...plus a lot
of other things...and have Excel sort to put each thing with heart together?

--

Dave Peterson

Excel-sort paragraphs in a doc(s):egAll on heart on one page?
 

I know autofilters are good, but since the other hearts are in B or C, I
doubt that suggestion would work:

column B Row 2/ and Conjestive Heart Failure in Column C Row 3

--
Regards,
Tom Ogilvy


"Dave Peterson" wrote in message
...
Maybe you don't have to actually put them together.

Maybe it would be good enough to just hide the rows you don't want to see?

Apply Data|filter|autofilter to your whole range
Use the dropdown arrow over column A and choose Custom
then
contains
(scroll down in that list)
and type in
heart



denny wrote:

In Dos, you can save a whole file and then sort with the FIND command
and it
will pull out all the lines (paragraphs) that have the search word in
them.
Excel sorts by columns, but normally you put one words in each column...
but
can you have for example, Heart in Column A Row 2 / Heart, lungs,
kidney in
column B Row 2/ and Conjestive Heart Failure in Column C Row 3...plus a
lot
of other things...and have Excel sort to put each thing with heart
together?

--

Dave Peterson

Excel-sort paragraphs in a doc(s):egAll on heart on one page?
 

oopsie. I missed that.
Tom Ogilvy wrote:

I know autofilters are good, but since the other hearts are in B or C, I
doubt that suggestion would work:

column B Row 2/ and Conjestive Heart Failure in Column C Row 3

--
Regards,
Tom Ogilvy

"Dave Peterson" wrote in message
...
Maybe you don't have to actually put them together.

Maybe it would be good enough to just hide the rows you don't want to see?

Apply Data|filter|autofilter to your whole range
Use the dropdown arrow over column A and choose Custom
then
contains
(scroll down in that list)
and type in
heart



denny wrote:

In Dos, you can save a whole file and then sort with the FIND command
and it
will pull out all the lines (paragraphs) that have the search word in
them.
Excel sorts by columns, but normally you put one words in each column...
but
can you have for example, Heart in Column A Row 2 / Heart, lungs,
kidney in
column B Row 2/ and Conjestive Heart Failure in Column C Row 3...plus a
lot
of other things...and have Excel sort to put each thing with heart
together?

--

Dave Peterson

--

Dave Peterson

Excel-sort paragraphs in a doc(s):egAll on heart on one page?
 

I want to make something quick and automatic, so I can search any subject.
It could be a macro that left a blank to filter and stick "heart" (etc) in
each column, but to be quick and easy it needs to be able to find heart when
there is a row: Heart, kidney, lungs...just like Dos does.

"Dave Peterson" wrote:

Maybe you don't have to actually put them together.

Maybe it would be good enough to just hide the rows you don't want to see?

Apply Data|filter|autofilter to your whole range
Use the dropdown arrow over column A and choose Custom
then
contains
(scroll down in that list)
and type in
heart



denny wrote:

In Dos, you can save a whole file and then sort with the FIND command and it
will pull out all the lines (paragraphs) that have the search word in them.
Excel sorts by columns, but normally you put one words in each column... but
can you have for example, Heart in Column A Row 2 / Heart, lungs, kidney in
column B Row 2/ and Conjestive Heart Failure in Column C Row 3...plus a lot
of other things...and have Excel sort to put each thing with heart together?

--

Dave Peterson

Excel-sort paragraphs in a doc(s):egAll on heart on one page?
 

I've always tried to make each row in excel a single record.

I'd use all 256 columns before I'd go to the next row.

But without knowing what your data looks like, I don't think you'll get many
definitive responses. (Well, at least not from me.)

denny wrote:

I want to make something quick and automatic, so I can search any subject.
It could be a macro that left a blank to filter and stick "heart" (etc) in
each column, but to be quick and easy it needs to be able to find heart when
there is a row: Heart, kidney, lungs...just like Dos does.

"Dave Peterson" wrote:

Maybe you don't have to actually put them together.

Maybe it would be good enough to just hide the rows you don't want to see?

Apply Data|filter|autofilter to your whole range
Use the dropdown arrow over column A and choose Custom
then
contains
(scroll down in that list)
and type in
heart



denny wrote:

In Dos, you can save a whole file and then sort with the FIND command and it
will pull out all the lines (paragraphs) that have the search word in them.
Excel sorts by columns, but normally you put one words in each column... but
can you have for example, Heart in Column A Row 2 / Heart, lungs, kidney in
column B Row 2/ and Conjestive Heart Failure in Column C Row 3...plus a lot
of other things...and have Excel sort to put each thing with heart together?

--

Dave Peterson


--

Dave Peterson

Excel-sort paragraphs in a doc(s):egAll on heart on one page?
 

I am trying to organize and catagorize everything I learn. In this example
it is health issues, so I'll make a pretend senerio.
In Row 1 Col A It says, Heart Col B says, Pumps blood all around your body
In Row 2 Col A it says Liver (and I would like it to have references to
several things in the sentence in Col
B...like...skin,bowels,lymph,kidney,bowel...Col B would say this,-- Renew
Life has a very good Liver cleanse, but they suggest you only do it after you
have primed your system so that the skin, bowels,lymph system, kidneys, etc.
are ready to help, and after the bowel is cleaned so there is not so much
garbage for the liver to filter out.
In Row 3 Col A says Hepatitis --Col B says It damages the liver (So that
means we need a reference to Hepatitis and liver)
But in Dos, it would find it without you having to even think hard about
what catagories you should file it under in Col A.
I hope that make sense. You may have to enter it in Excel to see what I
mean???

"Dave Peterson" wrote:

I've always tried to make each row in excel a single record.

I'd use all 256 columns before I'd go to the next row.

But without knowing what your data looks like, I don't think you'll get many
definitive responses. (Well, at least not from me.)

denny wrote:

I want to make something quick and automatic, so I can search any subject.
It could be a macro that left a blank to filter and stick "heart" (etc) in
each column, but to be quick and easy it needs to be able to find heart when
there is a row: Heart, kidney, lungs...just like Dos does.

"Dave Peterson" wrote:

Maybe you don't have to actually put them together.

Maybe it would be good enough to just hide the rows you don't want to see?

Apply Data|filter|autofilter to your whole range
Use the dropdown arrow over column A and choose Custom
then
contains
(scroll down in that list)
and type in
heart



denny wrote:

In Dos, you can save a whole file and then sort with the FIND command and it
will pull out all the lines (paragraphs) that have the search word in them.
Excel sorts by columns, but normally you put one words in each column... but
can you have for example, Heart in Column A Row 2 / Heart, lungs, kidney in
column B Row 2/ and Conjestive Heart Failure in Column C Row 3...plus a lot
of other things...and have Excel sort to put each thing with heart together?

--

Dave Peterson


--

Dave Peterson

Excel-sort paragraphs in a doc(s):egAll on heart on one page?
 

You could use a helper column with a formula like:

=countif(A1:C1,"*heart*")

Then filter on that column to show all the values greater than 0.

Debra Dalgleish has some tips that may help:
http://contextures.com/xlautofilter02.html#String

denny wrote:

I am trying to organize and catagorize everything I learn. In this example
it is health issues, so I'll make a pretend senerio.
In Row 1 Col A It says, Heart Col B says, Pumps blood all around your body
In Row 2 Col A it says Liver (and I would like it to have references to
several things in the sentence in Col
B...like...skin,bowels,lymph,kidney,bowel...Col B would say this,-- Renew
Life has a very good Liver cleanse, but they suggest you only do it after you
have primed your system so that the skin, bowels,lymph system, kidneys, etc.
are ready to help, and after the bowel is cleaned so there is not so much
garbage for the liver to filter out.
In Row 3 Col A says Hepatitis --Col B says It damages the liver (So that
means we need a reference to Hepatitis and liver)
But in Dos, it would find it without you having to even think hard about
what catagories you should file it under in Col A.
I hope that make sense. You may have to enter it in Excel to see what I
mean???

"Dave Peterson" wrote:

I've always tried to make each row in excel a single record.

I'd use all 256 columns before I'd go to the next row.

But without knowing what your data looks like, I don't think you'll get many
definitive responses. (Well, at least not from me.)

denny wrote:

I want to make something quick and automatic, so I can search any subject.
It could be a macro that left a blank to filter and stick "heart" (etc) in
each column, but to be quick and easy it needs to be able to find heart when
there is a row: Heart, kidney, lungs...just like Dos does.

"Dave Peterson" wrote:

Maybe you don't have to actually put them together.

Maybe it would be good enough to just hide the rows you don't want to see?

Apply Data|filter|autofilter to your whole range
Use the dropdown arrow over column A and choose Custom
then
contains
(scroll down in that list)
and type in
heart



denny wrote:

In Dos, you can save a whole file and then sort with the FIND command and it
will pull out all the lines (paragraphs) that have the search word in them.
Excel sorts by columns, but normally you put one words in each column... but
can you have for example, Heart in Column A Row 2 / Heart, lungs, kidney in
column B Row 2/ and Conjestive Heart Failure in Column C Row 3...plus a lot
of other things...and have Excel sort to put each thing with heart together?

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson