| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I find all items with the same value without using filters
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I find all items with the same value without using filters
Could you try conditional formatting -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=558727 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I find all items with the same value without using filters
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I find all items with the same value without using filt
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I find all items with the same value without using filt
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I find clearing items in a column in Excel? | Excel Worksheet Functions | |||
| Macro: Find and replace | Excel Discussion (Misc queries) | |||
| find | Excel Worksheet Functions | |||
| Help: Multiple filters with mutually exclusive items | Excel Discussion (Misc queries) | |||
| multiple items in database | Excel Worksheet Functions | |||
Linear Mode
