Results 1 to 10 of 10

Concatenate unknown number of cells with commas and "and" before the last number

Threaded View

tomtheappraiser Concatenate unknown number of... 10-23-2013, 02:37 PM
hectop Re: Concatenate unknown... 10-23-2013, 03:12 PM
tomtheappraiser Re: Concatenate unknown... 10-23-2013, 03:26 PM
hectop Re: Concatenate unknown... 10-23-2013, 03:58 PM
tomtheappraiser Re: Concatenate unknown... 10-23-2013, 04:09 PM
hectop Re: Concatenate unknown... 10-23-2013, 05:44 PM
tomtheappraiser Re: Concatenate unknown... 10-23-2013, 06:02 PM
martindwilson Re: Concatenate unknown... 10-23-2013, 06:43 PM
tomtheappraiser Re: Concatenate unknown... 10-30-2013, 12:13 PM
tomtheappraiser Re: Concatenate unknown... 10-24-2013, 09:06 AM
  1. #1
    Registered User
    Join Date
    07-28-2011
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    16

    Concatenate unknown number of cells with commas and "and" before the last number

    I've tried searching for this, but I'm probably just not using the correct keywords. Anyway:
    I have a template adjustment grid that I use to adjust comparable sales. From this adjustment grid, I mail merge the minimum and maximum adjusted amounts, final value, etc into a word report. Generally I use 3-5 comparable sales. So there will be 3-5 columns with adjustment amount in different rows to account for difference in the properties. So, for instance if I had 5 comps, maybe comps #2,4 & 5 I adjusted downward for their location. Then maybe Comps #1, 2 & 3 I adjusted upward for size.
    Now, what I want to do is have one cell for each adjustment group (size, location etc). In each of those cells I want it to look at the range of the comparables, for instance, in the location category, check b4:f4 to see if they were adjusted downward or upward and then, using my previous example, fill that one cell with the concatenated comp #s of only those cells adjusted. The one cell would look like this for the location category: #2, #4, & #5
    So my problem is I never know which cells will be adjusted so I can't just do: =concatenate c4&", "&e4&", &"&f4 because I'll never know which cells will be adjusted in each different report. I wondering if there is away that it would automatically be able to check which ones were adjusted and when to put the "&" symbol before the last one I adjusted. It could be 2 cells or it could be 5.
    Does this make sense? I know, it's confusing and hard to explain. I've attached a picture that might help.

    Any help would be much appreciated.
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Custom data validation whole number or "unknown"
    By moorzee in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-09-2013, 07:34 PM
  2. Unknown number of "if"
    By robmis in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-21-2012, 06:50 AM
  3. Copying an unknown number of cells in Sheet1 to Sheet2 starting from "F2"
    By blurtoad in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-26-2007, 07:27 AM
  4. Replies: 1
    Last Post: 06-30-2006, 07:14 AM
  5. Replies: 1
    Last Post: 06-23-2006, 10:20 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