excel01noob
Board Regular
- Joined
- Aug 5, 2019
- Messages
- 93
- Office Version
- 365
- 2016
Hi
I have a dataset for which I need to first convert the data of several columns (from text to number) based on the column header
I don't want to define the column position as it varies from time to time, but the column header will always have the same header name.
In some occasions, some of the headers might not appear in the data set.
The header names most frequent are:
Quantity
Amount
Original currency Amount
These should be converted into numbers with 2 decimals
How do I get around this?
I have a dataset for which I need to first convert the data of several columns (from text to number) based on the column header
I don't want to define the column position as it varies from time to time, but the column header will always have the same header name.
In some occasions, some of the headers might not appear in the data set.
The header names most frequent are:
Quantity
Amount
Original currency Amount
These should be converted into numbers with 2 decimals
How do I get around this?