Forum Discussion

its_the_wil's avatar
its_the_wil
Copper Contributor
Jan 31, 2023

Delete hidden quotations from concat formula

Hi, im using concat function to merge between "Hlookup" & column Name  so i can choose different column every time the problem is when i use concat function it returns column name rounded with tow h...
excel
HansVogelaar's avatar
HansVogelaar
MVP
Feb 02, 2023

its_the_wil 

Does this do what you want?

 

=COUNTIFS(StaffTBL[Position],"Head Teacher",StaffTBL[Gender],"MALE",INDIRECT("StaffTBL["&TEXT(TODAY(),"mmm-yyyy")&"]"),"Active")

its_the_wil's avatar
its_the_wil
Copper Contributor
Feb 02, 2023

HansVogelaar 

Hi ,thanks for responding anyway but its not what i need , u cant use (today)..