• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Using MConcat to list occurances within a Date Range

C

chip_excel

New Member
Hi Everyone,

I use MConcat a good bit to easily list reoccurring information based on a value. My Go to formula has been:


=IFERROR((MCONCAT(UNIQUEVALUES(OFFSET($B$1,MATCH(A2,$A$2:$A$2000,0),,COUNTIF($A$2:$A$2000,A2))),"

")),B2)


This will concatenate all the values in Column B for each time a value occurs in the specific column A cell.

The problems is I would like to add an IF argument that utilizes date ranges before returning the information.


So column 1 has a list of events, column 2 is the start date, column 3 is the finish date and column 4 is where the formula sits.

So, let's say the dates for Event 3 are in between the date ranges of Event 1 and 2.

The formula would concatenate something to the effect of: Occurs during: Event 1, Event 2.

Let me know if you need any further information or an example workbook.

Chip
 
Hi Team!


MCONCAT & UNIQUEVALUES are part of an ADD-INS created by Asish Mathur..


http://www.ashishmathur.com/tag/mconcat/


Hi Chip!


Welcome to the forum..

For fast response, you can directly post in Asish's forum..

Otherwise..

You have to read a long information from below URL

http://chandoo.org/forums/topic/using-mconcat-to-list-occurances-within-a-date-range

+ you have to post the ADD-INS & Sample File & expected output..


Regards,

Deb
 
You must log in or register to reply here.
Back
Top