hello my Dear ,I want You Helping in this problem ,i Need any Formula to get the Same Result in Coulmn B ,in the Same Row for Number in Column C ...AS Following :
**If i have multiple Regions in Column A for the same Vehicle Record Nr from Column D , You should choose the farthest area ...Foe Example in my file for this Vehicle Record 460461 .it should be to choose between (MAK,SAF)I WILL CHOOSE "SAF"Because it's far destination
In general, it is required to find the farthest place in the same Vehicle ,if i have (SAF,MAK,SAHL,HUR)..I CHOOSE SAF
*In anothe case if i have (MAK,SAHL,HUR)..I CHOOSE MAK
*If i have (SAHL,HUR)In the same Vehicle .. i will choose SAHL
*If i have in the same Vehicle just (HUR).. I will choose it & This is generally for the entire area of the same car ,I mean else if i found onlt (SAHL OR MAK OR SAF) I will choose the region
thanks alot for all
**If i have multiple Regions in Column A for the same Vehicle Record Nr from Column D , You should choose the farthest area ...Foe Example in my file for this Vehicle Record 460461 .it should be to choose between (MAK,SAF)I WILL CHOOSE "SAF"Because it's far destination
In general, it is required to find the farthest place in the same Vehicle ,if i have (SAF,MAK,SAHL,HUR)..I CHOOSE SAF
*In anothe case if i have (MAK,SAHL,HUR)..I CHOOSE MAK
*If i have (SAHL,HUR)In the same Vehicle .. i will choose SAHL
*If i have in the same Vehicle just (HUR).. I will choose it & This is generally for the entire area of the same car ,I mean else if i found onlt (SAHL OR MAK OR SAF) I will choose the region
thanks alot for all