Working in Excel with a lot of data may be difficult. Some values allow for several repetitions and make us go through the process of how to count unique text values in excel.