Hi, would need to add new counted column into external data table (via query from database). It works, if I count in the same row. But if I want to write formula with second row, it doesn't work, because excel insert range (for example B3). I have data with dates, I need to check, if the second row is the same date or day (or more days later).
Something like =[@date.offset(1)].
Is it possible? Of course the problem would be, if sorting would change...
Thank You.
Martin
Bookmarks