Forum Discussion
Formula Help
CarlW1179 No worries. The formulas I used will only work with Excel for MS365. If you're getting the #NAME? error, it's a pretty strong indication that you're using an older version of Excel. I've attached another copy of the workbook, using the same logic, but with functions that should be compatible with any version...
That's exactly what I was trying to achieve rank you so much.
Only issue I now have is that when I change the Basket column the cell comes up with #NAME?
Really appreciate your help with this.
CarlW1179 No worries. The formulas I used will only work with Excel for MS365. If you're getting the #NAME? error, it's a pretty strong indication that you're using an older version of Excel. I've attached another copy of the workbook, using the same logic, but with functions that should be compatible with any version...