Match Single Numeric Criteria and Return Multiple Numeric Labels

  • Thread starter Sam via OfficeKB.com
  • Start date
S

Sam via OfficeKB.com

Hi All,

I have two Columns of data: Column "E" houses the Numeric Labels and Column
"F" houses the Numeric Values. Column "F" will have genuine duplicate values
that should be included.

The criterion value will vary. I would like to find / match all values
(duplicates included) that are equal to 1 (in Column "F") and then have all
their corresponding adjacent Numeric Labels returned from Column "E" to a
single cell, if possible. If not, then returned to individual cells on the
same Row.

Thanks
Sam
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Match Single Numeric Criteria and Return Multiple Numeric Labels 3
Return Numeric Labels that have different Numeric Values 8
Match Multiple Criteria & Return Numeric Labels across single row 8
Search Column Data and Return Multiple Values across Row 3
Return Numeric Labels that have Values >=4 across Single Row 3
Return across Row Numeric Values Matching EXACT Month & Year for Criteria 8
Exclude #N/A values and Return Numeric values to consecutive cells in Single Row 5
Return Numeric Value to their Matched Value Position in Single Column 3

Top