I have a spreadsheet with a column that contains a value for number of burnt items in a specific coordinate and a column for number of items total in that coordinate. Each row repeats the exact amount of times as there are items in the total number column. What I want to do now is to make one column that has the value 1 or 0 dependent on whether or not a specific item is burned or not. The same goes for unburnt items. Se attached woorkbook.
Bookmarks