@row referencing cell above

KirstineKirstine ✭✭✭✭✭
edited 07/26/21 in Best Practice
11/26/20 Edited 07/26/21
Accepted

Is there a way that I can use @row to reference the cell above? I'm creating a formula to check for duplicates and I want to compare details in the current row to the one above.

Tags:

Best Answer

Answers

  • Mark CronkMark Cronk ✭✭✭✭✭

    Hi @Kirstine ,

    I can't find a way to do it with @row without a reference to a specific row too. There are lots of posts in this community about how to find and flag duplicates.

    Curious if someone else has a better answer.

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

  • KirstineKirstine ✭✭✭✭✭

    Thanks @Mark Cronk and @Leibel S for your input!

    Leibel your clever trick has done the job! I don't really understand it yet (I've just plugged in the formulae with my column names) but I'll wrap my head around it soon! Thanks so much!

    🤩

  • Frank FalcoFrank Falco ✭✭✭✭✭

    Thanks @Leibel S, that is a good solution that will work until we have a supported command.


    ✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Sign In or Register to comment.