ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   find - list of records (https://www.excelbanter.com/excel-discussion-misc-queries/448371-find-list-records.html)

Antek

find - list of records
 
Hi

Using "find" in excel file I get the first record (row)
that contains the group of characters I am looking for.
Then I can repeat it and I get next record, etc.
How to get a list of all records (rows) that contain
such group of characters?

Please tell me.

Regards
Antek

Claus Busch

find - list of records
 
Hi Antek,

Am Sun, 10 Mar 2013 17:54:06 +0100 schrieb Antek:

Using "find" in excel file I get the first record (row)
that contains the group of characters I am looking for.
Then I can repeat it and I get next record, etc.
How to get a list of all records (rows) that contain
such group of characters?


try:
find all


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Antek

find - list of records
 
Using "find" in excel file I get the first record (row)
that contains the group of characters I am looking for.
Then I can repeat it and I get next record, etc.
How to get a list of all records (rows) that contain
such group of characters?


try:
find all


Claus, thank you very much. It was really simple but I am
a beginner. :-)

Regards
Antek





All times are GMT +1. The time now is 11:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com