This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Created:
Dec 8, 2020 02:50 PM
| Last Modified: Jun 10, 2023 07:23 PM(633 views)
Hello,
Can you help how to write a formula for row difference? My problem with the formula is that I have a variable column "Partnumber" and I don't want the row difference calculated if the next row has a different partnumber than the current row. Please find a sample table. In row number 30, the part number is different than the previous row. For row 30, I don't want the calculation but then continue as long as the next rows have the same part number as row 30 and so on.