Several tests on the Same Object need help with Report and Layout

elongo

I have an experiment where I test object a, b, c, d. The variables (columns) will be height, weight, fill with fluid etc. however I might have changes for the test objects and re-run the experiment where I poke a hole in (a) and therefore need it to be tested again. How do I create a report that shows all tests a-d and then highlight the ones that were duplicates. Essentially it would throw off my data wouldn't it?

prime_nathaniel

@elongo

The most common way to check for duplicates is to countif(range, key@row). Ie count all objects where the object key might = A. If you have 2 or more entries for A now it will show as 2. You can further this approach by handling with an if() then where if(countif(range, key@row) > 1, "Duplicate", "") which would return the word "duplicate" rather than an integer count. You can then add this to your report or sheet filter as field contains duplicate, count >= 2 or if you want to do boolean you can have it return "true"/"false" in a duplicate column and use that as your filter.

note that text compare is the technically the slowest form of comparison vs number compare or boolean compare. That said it's trivial at anything except the largest data sets.