K
K
Korret2020-06-30 11:26:52
Google Sheets
Korret, 2020-06-30 11:26:52

How to output rows by unique values ​​in a column?

There is an original table on the sheet MTZ harnesses.
https://docs.google.com/spreadsheets/d/19xvtqcwvc3...
It is constantly updated with new lines. You need to create a similar table in which there will be no duplicates in column H. The rest of the differences in the rows are not important, no matter which of the duplicate rows will be in the new table.

Answer the question

In order to leave comments, you need to log in

2 answer(s)
A
Alexander Ivanov, 2020-07-01
@Korret

The formula for this task is SORTN
=SORTN('МТЗ жгуты'!A2:U;9^9;2;8;1)
5efc0f124c1e8749292266.png
https://docs.google.com/spreadsheets/d/19KLwEdHYC-...

N
Noir, 2020-06-30
@PolarBearGG

https://docs.google.com/spreadsheets/d/19xvtqcwvc3...
L:U

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question