how can i show the cell values in one cell instead of summ

[kaan]

ineed to show the matched cell values in one cell instead of =SUMIF($E$14:$E$35;M3;$F$14:$F$35) which formula should i use

[martindwilson]

i'd do it like this

[Richard Buttrey]

Or another option (since the ability to concatenate Excel array values) is sadly lacking, the following User Defined function

To use it enter: =Displayvalues(A2:B23,D2)

Please Login or Register  to view this content.

[kaan]

Thx, it shows the result what i am seaching, but i do not have possibility to change the seach coloumbs or add a new coloumb. whitout adding coloumb c and coloumbs n:w, can you show the result?

thx again

[kaan]

question to Richard Buttrey:
where and how should i enter code in excel: I am biggener

[kaan]

Richard, thx, it works

[kaan]

Thx, martindwilson, i used the soluton of richard buttrey by using your links above (how to insert code)

[darknation144]

If you have received a satisfactory answer please mark this thread as solved.