Excel Offset Function (For Static & Dynamic Calculations)

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

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

  • @mahaboobhossain5076
    @mahaboobhossain5076 4 года назад

    U UNDERSTAND STEP BY STEP AND THIS THE PLUS POINT OF YOUR DELIVERING SPEECH --THIS IS THE THING I LIKED IT MOST BROTHER

  • @ukumaras
    @ukumaras 3 года назад

    Your explanation is really Good.

  • @7208676934
    @7208676934 4 года назад

    You are fantastic trainer.. I clear my doubts after watching your videos... Keep the good work .. all the best

  • @marcinescu091
    @marcinescu091 Год назад

    Hi. I’ve gt a problem with the offset’s value error. I try to use 3 index matches in offset function for: reference, rows, cols. Separately all work correctly just when combined give an error. Also tried used Sum at the beginning of the formula syntax -no joy
    Any ideas to fix it or substitute? Many thanks

  • @mahaboobhossain5076
    @mahaboobhossain5076 4 года назад

    YOUR VIDEO IS VERY GOOD FROM OTHERS BROTHER

  • @shferaw4471
    @shferaw4471 2 года назад

    I really appreciate your help, thank you very much! On my excel I have Purchase & Sale column together. Purchase can be in cash & in Credit & also the same way Sale can be in cash & in Credit. Now I need to get total credit in purchase & total credit in Sale. The same to credit for sale. Can I do this with this function?? Or shall I send you please?

  • @zainjobe5423
    @zainjobe5423 2 года назад

    How do you use the function to stay constant eg. Sheet 1 is my reference and sheet 2 is my output. But i am looking to return horizontally. But if i change rows in sheet 2 it should return. Starting point in sheet 1?

  • @samseuropejourneys838
    @samseuropejourneys838 5 лет назад +1

    Great job all the best for new start 👍

  • @mahaboobhossain5076
    @mahaboobhossain5076 4 года назад

    I WANT TO LEARN AND I LIKED THE VIDEO BROTHER

  • @KC_47.
    @KC_47. 4 года назад

    In the video at minute 1.29.. How to make a formula for OFFSET function, I want to put 2 CRITERIA in the Reference.. Is that right if i use OR function in there for that 2 CRITERIA and how to make that?

  • @rotimidaniel5436
    @rotimidaniel5436 2 года назад

    Great video. Can you make sample files available for practise?

  • @mirrrvelll5164
    @mirrrvelll5164 4 года назад

    Good video, why and what is purpose actually of "column :" that you put here? In which way you can use it usually like that?

  • @jakariaalrazyshadhin6828
    @jakariaalrazyshadhin6828 4 года назад

    great

  • @mahaboobhossain5076
    @mahaboobhossain5076 4 года назад

    I NEED THIS FILE BROTHER PLZZZZZZZZZZZZZZZZZZZZZ SEND TO MY E-MAIL ONLY THE EXCEL FILE

  • @natashalewis9136
    @natashalewis9136 3 года назад

    Which language was he talking. I couldn’t understand a word.