How do I find all items with the same value without using filters

[Fiona-NZ]

I have a spreadsheet that I have a main set of data with varying status' eg
active, pending, completed.
In another shhet in the same workbook, I would like to identify all items
with a specific status ie active, and I do not want it to display duplicates.
Is there a formula that I can use to achieve this?
I have unique identifiers in the first column (a) and have attempted to do
this by having the status as the first column instead of the unique
identifier using basic vlookups, IF and AND statements.
I do not want to use filters and copy and paste my identifiers if I can help
it.

Thank you in advance!!
Fiona

[davesexcel]

Could you try conditional formatting

[Max]

Perhaps you might also want to try this sample from my archives*:
http://savefile.com/files/9260836
AutoCopy_Data_To_Resp_Sheet_Non_Array_Approach.xls
(Full details inside)

If it suits, think you could adapt it quite easily. Your key col would be
the statuses col: active, pending, completed, which corresponds with the key
col A (colors col: red, green yellow) in the sample. The set-up essentially
auto-copies all lines by status to it's own sheet from a mastersheet.

*archives link in sign-off below
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Fiona-NZ" wrote:
> I have a spreadsheet that I have a main set of data with varying status' eg
> active, pending, completed.
> In another sheet in the same workbook, I would like to identify all items
> with a specific status ie active, and I do not want it to display duplicates.
> Is there a formula that I can use to achieve this?
> I have unique identifiers in the first column (a) and have attempted to do
> this by having the status as the first column instead of the unique
> identifier using basic vlookups, IF and AND statements.
> I do not want to use filters and copy and paste my identifiers if I can help
> it.
>
> Thank you in advance!!
> Fiona
>

[Fiona-NZ]

Hi Max,
I think that your spreadsheet will help. I just need to adapt it, and it
should work!!

Thanks very much!!
Fiona

"Max" wrote:

> Perhaps you might also want to try this sample from my archives*:
> http://savefile.com/files/9260836
> AutoCopy_Data_To_Resp_Sheet_Non_Array_Approach.xls
> (Full details inside)
>
> If it suits, think you could adapt it quite easily. Your key col would be
> the statuses col: active, pending, completed, which corresponds with the key
> col A (colors col: red, green yellow) in the sample. The set-up essentially
> auto-copies all lines by status to it's own sheet from a mastersheet.
>
> *archives link in sign-off below
> --
> Max
> Singapore
> http://savefile.com/projects/236895
> xdemechanik
> ---
> "Fiona-NZ" wrote:
> > I have a spreadsheet that I have a main set of data with varying status' eg
> > active, pending, completed.
> > In another sheet in the same workbook, I would like to identify all items
> > with a specific status ie active, and I do not want it to display duplicates.
> > Is there a formula that I can use to achieve this?
> > I have unique identifiers in the first column (a) and have attempted to do
> > this by having the status as the first column instead of the unique
> > identifier using basic vlookups, IF and AND statements.
> > I do not want to use filters and copy and paste my identifiers if I can help
> > it.
> >
> > Thank you in advance!!
> > Fiona
> >

[Max]

Great to hear that, Fiona !
Thanks for the feedback ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Fiona-NZ" wrote:
> Hi Max,
> I think that your spreadsheet will help. I just need to adapt it, and it
> should work!!
>
> Thanks very much!!
> Fiona