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...
To avoid array formula that could be
=IFERROR(INDEX(cards[Card],AGGREGATE(15,6,1/(cards['# Owned]=0)/NOT(ISBLANK(cards['# Owned]))*ROW(cards[Card])-ROW(cards[[#Headers],[Card]]),ROW(A1))),"")
and attached