Formula???
=SUM(B2:B5)&" "&B1&CHAR(10)&SUM(C2:C5)&" "&C1&CHAR(10)&SUM(D2:D5)&"
"&D1&CHAR(10)&SUM(E2:E5)&" "&E1
and format for WordWrap..........all on one line
Vaya con Dios,
Chuck, CABGx3
" wrote:
I IHAVE THIS TABLE:
A B C D E
_______________________________
1 dogs cats birds fish
2 here 2
3 there 1
4 up 3
5 down 4
And need a formula to output this:
2 dogs
1 cats
3 birds
4 fish
|