+ Reply to Thread
Results 1 to 7 of 7

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

  1. #1
    Registered User
    Join Date
    05-05-2015
    Location
    Blantyre, Malawi
    MS-Off Ver
    2013
    Posts
    18

    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
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor dosydos's Avatar
    Join Date
    12-09-2015
    Location
    Agawam, MA
    MS-Off Ver
    Microsoft Office 365
    Posts
    843

    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. #3
    Registered User
    Join Date
    05-05-2015
    Location
    Blantyre, Malawi
    MS-Off Ver
    2013
    Posts
    18

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

    Quote Originally Posted by dosydos View Post
    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. #4
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, Office 365
    Posts
    12,023

    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: copy to clipboard
    Please Login or Register  to view this content.
    Dave

  5. #5
    Registered User
    Join Date
    05-05-2015
    Location
    Blantyre, Malawi
    MS-Off Ver
    2013
    Posts
    18

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

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

  6. #6
    Registered User
    Join Date
    02-26-2016
    Location
    VietNam
    MS-Off Ver
    2010
    Posts
    5

    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. #7
    Registered User
    Join Date
    05-05-2015
    Location
    Blantyre, Malawi
    MS-Off Ver
    2013
    Posts
    18

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

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

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula that sums a column and puts totals of 24 in other columns
    By Beitz75 in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 11-10-2015, 08:06 PM
  2. can a columns formula change when the column reaches different totals
    By whatwentwrong in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-22-2014, 12:49 PM
  3. Macro to loop between multiple columns and copy the text in one column
    By Manish_Gupta in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-14-2013, 06:41 AM
  4. MAcro to - copy, transpose, text to columns, remove column A, combine all columns in 1
    By galvinpaddy in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 02-07-2013, 08:48 AM
  5. Add like text totals of columns at bottom of column
    By duugg in forum Excel Programming / VBA / Macros
    Replies: 25
    Last Post: 07-08-2009, 11:03 AM
  6. Trying to copy text from 4 columns into 1 column with HTML?
    By evolart in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-18-2005, 02:25 PM

Bookmarks

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