In a previous post we created a unique distinct list of dates and data removing any duplicates on same date.

In this post we will remove duplicates within same week.

Array formula in B15:

=INDEX($B$4:$B$12, SMALL(IF(MATCH(YEAR($A$4:$A$12)&"-"&$A$4:$A$12&"-"&$C$4:$C$12, YEAR($A$4:$A$12)&"-"&$A$4:$A$12&"-"&$C$4:$C$12, 0)=ROW($B$4:$B$12)-MIN(ROW($B$4:$B$12))+1, ROW($B$4:$B$12)-MIN(ROW($B$4:$B$12))+1, ""), ROW(A1))) + CTRL + SHIFT + ENTER

Download excel sample file for this article.

Remove duplicates in same week.xls
(Excel 97-2003 Workbook *.xls)

Functions in this article:

IF(logical_test;[value_if:true];[value_if_false])
Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE

SMALL(array,k) returns the k-th smallest row number in this data set.

INDEX(array,row_num,[column_num])
Returns a value or reference of the cell at the intersection of a particular row and column, in a given range

MIN(number1,[number2])
Returns the smallest number in a set of values. Ignores logical values and text

ROW(reference) returns the rownumber of a reference

MATCH(lookup_value;lookup_array; [match_type])
Returns the relative position of an item in an array that matches a specified value

YEAR(serial_number) returns the year of a date, an integer of the range 1900-9999

WEEKNUM(serial_number, return_type)
Returns the week number in the year

Related posts:

Filter duplicates within same date, week or month in excel

Highlight duplicates on same date, week or month using conditional formatting in excel

Remove duplicates within same month or year in excel

Count unique distinct values within same week, month or year in excel

Remove duplicates on same date in excel