Excel - 3D Reference with Multiple Worksheets

Поделиться
HTML-код
  • Опубликовано: 22 окт 2024

Комментарии • 9

  • @altostratuss
    @altostratuss Год назад +1

    Thank you!! Second method was quick and easy and it helped me understand the formula better when completing my homework. Just subscribed! God bless you! :)

  • @irianbravo4694
    @irianbravo4694 26 дней назад

    Perfect explanation !!!

  • @CH-px9iy
    @CH-px9iy 7 месяцев назад +1

    THANK YOU

  • @roywilson9580
    @roywilson9580 Год назад +2

    This is a great way of referencing multiple sheets in a formula but you need to remember to ungroup the sheets immediately after completing the formula so as not to duplicate everything you do later onto multiple sheets at once. A lesson I learnt the hard way :(

    • @ChrisMenardTraining
      @ChrisMenardTraining  Год назад +1

      Excellent point!

    • @altostratuss
      @altostratuss Год назад +1

      YES. My worksheets were grouped and I didn’t understand why it wasn’t working until I ungrouped them.

  • @hafizulhipeni5620
    @hafizulhipeni5620 4 месяца назад

    Hm not helpful for me