I have data that looks like so
A......................B.......................C......................D....................E...................F..................G
1 257.75................54 ...................85......................75..................241................95.................80
How do I take The Data in Column A,D,G And put it in Column M
Thank you
Hi,
Maybe if you want the values as a text string
=A1&", "&D1&", "&G1
If you want the sum then simply
=A1+D1+G1
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Something that looks like this
K...L......M............N
..........257.75
..........75
..........80
There are many many rows of data so a formula that could be put in M1 and copied down would be best??
Thanks for your time.
..that formula I gave you was meant to be put in M1 and copied down.
But why do you now show just the column A value of 257.75 in column M when you were asking for three column values?
Maybe it would be better if you upload your workbook and manually add the results you expect in column M
Capture.JPG
I made a quick example of what were looking for
The data that starts in row c2 is what i want to put into a column like it is in column A. Every 4th row
Thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks