You can search around for some workarounds. For example you apply the formula is A1B1 in Cell C1 and it will change to F12G12 as you copy it to the Cell H12. SUM--COUNTIFB2B8A2A71 This formula is an extension of the example in the section above but it adds some additional complexity.
The old style CTRL-SHIFT-ENTER array formulas still work in 2019 and this is a way to get the UNIQUE functionality in older versions of Excel.
Select the column of data from which you want to extract distinct values. UNIQUED2I2TRUE The second argument of TRUE is used to tell the function that the data is in a horizontal format. If you want to extract unique items from your workbook you can use formulas such as INDEX MATCH and COUNTIF as the workaround currently. In fact the Data Validation function of Excel can help you to solve this problem please do as follows.