If this is your first visit, then welcome! Be sure to check out the FAQ by clicking the link above.Register here so that you can post in the forums or comment on the articles.
See if this version gets you what you want (I think CONCAT was available in Excel 2016):...
See if the attached works as you want… Edit post posting, shucks, just seen you are Excel 2016. Hang on a bit. (Are macros out of the question?)...
The issue was resolved in another way - the trouble was that I inadvertently changed the field's format to Decimal early in the query. Since PQ only states...
Then C8 is not empty....
Hi I have the formula below but it returns FALSE when I want it empty if C8 cell is empty. Can you help pls? =IF(C8="","",IF(AND(K8"",O8=""),"Needs...
Knowledge Base Articles By Category
Recent Forum Posts
Display a list of columns if data is present within?
See if this version gets you what you want (I think CONCAT was available in Excel 2016):...
p45cal Today, 05:47 PM