5 Replies Latest reply on Jan 11, 2018 7:41 AM by Michal Mokwinski

    Displaying same value for all rows based on a condition.

    Ramkumar Chandrasekaran

      Hi,

       

      I have a worksheet with two columns. The budget will be different for all the months in the data. But I would like to show the budget for 'May' in all the rows. In the example below, the budget that you see for all the rows is of 'May' month. Please help me do this as I am stuck here.

       

      Month     Budget

      Jan           30

      Feb           30

      Mar           30

      Apr            30

      May           30

      Jun            30

      Jul             30

       

      Thanks,

      Ram