Filter Hong Kong Holidays

Looking for a quick way to filter Hong Kong Holidays from a large data set with values every day listed with date and weekday in columns a and b.

Perhaps use column C to see if the date appears in your holiday list, and then apply the filter to that column. Assume your list of holiday dates is in column H, then a formula like this in C2:

=ISNUMBER(MATCH(A2,H:H,0))

will return TRUE or FALSE when copied down.

Hope this helps.

Pete