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
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?
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?
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?
U UNDERSTAND STEP BY STEP AND THIS THE PLUS POINT OF YOUR DELIVERING SPEECH --THIS IS THE THING I LIKED IT MOST BROTHER
Your explanation is really Good.
You are fantastic trainer.. I clear my doubts after watching your videos... Keep the good work .. all the best
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
YOUR VIDEO IS VERY GOOD FROM OTHERS BROTHER
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?
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?
Great job all the best for new start 👍
Thanks :)
I WANT TO LEARN AND I LIKED THE VIDEO BROTHER
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?
Great video. Can you make sample files available for practise?
Good video, why and what is purpose actually of "column :" that you put here? In which way you can use it usually like that?
great
I NEED THIS FILE BROTHER PLZZZZZZZZZZZZZZZZZZZZZ SEND TO MY E-MAIL ONLY THE EXCEL FILE
Which language was he talking. I couldn’t understand a word.
It's English
For Excel tutorials in Urdu /Hindi please subscribe
RUclips.Com/UrduHindiLectures
Welcome to India.