Jan 31 2023 02:00 AM
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 hidden quotes that doesn't appear unless i use the whole formula in Countifs formula ( using Fn+F9 to show results), i need to remove these hidden quotes ("") ,
i tried every solution (Substitute,mid,indirect,replace,textjoin ...) but they all bring back hidden quotes also ..
Any urgent help please
Jan 31 2023 04:28 AM
I suspect that INDIRECT would do what you want, but:
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
Feb 01 2023 11:56 PM
Feb 02 2023 12:32 AM
Does this do what you want?
=COUNTIFS(StaffTBL[Position],"Head Teacher",StaffTBL[Gender],"MALE",INDIRECT("StaffTBL["&TEXT(TODAY(),"mmm-yyyy")&"]"),"Active")
Feb 02 2023 12:43 AM
Feb 02 2023 03:04 AM
So what do you want to use instead?