Hi, I wonder if you can help me.
I download a report from our system and it is a csv file, so I have to manipulate it to get the data I need to import into another system.
However the way the report generates, it combines multiple values in the same cell.
I have attached a small snippet of the spreadsheet and wondered if you could help. Column K needs to count all the entries that have a numeric value only. I have for this example, manually typed what the result should be.
I have tried different count variations, but it only seems to give part of the result I am looking for. I'm obviously doing something wrong.
I'm a novice, so there may be another solution but I'm not sure what it is.
Any help would very much be appreciated.
Bookmarks