on 28-12-2022 19:07
VM provide a less than useful format mobile internet usage csv file that using different MB,KB units in the used column that makes it very difficulty to add up the true monthly usage.
I'd like to be able to see the used amounts in a single unit without the silly bit of text in the filed too so they could be added together.
Does anyone have any excel magic that can do something like this?
28-12-2022 22:02 - edited 28-12-2022 22:04
Maybe:
Convert to MB
=NUMBERVALUE((IF(RIGHT(F2,2)="KB",((LEFT(F2,(LEN(F2)-2)))/1024),(LEFT(F2,(LEN(F2)-2))))))
SUM conversion
=ROUND(SUM(G2:G5),3)&"MB"