Matching Index of Repeated Dates

[S P P]

Matching Index of Repeated Dates

Corresponding index of table1 in table2 same date without repeating

 

[pecoflyer]

Your explanation is very very succinct... Whats is your logic ? ( BTW, "Hello" or " Thank you" are not considered to be offensive)

 

[Peter Bartholomew]

What you have presented looks like a filter.

= FILTER(Tabela1, (MONTH(Tabela1[Date])=month) * (YEAR(Tabela1[Date])=year))

Of course, provided you use 365, it is always possible to simplify the worksheet at the expense of more complex function

= FilterByMonthλ(Tabela1, Tabela1[Date], month, year)

where

FilterByMonthλ
=LET(
    Criterion1?, MONTH(CritDateArr) = CritMnthVal,
    Criterion2?, YEAR(CritDateArr)  = CritYrVal,
    Required?, MAP(Criterion1?, Criterion2?, ANDλ),
    FILTER(Array, Required?)
)

ANDλ
= AND(x, y)

 

[S P P]

Peter Bartholomew

Thanks for the collaboration

Your formula only works on 365, but I'm using 2019.

I'm going to have to do a userform filter between two dates.

 

[p45cal]

Power Query at cell J2. Should work in Excel 2019.
Adjust year and month in cells E3 and E5 (both named ranges) and right click the results table and choose Refresh.

ps. perhaps the dates in column B shouldn't also rely on E5?!

 

[S P P]

I managed to make the filter in userform , but it is working only in the worksheet with the data.

Can you help me with this vba

 

[S P P]

I also managed with excel 2019 using this formula