COUNT UNIQUE VALUES IN A RANGE IN EXCEL
In this video I demonstrate how to use a count unique values in a range in Excel. First, I create named ranges from selection. Then I copy the name of the fields to another sheet. I replace the spaces with an underscore and then use Excel's INDIRECT function to refer to the named range. Then I use the Unique function to return unique records/values in the range. Finally, I use the COUNTA function to count.
ACCESORIES
Screen Recorder: https://screencast-o-matic.com/screen...
Microphone/Headset: https://www.amazon.com/s?k=kotion+eac...
#MsExcel #Trending #Excel #MVP #ExcelMVP #Count #Counta #CountUnique #UniqueFunctionInExcel #Unique #Indirect