Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a "table" that I created. It's just a basic grid with items on the y
axis and items on the x axis (ex. types of fruit on the top, number of fruit in the basket down the side). I need to pull the numbers of fruit in each basket, without adding them up, and combine them into one line, separating each with a comma. (Ex. 3, 4, 5, 6, 7, 8,...). I was able to do that by using "&", however, if there is no fruit in the basket (0), how can I not have a comma with a blank space appear until I do have fruit again (ex. 2,3,4,15,16,17,18,19,25 instead of 2,3,4,,,,,,,,,,,,,15,16,17,,,,,,,,,18,,19,,,,,,,25 )? I have the possibility of 144 entries, but also the posibility of only 1 entry. I'm trying to stay away from an "IF" function because it may end up very involved. Any help is greatly appreciated. I'm sorry if I didn't explain it well!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
macro call | Excel Discussion (Misc queries) | |||
I'm not sure what you'd call it, but is it possible to do this? | Excel Discussion (Misc queries) | |||
Call Center Management: How to calculate 'cost per call' | Excel Discussion (Misc queries) | |||
Don't know what to call what I need? | Excel Worksheet Functions | |||
how i can call the function | Excel Worksheet Functions |