Forum Discussion
Formulas and Functions
Hi, in above table I have articles with 0 or more volume. Sometimes the article-number can appear 2 times because it is represented in 2 separate warehouses. Exercise is to show in column "Mess...
Assuming that your data are inA2:C50 with headers in A1:C1, enter the following formula in C2, then fill down:
=IF(COUNTIFS($A$2:$A$50,A2,$B$2:$B$50,0),"Availability to be confirmed","Available")