Hi ,
am trying to get a column header name based on specific value on a cell and add it to a new column, for example in below data i need to get the lowest car rate related to a specific customer
| Customer ID | BMW car | Toyota car | Jeep car | Ford car | Lowest car |
| 1 | 87% | 19% | 49% | 47% | |
| 2 | 59% | 66% | 85% | 72% | |
| 3 | 74% | 52% | 87% | 31% | |
| 4 | 93% | 18% | 1% | 4% |
and so the results will look like
| Customer ID | BMW car | Toyota car | Jeep car | Ford car | Lowest car |
| 1 | 87% | 19% | 49% | 47% | Toyota car |
| 2 | 59% | 66% | 85% | 72% | BMW car |
| 3 | 74% | 52% | 87% | 31% | Ford car |
| 4 | 93% | 18% | 1% | 4% | Jeep car |
thanks for your support