Hey as you can see in the second page of my excel file, i have a graph.
In A2, the formula is : =IF(Tableau3[[#En-t?tes];[Fruit]]=list!B2;"X";"")
What i would like is to extend to the right automatically (when i press on the button)
My problem is that if i try extending to the right i get this formula : =IF(Tableau3[[#En-t?tes];[Vegetable]]=list!C2;"X";"")
But what is want is C2 to stay B2. and then obviously when i go down the rest of the column, i get B3, B4 and so on.
Any ideas ? Thank you
HELP FORMULA.xlsm
Bookmarks