Keeping track of the multiple levels ofIFstatements can be tricky which is whyIFSis so useful. MAXIFS Function Equivalent Instead of this MAXIFS(A1:A10,B1:B10,"value") You would use an array formula (useCTRL+SHIFT+ENTERwhen entering) using a combination of theMAXandIFfunctions suc...
I have a similar problem with TextJoin - I'm working on Mac, but this seems to behave the same on either Mac or Windows. Because this needs to work on both platforms, VB macros aren't a workable solution. I'm doing a lot of CONCAT statements to build a ...
I have a similar problem with TextJoin - I'm working on Mac, but this seems to behave the same on either Mac or Windows. Because this needs to work on both platforms, VB macros aren't a workable solution. I'm doing a lot of CONCAT statements to build a configuration ...
1 Ledger Ledger I want to create a string with these joined together with a tab delimiter. When I copy the result in E3 and paste into my other application Excel adds double quotations marks: "1 Ledger Ledger" I thought it was something my other application was doing, but...
I want to create a string with these joined together with a tab delimiter. When I copy the result in E3 and paste into my other application Excel adds double quotations marks: "1 Ledger Ledger" I thought it was something my other application was doing, but e...
Hi All Any ideas why this is not working please? If I do a TEXTJOIN for just VACANT rooms it works fine, but if I add in the AND function for both VACANT and Single it returns nothing. =T... newbjohny AND returns a single TRUE/FALSE value, not an array. Try ...