Want to update text for same duplicate data
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
First table has BBB and CCC duplicate in column E and on basis of that can we fill "Yes" in above row as mentioned the result table in blue color also want to make sure column B should one - and one + amount and getting zero of total.
Thanks,
Solved! Go to Solution.
- Labels:
- Data Investigation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Srawat , You can get your solution by using Row Field Formula. Please find the solution attached and accept it if this is what you were looking for.
Thanks!!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello.
I am taking into account multiple variables from your exercise - such as:
1. what if the two BBBs are not one row after the one, but somewhere in the database
2. The - and + in the column B, I suppose this is not the input, but this is what you wanted to have in your output.
If my understanding is correct for the above, my solution is the below one (more complex than the others proposed, but I have taken in mind multiple scenarios :) )
Please accept my proposal as your solution if you consider it right.
