I have a sheet with 10 columns that I need to classify as follows.
Classifications are based on completeness of data.but I'm not sure that these will be mutually exclusive or how to write the formula.
If columns A-J are not blank, value = Gold
If columns A-G are not blank and either H, I or...