Forum Discussion
IF cell = 0 then add cell name to list
Hello all, I have created a spreadsheet based on Magic the Gathering, so far its all good and working as it should. What I'm struggling with is this..... I have card name in B3 and the number of ca...
Thank's, that's exactly what I was trying to do.
Alas I can't get it to work with my spreadsheet, could it be to do with my layout?
I have used the formula as you typed it only with changes that make it relevant to my sheet.
I've attached a snippet of the sheet if you wouldn't mind having a look?
Matthew, attached is variant with non-array formula
=IFERROR(INDEX($C$4:$C$21,AGGREGATE(15,6,1/($E$4:$E$21=0)*(ROW($B$4:$B$21)-ROW($B$3)),ROW($B4)-ROW($B$3))),"")
Thank you so much!
I see where I was going wrong now. I was calling the wrong ROW.