excel_learnerz
Board Regular
- Joined
- Dec 12, 2018
- Messages
- 73
in excel is it possible with a formula to compare two columns, just two
column 1 the data in the row looks like (2, 4, 5, 3)
column 2 (0, 1, 0, 1)
so in column 3 it would be (4, 3) as i only want to use the values where column 2 has a 1 value
column 1 the data in the row looks like (2, 4, 5, 3)
column 2 (0, 1, 0, 1)
so in column 3 it would be (4, 3) as i only want to use the values where column 2 has a 1 value