Formula???
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 |
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 |
Formula???
Thanks, that was easier than it looked.
|
Formula???
You're welcome............yeah, sometimes they look pretty scary at first,
but when you break them down they're not so bad........... Vaya con Dios, Chuck, CABGx3 wrote in message ups.com... Thanks, that was easier than it looked. |
All times are GMT +1. The time now is 11:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com