Join text

[sna]

Hi Dear
I need your help if same cells in multiple sheets (cell E9)have text "A" in sheet ALL it would concatenate sheet names in cell E9.
I upload a template for your reference

Is it possible?

Thanks

[norkaz]

...

It looks like your sample template is quite difficult to understand because of some alphabet type.

Could you please provide the easier sample template?

Norkaz

[sna]

Hi Dear ,

This file I got from my co worker
A7 is month\day
B7:AF7 are numbers like 1,2,3...31
A8:A19 are months like Jan,Feb,Mar...Dec
the main point is B8:AF19 which contains letter A .A stands for Annual Leave.


Thanks

[norkaz]

...

Hi Guy,

Not sure that I did catch your point.

Hope this helps.


(Sheet ALL)

E9
=MID(IF('1579'!E9="A","-1579","")&IF('3644'!E9="A","-3644","")&IF('0297'!E9="A","-0297",""),2,99)


Norkaz

[sna]

yes that's it but this is sample , actually thee are many sheets up to 24 Sheets ,can we use TEXTJOIN in this case?

[norkaz]

...

E6..xxx6

Entry worksheet names..

E9

=MID(CONCAT(IF(INDEX(T(INDIRECT("'"&$E$6:$G$6&"'!"&ADDRESS(ROW(E9),COLUMN(E9),4))),0)="A","-"&$E$6:$G$6,"")),2,99)


Norkaz

[sna]

Thank you