How to find out duplicate value on the row and delete it. Need help!

[Paul_Danyliuk]

Hey Joco,

Take a look at my solution here. It marks rows with data that already appeared before as duplicates:

Calculate values based on unique dates

Chiming in. First of all, I think the fact that you can have multiple entries with the same date and number of rooms is the problem itself. And the best way to approach your need would be to get rid of duplicates in the table in the first place. But let’s assume that for some reason it’s not possible. Logically I’d approach the problem in the same spirit: Determine if a row is a duplicate of already present row — I’d make a separate column for that Then calculate only rows that aren’t duplic…

In that case each row has an ID, so to only search for duplicates in previous rows, I can filter those down to id < thisRow.id. If your table doesn’t have an ID system, you can create a Row ID column (e.g. by clicking the blue “add column” button → Properties → Row ID) and use that.