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.
In worksheet [Wanted Result] cell F2, use:Formula:
=IF(Original!$A2<>Original!$A1,IF(Original!$F2=0,0,1),IF(SUMIF(Original!$A$1:$A1,Original!$A2,$F$1:$F1)=Original!$F2,0,1))
In cell H2, use:Formula:=IF($F2=1,0,1)
Copy formulae down.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Great, it worked! Thank you!
In H2 of wanted result sheet:
=IF(COUNTIF($A$1:A1,A2)>=Original!F2,1,0)
in F2 of wanted result sheet:
=IF(H2=1,0,1)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks