Hi,

I have got the hand of consolidating data from multiple sources, but
when I consolidate non-numeric data - i.e text, it returns 0 by
default for these columns. Is there anything I can do to consolidate
and retain text items?

Thank you!

there is only one way to consolidate text.

in your to consolidate areas make sure to have text in only the top row
or left column.

then when you se the date >> consolidate option check the marks.

this will not consolidate values, but take only the text from the 1st
roe and left column.

for aother values in the to consolidate areas you can only use a
statistical function like max,min,average,variation,standarddeviation.

there are no statistical functions concerning text.

hth

greets,

sybolt

Please, PLEASE, respond to the ORIGINAL thread.

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"sybmathics" <(E-Mail Removed)> wrote in message
news:45db4e66$0$18979$(E-Mail Removed)...
> there is only one way to consolidate text.
>
> in your to consolidate areas make sure to have text in only the top row or
> left column.
>
> then when you se the date >> consolidate option check the marks.
>
> this will not consolidate values, but take only the text from the 1st roe
> and left column.
>
> for aother values in the to consolidate areas you can only use a
> statistical function like max,min,average,variation,standarddeviation.
>
> there are no statistical functions concerning text.
>
> hth
>
> greets,
>
> sybolt