I need a formula that can find all instances of a record. For example I may
8 different instances where store #805 has an entry. I want to be able to
type in the store number have excel return all eight values from the seperate
entries. So far I have used index(match. But that formula only gives me the
first record in the list. I need to have them all. Any suggestions?

You can do it through code no problem, but I am a big fan of auto-filters as
well. I think they are very powerful if you know how to use em. Have you
tried them?
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"PerplexedinKY" wrote:

I need a formula that can find all instances of a record. For example I may
8 different instances where store #805 has an entry. I want to be able to
type in the store number have excel return all eight values from the seperate
entries. So far I have used index(match. But that formula only gives me the
first record in the list. I need to have them all. Any suggestions?

I have not tried them yet. As I am not very familiar, but I am willing to
learn.

"John Bundy" wrote:

You can do it through code no problem, but I am a big fan of auto-filters as
well. I think they are very powerful if you know how to use em. Have you
tried them?
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"PerplexedinKY" wrote:

I need a formula that can find all instances of a record. For example I may
8 different instances where store #805 has an entry. I want to be able to
type in the store number have excel return all eight values from the seperate
entries. So far I have used index(match. But that formula only gives me the
first record in the list. I need to have them all. Any suggestions?

If you highlight the head row, say row 1 by clicking the one. Now select
Data-Filter-Auto Filter, this will make drop down boxes for each column.
Now you can filter the columns using the drop boxes by making a selection or
using custom to choose between options etc. For your instance below you just
click the drop down for store and select 805 and it will filter by that store.
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"PerplexedinKY" wrote:

I have not tried them yet. As I am not very familiar, but I am willing to
learn.

"John Bundy" wrote:

You can do it through code no problem, but I am a big fan of auto-filters as
well. I think they are very powerful if you know how to use em. Have you
tried them?
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"PerplexedinKY" wrote:

I need a formula that can find all instances of a record. For example I may
8 different instances where store #805 has an entry. I want to be able to
type in the store number have excel return all eight values from the seperate
entries. So far I have used index(match. But that formula only gives me the
first record in the list. I need to have them all. Any suggestions?

I appreciate the help John. I want to create a seperate sheet to function as
a recap for all of the records. On the recap sheet, I want a list of all my
stores. And then of the coresponding data from the multiple entries listed
on other sheets. The Filters would not let me reference data on inactive
sheets. Any other thoughts?

"John Bundy" wrote:

If you highlight the head row, say row 1 by clicking the one. Now select
Data-Filter-Auto Filter, this will make drop down boxes for each column.
Now you can filter the columns using the drop boxes by making a selection or
using custom to choose between options etc. For your instance below you just
click the drop down for store and select 805 and it will filter by that store.
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"PerplexedinKY" wrote:

I have not tried them yet. As I am not very familiar, but I am willing to
learn.

"John Bundy" wrote:

You can do it through code no problem, but I am a big fan of auto-filters as
well. I think they are very powerful if you know how to use em. Have you
tried them?
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"PerplexedinKY" wrote:

I need a formula that can find all instances of a record. For example I may
8 different instances where store #805 has an entry. I want to be able to
type in the store number have excel return all eight values from the seperate
entries. So far I have used index(match. But that formula only gives me the
first record in the list. I need to have them all. Any suggestions?