Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
show non-blank via formula?
Hi all -
Ok, here's my problem: I have two worksheets. The 1st sheet has data arranged like this: Item1 SubItems Date1 Date2 subitem1 subitem2 subitem3 Item2 SubItems Date1 Date2 subitem1 subitem2 subitem3 etc I would like to display only the item title (Item1, Item2, etc) on my 2nd sheet without any blank spaces between them. IOW, like this: Item1 Item2 Item3 etc The data on sheet 1 changes often so I'd like sheet 2 to be dynamicallly populated - IOW, by formula. Any ideas? thanks in advance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to show a blank cell | Excel Discussion (Misc queries) | |||
only want formula to show up if a1 is not blank | Excel Discussion (Misc queries) | |||
Diagram show blank as zero value when based on a formula | Charts and Charting in Excel | |||
=IF cell needs to show blank if blank | Excel Discussion (Misc queries) | |||
How do you nest the following formula to show blank cells | Excel Worksheet Functions |