Multiple Logic (code+reagion+Days)

Hi Expert,

i have one data

S.No. Code Reagion Days result

  1.                    abc                      North                    10           0
    
  2.                    abd                      North                    10           0
    
  3.                    abc                      North                      7            7
    
  4.                    xyz                      North                      7            0 
    
  5.                    xyz                      west                        5            5
    
  6.                    abc                     west                       10           0
    
  7.                    abc                      west                       4             4
    

now i need high light min day with code and reagion.

Please suggest which formula can be provide data menntion result column data.

Best Regards
Abdul Nisar

You need a couple of variables:
1 - determine the min days in code/region:
v_MinDaysInCodeRegion = min( [Days] ) in( [Code] ; [Region] )

2 - compare the row to the min value
v_CompareDaysToMin = if [Days] = [v_MinDaysInCodeRegion] then 1 else 0

3 - create an alert/conditional format
= if [v_CompareDaysToMin] = 1 then yellow highlight

1 Like