(albeit incorrectly)
why i couldn't think about it.. ??Google sheets:
In A1 of the sheet you want the results in, type:
=unique(Data!B1:E22)
and press Enter.
I have data in four columns, and would like to copy all data excluding the duplicate row.
Attached the file for explanation.
Yes the same result i want .. and i got it by using advance filter in excel.Hi Juniad,
Is the sheet called "manual result" the result you want to have after filtering? Because I don't get the result using only advanced filter in excel...
Thanks
Yes the same result i want .. and i got it by using advance filter in excel.
Because all the rows are already unique if you include column A.Why it doesn't work when you select the entire table?