for example:
A1: Fruit
A2: apple,apple
A3: orange
A4: apple,orange
A5: grape
A6: orange,grape
A7: grape, apple
A8: =SUM(LEN(A2:A7)-LEN(SUBSTITUTE(A2:A7,"apple","")))/LEN("apple")
on my desktop, I select the formula in A8 and press CSE to get a result of 4 but on my laptop, I do the same thing and it doens't work. both use excel 2007.
When I press CSE on my laptop excel, the brackets { } appear but I do not get any results. Instead, it just shows the whole formula in the cell with the brackets...
The file is not in shared mode and I have the macro function turned on.
PLEASE HELP!
UPDATE: so it seems that none of my formulas are working.. not even a simple SUM function works.. is there a setting I don't know about that disables functions?
Bookmarks