Forum Discussion
Function that automatically highlights cells with out of spec results for several parameters
Hello everyone, I'm developing a QA lab at a small craft brewery and trying to get better documentation. We recently started keeping track of several parameters for the brands that we produce (ABV,...
VLOOKUP(), XLOOKUP(), INDEX()/MATCH(), FILTER() all these functions should work in this case. Would you please post few sample data and expected output? You may attach a sample excel file to your post.