Multiple IF statements

  • Thread starter Thread starter vcobra57
  • Start date Start date
V

vcobra57

Hello,

I was wondering if there is a shorter formula for this:

In column A have different numbers as such:

3331709
3736790
3736790
3746732
3310141

In cell B1, I would like to return:

3331709, 3736790, 3746732, 3310141

Notice I don't want to return similar (duplicates) numbers twice, just
the unique ones. Also I need the comma and space between the numbers.

Thanks in advance,
SA Spurs
 
I'm sure there are multiple solutions, but this is what I
would do.

- Sort column A
- Insert a columb before A
- in that column in cell A2 "=if(a2=a1,"1"," ")" and copy
this down to the last entry in your series.
- Then copy all of column A and paste special column A
as values
- Sort by column A and delete all rows with a 1 in column A
- Delete column A
- Then copy the remaining series in column a and paste
special and check the "transpose box"

I think this is what you're after. If not please post
again.

Eric
 
Thanks for you help but that's not what I'm looking for. Actually,
these numbers are purchase order numbers and I'll be pulling it from a
separate sheet from four unique cells example B55, B59, B65 and B77.
Other data will be between these cells.

All I want to return is these four numbers, but only the unique one.
This is what I did and it works but I'm looking for another solution.

=IF(A1>1,A1," ")&IF(A2<>A1,CONCATENATE(", ",A2),"
")&IF(AND(A3<>A2,A3<>A1),CONCATENATE(", ",A3),"
")&IF(AND(A4<>A3,A4<>A2,A4<>A1),CONCATENATE(", ",A4)," ")

Hope this is clearer...

SA Spurs...
 
Yea, explaining your situation via this medium can be very
difficult.

Is it feasible for you to sort out the duplicates first,
and then concatenate?
 
Back
Top