[Solved] Formula for unmatched row cell and display value in one column

Native worksheet formulas simply do not handle string concatenation well. Even the new string functions that are being introduced such as TEXTJOIN function¹ and the updated CONCAT function² have difficulty with conditional concatenation beyond TEXTJOIN’s blank/no-blank parameter. Here are a pair of User Defined Functions (aka UDF) that will perform the tasks. Function udfUniqueList(rng As … Read more

[Solved] nested IF, AND, OR function compare and give result excel

Try this formula =MATCH(G5,{“Prica Plus”,”Miks S”,”Miks M”,”Miks L”,”Miks XL”,”Miks XL Plus”,”Miks XXL”,”Super”},0)-MATCH(F5,{“Prica Plus”,”Miks S”,”Miks M”,”Miks L”,”Miks XL”,”Miks XL Plus”,”Miks XXL”,”Super”},0) Above formula can be broken down in two parts. Firstly, matching Cell G5 to your values =MATCH(G5,{“Prica Plus”,”Miks S”,”Miks M”,”Miks L”,”Miks XL”,”Miks XL Plus”,”Miks XXL”,”Super”},0) Secondly, matching Cell H5 to your values =MATCH(F5,{“Prica Plus”,”Miks S”,”Miks … Read more