beginvbaanalyst
Board Regular
- Joined
- Jan 28, 2020
- Messages
- 141
- Office Version
- 365
- Platform
- Windows
Hi everyone,
I have a question with two columns: if a column of mine holds a value such as "100 012", "800 002", "500 012", or "800 004", and my second column or updated value holds a value such as "800 007", "800 008", "800 003" or "97", I want the balance of that specific row. Realistically I want to make one formula that pulls the sum if the row of the table hits these values.
Here is a screenshot where this special case occurs with line 13, my column K shows the type previously and column A is the new type. Since this happened I want the balance from this row. Essentially if this happens ten times, I want one formula to capture it all. Is that possible or do I need to create a new column and and just do a sum for that special column?
I appreciate your help!
I have a question with two columns: if a column of mine holds a value such as "100 012", "800 002", "500 012", or "800 004", and my second column or updated value holds a value such as "800 007", "800 008", "800 003" or "97", I want the balance of that specific row. Realistically I want to make one formula that pulls the sum if the row of the table hits these values.
Here is a screenshot where this special case occurs with line 13, my column K shows the type previously and column A is the new type. Since this happened I want the balance from this row. Essentially if this happens ten times, I want one formula to capture it all. Is that possible or do I need to create a new column and and just do a sum for that special column?
I appreciate your help!
