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.
Bookmarks