H
hmm
Well, I've tried searching the archive with Google, but can't seem to find
what I'm after! So here goes:
How can I show only the values stored in a row (these values are text),
summarised into adjacent columns, ignoring blank cells in between?
************
The background:
I'm using Excel as a matrix of connected web pages arranged in a sequence.
The rows and columns have the same headings, and by reading across the rows
I can record a '1' for a link forwards in the sequence (and the columns will
then show preceding linked pages)
E.g
bananas apples oranges lemons
bananas
apples
oranges
lemons
If 'bananas' links to 'apples' and 'lemons' only, the row for bananas would
read:
0 1 0 1
I've then used an IF function to look up column heading if the cell value is
= 1 else return a blank...
....so my row reads bananas: [blank] apples [blank] lemons
And what I want to display is: apples lemons
************
Is there a neat function I'm overlooking, or should I put my VBA hat on?
Many thanks in advance,
Gavnosis
what I'm after! So here goes:
How can I show only the values stored in a row (these values are text),
summarised into adjacent columns, ignoring blank cells in between?
************
The background:
I'm using Excel as a matrix of connected web pages arranged in a sequence.
The rows and columns have the same headings, and by reading across the rows
I can record a '1' for a link forwards in the sequence (and the columns will
then show preceding linked pages)
E.g
bananas apples oranges lemons
bananas
apples
oranges
lemons
If 'bananas' links to 'apples' and 'lemons' only, the row for bananas would
read:
0 1 0 1
I've then used an IF function to look up column heading if the cell value is
= 1 else return a blank...
....so my row reads bananas: [blank] apples [blank] lemons
And what I want to display is: apples lemons
************
Is there a neat function I'm overlooking, or should I put my VBA hat on?
Many thanks in advance,
Gavnosis