Hi, I've been dredging through the forums and for the life of me can't find the example I need. I have a long list of about 3000 user accounts. I want to create a consolidated list of the user accounts on another sheet where the status cell (Column A) is equal to a specific value. I want this in a separate sheet so I've been trying to find the perfect array formula.
Summarize. List rows where a cell A meets criteria (Value "L" for locked or something similar)
Can you help!?
Try the auto filter.
"Data", "filter", "autofilter"
You can now choose/display the value you want from column A from the dropdown list.
If you found the solution to your question. Mark the thread as "Solved"
Thank everyone that helped you with a valid solution by clicking on their
There is no such thing as a problem, only a temporary lack of a solution
It sounds like you should be using a Data Filter Advanced Filter, which copies the filtered data to another sheet subject to any criteria you set.Originally Posted by kmurray24
Hi, I've been dredging through the forums and for the life of me can't find the example I need. I have a long list of about 3000 user accounts. I want to create a consolidated list of the user accounts on another sheet where the status cell (Column A) is equal to a specific value. I want this in a separate sheet so I've been trying to find the perfect array formula.
Summarize. List rows where a cell A meets criteria (Value "L" for locked or something similar)
Can you help!?
HTH
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks