Forum Discussion
Ivan Wilson
Aug 23, 2017Copper Contributor
Array functions and If and Exact all combined not working
I am a little new to this, so some help would be much apprecaited. I have a spreadsheet with names, projects and a 1 or 0 depending on if they are working on it for the week in question on one sh...
JKPieterse
Aug 24, 2017Silver Contributor
I think you can use the COUNTIFS function here.
Suppose your data is in 'Resource Allocation'$A$1:$E$100 and your new table starts in A1 then this formula should do the trick:
=1*(COUNTIFS('Resource Allocation'!C$2:C$100,1,'Resource Allocation'!$A$2:$A$100,$A2)>0)