Hi Guys,
Need your help with Pulling all the value that ends with "GB" from a column into new column.
Data in the column is alphanumeric for example- 1.2656524GB
Sorry, I am new to excel so any help is greatly appreciated
Hi Guys,
Need your help with Pulling all the value that ends with "GB" from a column into new column.
Data in the column is alphanumeric for example- 1.2656524GB
Sorry, I am new to excel so any help is greatly appreciated
Last edited by AliGW; 06-22-2022 at 06:18 AM. Reason: Irrelevant section of title removed.
Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. For a new thread (1st post), scroll to Manage Attachments, otherwise scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.
Updated attachment
Hi Caracalla, i was hoping to pull the values from "call duration" column according to the "call type" into the column "over by-data" and "over by- mins" however the limit is 5gb and 300 minutes so anything over should go "over by " column and it should show how much its over by
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks