Unique Data

Crughp

New Member
Joined
Nov 23, 2020
Messages
13
Office Version
  1. 2019
Platform
  1. Windows
Good afternoon,

I have a long list of Windows versions from around 10,000 machines in my environment. I am trying to get a unique list of the values to print on another sheet. Obviously I can use the =UNIQUE(Range) formula when I am using office 365, but I am trying to get the formula so that I can run it in Office 2019. The name of the sheet where the values are stored is BossDesk. The name of the sheet that I am trying to print them out on is WindowsVersion2Name. I have tried several combinations of INDEX, COUNTIF, MATCH, and IFERROR, but none of them seem to return the values I am looking for.

The workbook is macro enabled for other reasons, but I can't seem to get this to work in a non macro format.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
50,599
Office Version
  1. 365
Platform
  1. Windows
You're welcome & thanks for the feedback.
 

Some videos you may like

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

Watch MrExcel Video

Forum statistics

Threads
1,118,192
Messages
5,570,771
Members
412,340
Latest member
nikitesh95
Top