you need to use the EXACT function. The Excel EXACT function is used to compare two text strings and returns TRUE if both values are the same, and FALSE otherwise. You can either use EXACT alone or with the IF function (in case you want to get a descriptive result...
Suppose, you have the below table and you want to compare yesterday’s sales with today’s sales and figure out how many products have more sales today than yesterday. To do that, normally you have to compare column C against D and keep the score. But, with SUMPRODUCT, you can automate...