tag:blogger.com,1999:blog-7958828565254404797.post579910875767358867..comments2024-03-29T00:02:14.892-07:00Comments on ListenData: Excel Array Formulas ExamplesDeepanshu Bhallahttp://www.blogger.com/profile/09802839558125192674noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-7958828565254404797.post-34221907880157565382021-01-25T23:23:47.708-08:002021-01-25T23:23:47.708-08:00INDEX($A$3:$A$9,MATCH(LARGE($B$3:$B$9-ROW($B$3:$B$...INDEX($A$3:$A$9,MATCH(LARGE($B$3:$B$9-ROW($B$3:$B$9)/10^5,ROWS(A$1:A1)),$B$3:$B$9-ROW($B$3:$B$9)/10^5,0))<br />Would you mind to explain 10^5 within this formula please as I am trying to understand where does it from + (A$1:A1)) as the cells is empty Sophianhttps://www.blogger.com/profile/18364436686041341613noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-10317728475718746472019-07-20T03:33:27.618-07:002019-07-20T03:33:27.618-07:00in example 2, why are we dividing by 10 and raise ...in example 2, why are we dividing by 10 and raise it to 5?thanksAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-54809342084927554082017-03-08T03:09:57.693-08:002017-03-08T03:09:57.693-08:00Thanks. Know I have got the better undersetting of...Thanks. Know I have got the better undersetting of Array.Anonymoushttps://www.blogger.com/profile/09560172866383359690noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-23657937598623066482017-02-09T10:59:25.543-08:002017-02-09T10:59:25.543-08:00thanks my name amarnathverma@outlook.comthanks my name amarnathverma@outlook.comAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-26835579320566117492016-07-03T04:21:02.622-07:002016-07-03T04:21:02.622-07:00Thank you for stopping by my blog. Cheers!Thank you for stopping by my blog. Cheers!Deepanshu Bhallahttps://www.blogger.com/profile/09802839558125192674noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-63762186499794143172016-05-02T02:22:48.676-07:002016-05-02T02:22:48.676-07:00Nice post. Never tried going into array formulas b...Nice post. Never tried going into array formulas but this helped a lot to understand the basics of it.Anonymoushttps://www.blogger.com/profile/10252821412824627090noreply@blogger.com