# Looking for formula that will copy text in columns to the end totals column

1. ## Looking for formula that will copy text in columns to the end totals column

I don't really know how best to explain this but Attached is a worksheet that has multiple columns of names and figures. At the end I have the overall totals. I have added all the figures using a simple SUM() formula, that's easy but I am looking for a formula that I can use that will also bring the names along next to the overall figures column. You can see the highlighted column in yellow is in need of the names.

Your help would be much appreciated

2. ## Re: Looking for formula that will copy text in columns to the end totals column

Put in S3
=IF(A3<>"",A3,IF(D3<>"",D3,IF(G3<>"",G3,IF(J3<>"",J3,IF(M3<>"",M3,IF(P3<>"",P3,""))))))

make sure column S is formatted as General

3. ## Re: Looking for formula that will copy text in columns to the end totals column

Originally Posted by dosydos
Put in S3
=IF(A3<>"",A3,IF(D3<>"",D3,IF(G3<>"",G3,IF(J3<>"",J3,IF(M3<>"",M3,IF(P3<>"",P3,""))))))

make sure column S is formatted as General
That works dosydos. Thank you very much

PROBLEM SOLVED

4. ## Re: Looking for formula that will copy text in columns to the end totals column

Since the names appear to be all the same across this would be another way. In S3 this formula filled down.
Formula:
`Please Login or Register  to view this content.`

5. ## Re: Looking for formula that will copy text in columns to the end totals column

Originally Posted by FlameRetired
Since the names appear to be all the same across this would be another way. In S3 this formula filled down.
Formula:
`Please Login or Register  to view this content.`
The first one works better. Not all the names are in all the columns

6. ## Re: Looking for formula that will copy text in columns to the end totals column

Formula cell S3 =LOOKUP(REPT("z",255),A3:P3)

7. ## Re: Looking for formula that will copy text in columns to the end totals column

Originally Posted by thuythanh
Formula cell S3 =LOOKUP(REPT("z",255),A3:P3)
That works as well. Thanks thuythanh

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1