Page 1 of 1
Join text
Posted: Sat Oct 16, 2021 4:45 pm
by 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
Re: Join text
Posted: Sat Oct 16, 2021 5:59 pm
by 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
Re: Join text
Posted: Sat Oct 16, 2021 8:01 pm
by 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
Re: Join text
Posted: Sat Oct 16, 2021 9:17 pm
by 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
Re: Join text
Posted: Sun Oct 17, 2021 6:13 am
by 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?
Re: Join text
Posted: Sun Oct 17, 2021 9:16 am
by 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
Re: Join text
Posted: Mon Oct 18, 2021 10:32 am
by sna
Thank you