mconcat

Hi, I am trying to create a column that will denounce if a given date range falls within another. Here is what it would look like in a perfect world with the formula in the cells of column D. The formula would return all event instances that are shared with the start and finish date. <tbody>...

I'm trying to display hyphenated numbers in a range (e.g. 001-001-001 as one cell's contents) concatenated with a comma in between except the last number can't have a comma following it. I have a vertical array of these hyphenated numbers (Assessor Parcel Numbers that often start with a zero)...

I have scoured this forum for the answer, but this issue doesn't seem to have been addressed yet. Here's the deal. I am using a formula that searches through a separate sheet for all text strings that match up with a certain Billing ID and Date. On that separate sheet, each of the text strings...

This is my very first post on this forum, and I've exhausted my search to hopefully ensure that my exact question hasn't been answered before (though if I'm wrong, a link to the correct post would be greatly appreciated!). I consider myself much more advanced than an "average" user, but much...