Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Concatenate values based on array
I have a table with column ranges for Job survey codes, job titles, and
annual salaries. One of my formulas returns an average annual salary for the specific job codes; using ranges, my array formula is: {=AVERAGE(IF(SurveyCode=A2,Fiscal06))} However, more than one title can map to a job code. If I have the above in cell B2, is there a way to concatenate the job titles associated with the job code that is being averaged? For example, let's say I have two jobs, Truck Driver I and Truck Driver II, with respective salaries of $40,000.00 and $50,000.00. My formula above returns to cell B2 "$45,000.00," and I would like to return in C2 "Truck Driver I; Truck Driver II." Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Concatenate values based on array
You can try using CONCATENATE operator
On Jan 25, 10:55 pm, "TomorrowsMan" wrote: I have a table with column ranges for Job survey codes, job titles, and annual salaries. One of my formulas returns an average annual salary for the specific job codes; using ranges, my array formula is: {=AVERAGE(IF(SurveyCode=A2,Fiscal06))} However, more than one title can map to a job code. If I have the above in cell B2, is there a way to concatenate the job titles associated with the job code that is being averaged? For example, let's say I have two jobs, Truck Driver I and Truck Driver II, with respective salaries of $40,000.00 and $50,000.00. My formula above returns to cell B2 "$45,000.00," and I would like to return in C2 "Truck Driver I; Truck Driver II." Thanks! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Concatenate values based on array
DJ,
Sorry, I wasn't clear; I know I need to use CONCATENATE, but I don't know how to write the formula to concat each of the returned values in the array. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
return values from an array based on more than one criteria | Excel Discussion (Misc queries) | |||
Finding the Max, Min values based on certain criteria for an array | Excel Discussion (Misc queries) | |||
How do I add multiple values in an array based on multiple hits? | Excel Discussion (Misc queries) | |||
return values from an array based on matching text value | Excel Worksheet Functions | |||
Concatenate an array | Excel Discussion (Misc queries) |