SOLVED
IF Statement with data from one column populating another.
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
Adam_B
8 - Asteroid
‎04-17-2023
11:08 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
I have a data set with a column named "How Many SBRs were done for Q1?" I need to populate the result of that column (can be 1-9) into a new column called Q1 with the respective number from the other column.
Attached is dummy data.
I believe it will be multiple IF statements for the range that I need, but I am not sure.
Solved! Go to Solution.
Labels:
- Labels:
- Datasets
2 REPLIES 2
binuacs
21 - Polaris
‎04-17-2023
11:24 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎04-17-2023
11:25 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@binuacs Thank you!
