Hi All...
I can't be thankful enough to the members of this forum for helping me enhance my excel skills. I wonder if someone can help me out with the problem i am facing right now. I want to calculate the average for numbers in around 100 cells but the numbers are with special characters "▼","▲" as it is a dashboard. I am sure its a simple trick which i cannot figure out. Your help is much appreciated
Here is a simple illustration what i want.
9.20 ▼
10.50▲
11.34▲
6.54 ▼
so the required result should be. 9.40
Bookmarks