Hello,
I have a list with articles which have technical criteria. I would now like to have the criteria returned as text but the complicated bit for me is how I can show the different temperatures... I tried if functions but it didn't really work. Would anybody know how best to solve this? My Excel version is 2016.
Many thanks in advance.
[TABLE="width: 1467"]
<colgroup><col><col><col><col><col><col><col><col><col span="2"><col><col><col></colgroup><tbody>[TR]
[TD]Material Number[/TD]
[TD]Material Description[/TD]
[TD]CE[/TD]
[TD]UL[/TD]
[TD]ATEX[/TD]
[TD]IECEx[/TD]
[TD]GL[/TD]
[TD]MOT South[/TD]
[TD]MOT NRTL[/TD]
[TD]EAC[/TD]
[TD]Higher temperature[/TD]
[TD]Mechanical Support[/TD]
[TD]Output[/TD]
[/TR]
[TR]
[TD]028031[/TD]
[TD]BK1111[/TD]
[TD]●[/TD]
[TD]●[/TD]
[TD]●[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]●[/TD]
[TD]●[/TD]
[TD]●[/TD]
[TD]CE, UL_60, ATEX_60[/TD]
[/TR]
[TR]
[TD]045065[/TD]
[TD]EK1234[/TD]
[TD]●[/TD]
[TD]●[/TD]
[TD]●[/TD]
[TD]●[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]●[/TD]
[TD]●[/TD]
[TD][/TD]
[TD]CE, UL_60, ATEX_60, IECEx_60[/TD]
[/TR]
[TR]
[TD]177357[/TD]
[TD]EK1111[/TD]
[TD]●[/TD]
[TD]●[/TD]
[TD]●[/TD]
[TD]●[/TD]
[TD]●[/TD]
[TD]●[/TD]
[TD][/TD]
[TD]●[/TD]
[TD][/TD]
[TD][/TD]
[TD]CE, UL_55, ATEX_55, IECEx_55,GL,TÜV_Süd[/TD]
[/TR]
</tbody>[/TABLE]
If "Higher Temperature" is ticked the temperature for UL, ATEX and IECEx should be 60, else 55
I am looking for a formula which will return all the criterias which are ticked as a text in column M. The formula can either work with the material number or description
I have a list with articles which have technical criteria. I would now like to have the criteria returned as text but the complicated bit for me is how I can show the different temperatures... I tried if functions but it didn't really work. Would anybody know how best to solve this? My Excel version is 2016.
Many thanks in advance.
[TABLE="width: 1467"]
<colgroup><col><col><col><col><col><col><col><col><col span="2"><col><col><col></colgroup><tbody>[TR]
[TD]Material Number[/TD]
[TD]Material Description[/TD]
[TD]CE[/TD]
[TD]UL[/TD]
[TD]ATEX[/TD]
[TD]IECEx[/TD]
[TD]GL[/TD]
[TD]MOT South[/TD]
[TD]MOT NRTL[/TD]
[TD]EAC[/TD]
[TD]Higher temperature[/TD]
[TD]Mechanical Support[/TD]
[TD]Output[/TD]
[/TR]
[TR]
[TD]028031[/TD]
[TD]BK1111[/TD]
[TD]●[/TD]
[TD]●[/TD]
[TD]●[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]●[/TD]
[TD]●[/TD]
[TD]●[/TD]
[TD]CE, UL_60, ATEX_60[/TD]
[/TR]
[TR]
[TD]045065[/TD]
[TD]EK1234[/TD]
[TD]●[/TD]
[TD]●[/TD]
[TD]●[/TD]
[TD]●[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]●[/TD]
[TD]●[/TD]
[TD][/TD]
[TD]CE, UL_60, ATEX_60, IECEx_60[/TD]
[/TR]
[TR]
[TD]177357[/TD]
[TD]EK1111[/TD]
[TD]●[/TD]
[TD]●[/TD]
[TD]●[/TD]
[TD]●[/TD]
[TD]●[/TD]
[TD]●[/TD]
[TD][/TD]
[TD]●[/TD]
[TD][/TD]
[TD][/TD]
[TD]CE, UL_55, ATEX_55, IECEx_55,GL,TÜV_Süd[/TD]
[/TR]
</tbody>[/TABLE]
If "Higher Temperature" is ticked the temperature for UL, ATEX and IECEx should be 60, else 55
I am looking for a formula which will return all the criterias which are ticked as a text in column M. The formula can either work with the material number or description