List identifiers with only a numerical value

**TRAPLETT** · 06-30-2017, 04:34 AM

Hi guys,

I have two columns: one with a non-numerical identifier and the other with values. Not all the identifiers have a value though.
I would like to create a column in which all identifiers with a value are listed.

I have attached a simplified sample.

Many thanks! Cheers,

Patrizio

**Special-K** · 06-30-2017, 04:50 AM

Your results are incorrect.

Shouldnt that be

B
E
F

in E2
=IFERROR(INDEX($A$2:$A$9,SMALL(IF(($B$2:$B$9<>""),ROW($A$1:$A$8)),ROW(A1)),1),"")
Array formula, use Ctrl-Shift-Enter
and copy down as far as E9

**TRAPLETT** · 06-30-2017, 04:51 AM

Originally Posted by Special-K

Your results are incorrect.

Shouldnt that be

B
E
F

Yes, indeed. Apologies

**Special-K** · 06-30-2017, 04:52 AM

See amended reply above (post #2) for solution

**TRAPLETT** · 06-30-2017, 05:23 AM

Originally Posted by Special-K

See amended reply above (post #2) for solution

Thanks a lot!

List identifiers with only a numerical value

LinkBack

Thread Tools

Rate This Thread

Display

List identifiers with only a numerical value

Re: List identifiers with only a numerical value

Re: List identifiers with only a numerical value

Re: List identifiers with only a numerical value

Re: List identifiers with only a numerical value

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Delete rows based on the list of unique identifiers created

non numerical list comparison

[SOLVED] List of numbers in numerical order

Create List of Early Dates from Multiple Identifiers and Activities

Formula to List Possible Numerical Combinations

Vlookup for matching a list of identifiers within a cell

Return numerical list from 1 up to a maximum

Bookmarks

Bookmarks

Posting Permissions