The UNIQUE Function output depends on the program: Note that in Excel 365, the UNIQUE Function is not case sensitive, but in Google Sheets it is. This is a dynamic array function where the size of the results list does not need to be defined, and it will automatically shrink and grow as the input data values change. In this example, the list extended itself to cover E3:E5 to show all 3 unique Product Group values. When this formula is entered, a list is automatically created below the cell to show all unique values found within the Product Group data range.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |