SOLVED
Multi-row 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
AmitBelagali
8 - Asteroid
‎10-12-2018
05:26 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I have a scenario wherein, I need to populate the current cell with based on row+1. (The reverse of row-1).
Could you please help me on how to achieve it?
I have attached a sample attachment as well.
Thanks,
Amit Belagali
Solved! Go to Solution.
Labels:
- Labels:
- Datasets
- Preparation
1 REPLY 1
16 - Nebula
‎10-12-2018
05:28 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@AmitBelagali Try sorting your data in the opposite way first using the Sort tool. Then fill down and then re-sort your data back to the original format.
