I used to just press "F4" to create an absolute reference in my formulas but this time saving trick doesn't work when working with named table
=COUNTIFS(Table14[item name],"*"&W$2&"*")
How would I "fix" Table14[itemname] so this reference remains the same when copying the formula ?
Cheers
N
Bookmarks