????? ??????? ???? OFFSET ?? Excel

?????? ????????? ?????? ?????????
???? ???????: 324991 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

???? ??? ??????? ????? ??????? ????? ???? ?????? ???? ???? ?????? ??? ???? ?? ?????? ???????? ?????? ?? ???? ?? ???? ?? ??????? ???? ????? ?????? ????? ?? ???? ???????.

??????? ????

???? ???????? ??????? ?? ???? ??? Excel ?????. ????? ???? ??????? ??? ???????? ????? ????? ????? ?? ??? ??????.
?? ??? ??????????? ??? ??????
A1: ?????B1: ?????C1: ?????
A2: ????B2: 501C2: 28
A3: ????B3: 201C3: 19
A4: MaryB4: 101?????? C4: 22
A5: ????B5: 301C5: 29

????? ????? ??????? ?? ?????? E2 (?? ?? ???? ???? ?????):
=OFFSET(C2,2,-1,1,1)
  • C2 -?????? ????????.
  • 2 -???? ??? ??? ?????? ?????? ?????. ????? ??????? ??????? ????? ?????? ???????? ??????? ???? ????? ?????.
  • -1 -???? ??? ??? ??????? ???. ???? ????? ????? ???????? ??? ??????? ???????? ??????? ???? ???????? ??? ??????.
  • 1 (?????? ??????? ??????) -(???????). ???? ??? ??? ???? ???????? ???? ???? ???????. ??? ??? ?? ???? ????? ????? ??????.
  • 1 (?????? ???????) -(???????). ??????? ??? ??? ??????? ???????? ???? ???? ???????. ??? ??? ?? ???? ????? ????? ??????.

?????:

??? ??????? ??? ??????? ????? ?????? ???? ?????? ???? ?????? ???? ??? ??? ???? ????? (2) ????? 1 ??? ?????? (-1) ?? ?????? C2 (????? ?? ?????? B4). ?????? ?? ?????? B4 ?? "101". ????? ???? ?????? "101".

???????

???? ???????: 324991 - ????? ??? ??????: 28/????? ??????/1434 - ??????: 6.0
????? ???
  • Microsoft Office Excel 2003
  • Microsoft Office Excel 2007
  • Microsoft Excel 2010
????? ??????: 
kbhowto kbmt KB324991 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????324991

????? ???????

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com