+ Reply to Thread
Results 1 to 4 of 4

distribute cell comments to custom columns

  1. #1
    Registered User
    Join Date
    04-23-2013
    Location
    Winnipeg
    MS-Off Ver
    Excel 2007
    Posts
    58

    distribute cell comments to custom columns

    I am building a list of university supporters based on their constituent code. My export into excel includes a variety of possible codes. They are not presented in a uniform order. One person may be an alumnus, a board member and a parent. Another may be listed as a parent, an alumnus and a board member. I wish to distribute the column contents so that alumni are always in the first column, board members always in the second column, and parents always in the third column, and so on for up to 20 categories. Using an if= formula, I am able to do some basic distribution of the codes, but I don't know how to account for complexities. Can I combine requests in a formula, e.g. if b12 has alumni, write alumni in b15; if b12 has board member, write board member in b16. Or do I need to write a series of indivdiual formulas?

    See tab two of attachment. annual report construction notes.xlsx

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: distribute cell comments to custom columns

    Hi,

    Not entirely sure I understand this since there seems a contradiction between the requirement that: "alumni are always in the first column, board members always in the second column..." etc. and the desired outcome cells in B18:D20

    Does Sheet 2(2) give you what you want?
    Attached Files Attached Files
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    04-23-2013
    Location
    Winnipeg
    MS-Off Ver
    Excel 2007
    Posts
    58

    Re: distribute cell comments to custom columns

    [QUOTE=Richard Buttrey;3678016]Hi,

    Not entirely sure I understand this since there seems a contradiction between the requirement that: "alumni are always in the first column, board members always in the second column..." etc. and the desired outcome cells in B18:D20

    Does Sheet 2(2) give you what you want?[/QUOTE: This reply was quick, insightful, and very useful.]

    Richard, thank you kindly. This looks very helpful. I believe what the formula is saying is "look at cells b12:d12. If any of them match cell F11, write alumni. If they don't match alumni, leave a blank." Is that about right? I added code called volunteer in column e and changed the formula, allowing me to search for volunteers also. I will work with this further. Much appreciated.

  4. #4
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: distribute cell comments to custom columns

    [QUOTE=bwiebe;3678121]
    Quote Originally Posted by Richard Buttrey View Post
    Hi,

    I believe what the formula is saying is "look at cells b12:d12. If any of them match cell F11, write alumni. If they don't match alumni, leave a blank." Is that about right? I added code called volunteer in column e and changed the formula, allowing me to search for volunteers also. I will work with this further. Much appreciated.
    Yes, that's more or less it.
    Obviously if you extend the data columns from B:D to B:?? you'll need to adjust the $B12:$D12 accordingly. This is of course relative row reference so stating the obvious it will adjust as you copy it down.

    Row 11 starting at F is where you would put the supporter types. The F$11 in the formula is this time an absolute row number and hence it doesn't adjust as the formula is copied down, but the column ref is relative so does adjust as you copy it across.

+ 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. copy cell text to comments in excel 2010 and vise versa (i.e. from comments to cell)
    By senthile in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-25-2014, 12:16 PM
  2. Replies: 15
    Last Post: 12-13-2013, 08:23 AM
  3. [SOLVED] Distribute values in columns based on match between two other columns
    By hydrgal in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-15-2013, 04:07 AM
  4. Replies: 0
    Last Post: 04-13-2012, 08:36 AM
  5. Distribute Columns over Rows
    By ziohausam in forum Excel General
    Replies: 3
    Last Post: 01-31-2009, 09:22 AM

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