Create list returning unique criteria covering several columns using arrays

**joannelittell** · 05-24-2013, 03:30 PM

Thought it was solved, but discovered I was wrong.

I have partially figured this out and have attached a document with what i have.

I have a list of projects, document names, THREE testing points, etc. The goal is to asses if testing was NOT completed for a specific testing point and returns a list containing several bits of criteria that is unique to "document name".

I am able to create a list that assesses only ONE testing point and it is not unique to "document name".

Thanks in advance!
Joanne

tracking2.xlsx

**Lemice** · 05-24-2013, 04:37 PM

Hello,

Here is a file with array formula that will do that job.

I suggest you don't use reference that involve the entire column since it will make Array formula, which is slow and resource-consuming by nature, even slower.

Also note that I only make array formula to find and filter unique data. The rest should be easy to you, right?

Create list returning unique criteria covering several columns using arrays

LinkBack

Thread Tools

Rate This Thread

Display

Create list returning unique criteria covering several columns using arrays

Re: Create list returning unique criteria covering several columns using arrays

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions