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.
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.