Hello,
if i have data, duplicate by row how to remove duplicate data so the result is just "Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday". Because if use menu data-> remove duplicate just remove by coloumn. If i have data like this. Thanks for the respon
if i have data, duplicate by row how to remove duplicate data so the result is just "Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday". Because if use menu data-> remove duplicate just remove by coloumn. If i have data like this. Thanks for the respon
matrix_major_project (30).xlsx | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
B | C | D | E | F | G | H | I | J | K | |||
3 | ||||||||||||
4 | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | ||||
5 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | ||||
6 | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | ||||
7 | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | ||||
8 | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | ||||
9 | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | ||||
10 | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | ||||
11 | ||||||||||||
12 | ||||||||||||
Sheet5 |