Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello,
I'll first give an example of my situation. I've got a couple of value's: A B 1 55 1 56 2 58 3 59 1 60 I'm looking for a method so i can make a list like this: A B 1: 55,56,60 Basicly Excel has to put the value's in the following cell divided by a , I've come as far as making an IF function like IF(A1:A3="1";B1:B3;"Error") Now the list of numbers (55,56,60) is in an array. Is there any way to convert this array to the format i described? Greetings, Gunti |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
combo box and value's | Excel Discussion (Misc queries) | |||
Converting column to array | Excel Worksheet Functions | |||
delete zero value's using a macro | Excel Worksheet Functions | |||
Sum amount if = 2 value's | Excel Discussion (Misc queries) | |||
Multiple lookup value's | Excel Worksheet Functions |