{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Лист1","index":0,"n_rows":35,"n_cols":26,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["Соловьёв","Васильев","Петров","Смирнов","Михайлов","Фёдоров","Соколов","Яковлев","Попов","Андреев","Алексеев","Александров","Лебедев","Григорьев","Степанов","Павлов","Богданов","Николаев","Дмитриев","Егоров","Волков","Кузнецов","Никитин"]
["Никитин","Соловьёв","Васильев","Петров","Смирнов","Михайлов","Фёдоров","Соколов","Яковлев","Попов","Андреев","Алексеев","Александров","Лебедев","Григорьев","Степанов","Павлов","Богданов","Николаев","Дмитриев","Егоров","Волков","Кузнецов"]
["Кузнецов","Никитин","Соловьёв","Васильев","Петров","Смирнов","Михайлов","Фёдоров","Соколов","Яковлев","Попов","Андреев","Алексеев","Александров","Лебедев","Григорьев","Степанов","Павлов","Богданов","Николаев","Дмитриев","Егоров","Волков"]
["Волков","Кузнецов","Никитин","Соловьёв","Васильев","Петров","Смирнов","Михайлов","Фёдоров","Соколов","Яковлев","Попов","Андреев","Алексеев","Александров","Лебедев","Григорьев","Степанов","Павлов","Богданов","Николаев","Дмитриев","Егоров"]
["Егоров","Волков","Кузнецов","Никитин","Соловьёв","Васильев","Петров","Смирнов","Михайлов","Фёдоров","Соколов","Яковлев","Попов","Андреев","Алексеев","Александров","Лебедев","Григорьев","Степанов","Павлов","Богданов","Николаев","Дмитриев"]
["Дмитриев","Егоров","Волков","Кузнецов","Никитин","Соловьёв","Васильев","Петров","Смирнов","Михайлов","Фёдоров","Соколов","Яковлев","Попов","Андреев","Алексеев","Александров","Лебедев","Григорьев","Степанов","Павлов","Богданов","Николаев"]
["Николаев","Дмитриев","Егоров","Волков","Кузнецов","Никитин","Соловьёв","Васильев","Петров","Смирнов","Михайлов","Фёдоров","Соколов","Яковлев","Попов","Андреев","Алексеев","Александров","Лебедев","Григорьев","Степанов","Павлов","Богданов"]
["Богданов","Николаев","Дмитриев","Егоров","Волков","Кузнецов","Никитин","Соловьёв","Васильев","Петров","Смирнов","Михайлов","Фёдоров","Соколов","Яковлев","Попов","Андреев","Алексеев","Александров","Лебедев","Григорьев","Степанов","Павлов"]
["Соловьёв","Васильев","Петров","Смирнов","Михайлов","Фёдоров","Соколов","Яковлев","Попов","Андреев","Алексеев","Александров","Лебедев","Григорьев","Степанов","Павлов","Богданов","Николаев","Дмитриев","Егоров","Волков","Кузнецов","Никитин"]
["Никитин","Соловьёв","Васильев","Петров","Смирнов","Михайлов","Фёдоров","Соколов","Яковлев","Попов","Андреев","Алексеев","Александров","Лебедев","Григорьев","Степанов","Павлов","Богданов","Николаев","Дмитриев","Егоров","Волков","Кузнецов"]
["Кузнецов","Никитин","Соловьёв","Васильев","Петров","Смирнов","Михайлов","Фёдоров","Соколов","Яковлев","Попов","Андреев","Алексеев","Александров","Лебедев","Григорьев","Степанов","Павлов","Богданов","Николаев","Дмитриев","Егоров","Волков"]
["Волков","Кузнецов","Никитин","Соловьёв","Васильев","Петров","Смирнов","Михайлов","Фёдоров","Соколов","Яковлев","Попов","Андреев","Алексеев","Александров","Лебедев","Григорьев","Степанов","Павлов","Богданов","Николаев","Дмитриев","Егоров"]
["Егоров","Волков","Кузнецов","Никитин","Соловьёв","Васильев","Петров","Смирнов","Михайлов","Фёдоров","Соколов","Яковлев","Попов","Андреев","Алексеев","Александров","Лебедев","Григорьев","Степанов","Павлов","Богданов","Николаев","Дмитриев"]
["Дмитриев","Егоров","Волков","Кузнецов","Никитин","Соловьёв","Васильев","Петров","Смирнов","Михайлов","Фёдоров","Соколов","Янукович","Попов","Андреев","Алексеев","Александров","Лебедев","Григорьев","Степанов","Павлов","Богданов","Николаев"]
["Николаев","Дмитриев","Егоров","Волков","Кузнецов","Никитин","Соловьёв","Васильев","Петров","Смирнов","Михайлов","Фёдоров","Соколов","Яковлев","Попов","Андреев","Алексеев","Александров","Лебедев","Григорьев","Степанов","Павлов","Богданов"]
["Богданов","Николаев","Дмитриев","Егоров","Волков","Кузнецов","Никитин","Соловьёв","Васильев","Петров","Смирнов","Михайлов","Фёдоров","Соколов","Яковлев","Протопопов","Андреев","Алексеев","Александров","Лебедев","Григорьев","Степанов","Павлов"]
["Соловьёв","Васильев","Петров","Смирнов","Михайлов","Фёдоров","Соколов","Яковлев","Попов","Андреев","Алексеев","Александров","Лебедев","Григорьев","Степанов","Павлов","Богданов","Николаев","Дмитриев","Егоров","Волков","Кузнецов","Никитин"]
["Никитин","Соловьёв","Васильев","Петров","Смирнов","Михайлов","Фёдоров","Соколов","Яйценюк","Попов","Андреев","Алексеев","Александров","Лебедев","Григорьев","Степанов","Павлов","Богданов","Николаев","Дмитриев","Егоров","Волков","Кузнецов"]
["Кузнецов","Никитин","Соловьёв","Васильев","Петров","Смирнов","Михайлов","Фёдоров","Соколов","Яковлев","Попов","Андреев","Алексеев","Александров","Лебедев","Григорьев","Степанов","Павлов","Богданов","Николаев","Дмитриев","Егоров","Волков"]
["Волков","Кузнецов","Никитин","Соловьёв","Васильев","Петров","Смирнов","Михайлов","Фёдоров","Соколов","Яковлев","Попов","Андреев","Алексеев","Александров","Лебедев","Григорьев","Степанов","Павлов","Богданов","Николаев","Дмитриев","Егоров"]
[]
["Дмитриев","Егоров","Волков","Кузнецов","Никитин","Соловьёв","Васильев","Петров","Смирнов","Михайлов","Фёдоров","Соколов","Яковлев","Попов","Андреев","Алексеев","Александров","Лебедев","Григорьев","Степанов","Павлов","Богданов","Николаев","Янукович","Яйценюк"]
["Соловьёв","Никитин","Кузнецов","Волков","Егоров","Дмитриев","Николаев","Богданов","Васильев","Петров","Смирнов","Михайлов","Фёдоров","Соколов","Яковлев","Попов","Яйценюк","Андреев","Алексеев","Александров","Лебедев","Янукович","Григорьев","Степанов","Павлов","Протопопов"]
[]
[]
[]
[]
[null,null,"1. Нажимаем кнопку, запускаем макрос"]
[null,null,"2. Выделяем всю таблицу (область A1:W20) - жмём ОК"]
[null,null,"3. Выделяем ячейку для вывода списка уникальных фамилий, например, A25  - жмём ОК"]
[null,null,"4. Выделяем область A22:Z22"]
[null,null,"5. В ячейке A22 пишем формулу =ТРАНСП(A25:A50)"]
[null,null,"6. Одновременно вводим Ctrl+Shift+Enter"]
[null,null,"7. Итоговый результат в A23:Z23"]
[null,null,"Получилось ли то же самое у Вас?"]