KayJay0618
New Member
- Joined
- Jul 20, 2016
- Messages
- 40
I don't have a clue how to search for something to help me with this problem. I have a worksheet with 5 columns (num, FY-Qtr, OP, UP, Qtr Result). I need to populate the Qtr Result column with the word Keep IF the total of the OP and UP columns for an FY-Qtr and Num is greater than zero. If there is nothing but 0 in the OP and UP columns for a Num and FY-Qtr I need to populate the Qtr Result column with Delete. I've attached a sample. You can see that for num 4071151, there are numbers greater than zero on all 5 rows for FY15-Q3 so I would want to populate column E with Keep on all 5 of those rows. I would also want Keep in column E for all 6 rows for FY15-Q4 because 2 of the rows have numbers greater than 0 in the OP or UP column. But column E for all of the FY16-Q1 rows for num 4071151 should be populated with the word Delete because none of the OP/UP columns for FY16-Q1 have numbers greater than 0. I have several thousand records I need to resolve QUICKLY and I just can't seem to figure this one out. I'm thinking it's some sort of sumproduct formula but I'm really struggling with figuring it out and maybe I'm off track. Thank you in advance! ![Confused :confused: :confused:](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
<tbody>
</tbody>
Num | FY-QTR | OP | UP | Qtr Result |
4071151 | FY15-Q3 | 0 | 35.68 | Keep |
4071151 | FY15-Q3 | 0 | 66.45 | Keep |
4071151 | FY15-Q3 | 0 | 31.17 | Keep |
4071151 | FY15-Q3 | 0 | 31.17 | Keep |
4071151 | FY15-Q3 | 0 | 31.17 | Keep |
4071151 | FY15-Q4 | 0 | 31.17 | Keep |
4071151 | FY15-Q4 | 0 | 31.17 | Keep |
4071151 | FY15-Q4 | 0 | 0 | Keep |
4071151 | FY15-Q4 | 0 | 0 | Keep |
4071151 | FY15-Q4 | 0 | 0 | Keep |
4071151 | FY15-Q4 | 0 | 0 | Keep |
4071151 | FY16-Q1 | 0 | 0 | Delete |
4071151 | FY16-Q1 | 0 | 0 | Delete |
4071151 | FY16-Q1 | 0 | 0 | Delete |
4071151 | FY16-Q2 | 0 | 0 | Delete |
4071151 | FY16-Q2 | 0 | 0 | Delete |
4071151 | FY16-Q2 | 0 | 0 | Delete |
4066704 | FY14-Q3 | 0 | 63.83 | Keep |
4066704 | FY14-Q3 | 20.19 | 0 | Keep |
4066704 | FY14-Q3 | 0 | 0 | Keep |
4066704 | FY14-Q3 | 25.7 | 0 | Keep |
4065758 | FY14-Q2 | 0 | 0 | Delete |
4065758 | FY14-Q2 | 0 | 0 | Delete |
4065758 | FY14-Q2 | 0 | 0 | Delete |
4065758 | FY14-Q3 | 0.21 | 0 | Keep |
4065758 | FY14-Q3 | 0 | 0 | Keep |
4065758 | FY14-Q3 | 0 | 0 | Keep |
4065758 | FY14-Q4 | 0 | 0 | Delete |
4065758 | FY14-Q4 | 0 | 0 | Delete |
<tbody>
</tbody>