Any formula which can remove the duplicate on each row which shown in the results on worksheet? Thank you in advance
Any formula which can remove the duplicate on each row which shown in the results on worksheet? Thank you in advance
D2
{=textjoin(" & ",,if(match(a2:c2,a2:c2,)=column(a2:c2),a2:c2,""))}
Sorry it came out an error "You 've entered too few of arguments for this function"
press CTRL + Shift + Enter at the same time. You should see curly braces {} if it's entered correctly
Sorry it still didnt work for me. Can you apply your formula into the worksheet directly?
The attachment is here
Thank you for your help
There are error #VALUE shown out when there are blank cell in the group item, how to solve it?
Last edited by alferd324; 02-09-2021 at 12:24 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks