SOLVED
MultiRow Formula
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
gmia
5 - Atom
‎10-04-2022
12:54 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
I cannot get the right formula for the following:
1. On column 20, when P1 is consecutive I need the records from 7th row to have them on 4th row and 6 on 5 (output in the workflow for a better view).
2. On column 20, when P1 is not consecutive, I need the records shifted with one above, record 14 to record 13.
I got the formula working for the second situation, but I am not sure how to tackle the first one, as it goes weird in my workings attached.
Please note it happens in a larger file with many lines when these 2 specific scenarios can happen.
Thank you!
Solved! Go to Solution.
1 REPLY 1
Christina_H
14 - Magnetar
‎10-04-2022
01:35 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator