Forum Discussion

TariqRaza's avatar
TariqRaza
Copper Contributor
Jun 20, 2019
Solved

How to populate data by selecting codes.

how can I populate date by selecting codes like Ab Ac Ad AF, means when I select AB the automatically AB populates from 8:AM to 1:30 PM, same way AC populate 11:00 to 4: pm

 

Time Slot 8:00 AM8:30 AM9:00 AM9:30 AM10:00 AM10:30 AM11:00 AM11:30 AM12:00 PM12:30 PM1:00 PM1:30 PM2:00 PM2:30 PM3:00 PM3:30 PM4:00 PM4:30 PM5:00 PM5:30 PM6:00 PM6:30 PM
                        
AB ABABABABABABABABABABABAB          
AC       ACACACACACACACACACACAC     
AD       ADADADADADADADADADADADADADADADAD
AF  AFAFAFAFAFAFAFAFAFAFAFAFAF        
Excelex
  • SergeiBaklan's avatar
    SergeiBaklan
    Jun 20, 2019

    TariqRaza 

    It's like

    =IF(
   ($B6="AB")*(D$4>=TIME(8,0,0))*(D$4<=TIME(13,30,0)),
   $B6,
   IF(
      ($B6="AC")*(D$4>=TIME(11,0,0))*(D$4<=TIME(16,30,0)),
      $B6,
      IF(
         ($B6="AD")*(D$4>=TIME(11,0,0))*(D$4<=TIME(18,30,0)),
         $B6,
         IF(
            ($B6="AF")*(D$4>=TIME(8,30,0))*(D$4<=TIME(14,30,0)),
            $B6,"")
      )
   )
)

     

3 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jun 20, 2019

    TariqRaza 

    It's like

    =IF(
   ($B6="AB")*(D$4>=TIME(8,0,0))*(D$4<=TIME(13,30,0)),
   $B6,
   IF(
      ($B6="AC")*(D$4>=TIME(11,0,0))*(D$4<=TIME(16,30,0)),
      $B6,
      IF(
         ($B6="AD")*(D$4>=TIME(11,0,0))*(D$4<=TIME(18,30,0)),
         $B6,
         IF(
            ($B6="AF")*(D$4>=TIME(8,30,0))*(D$4<=TIME(14,30,0)),
            $B6,"")
      )
   )
)

     

Resources