DOC Office Consulting

Within a large range of tabular data, you may want a list containing only data sets that have a specific value. This list could contain the value of the first column of all the rows with a specific date in the third column. For example, here’s how to list all the names with a blank received date:
Read Danielle O'Connell's answer to In an Excel array, I want to list all items in the array with a non-zero value. I would like to use a formula and not a pivot table nor macro. What formula should I use? on Quora