I've seen on some tutorials online that this is possible, but I do not have "SINGLECELLEXTRACT" or "TEXTJOIN" available to me on Excel for Mac 2011 or 2016, nor on my Quip Spreadsheet. Is this possible using Excel for Mac (either version)?
What I'm trying to do is return the values of column B in a single, comma separated cell (column E), when the values in column A meet the criteria of column D.
Thanks,
Jeff
Screen Shot 2018-10-31 at 12.27.24.png
Bookmarks