tag:blogger.com,1999:blog-7958828565254404797.post8062619737952644153..comments2024-03-27T11:03:10.938-07:00Comments on ListenData: Excel : Lookup Top N valuesDeepanshu Bhallahttp://www.blogger.com/profile/09802839558125192674noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-7958828565254404797.post-3103721422644350712020-12-06T06:12:58.863-08:002020-12-06T06:12:58.863-08:00What's the use of ROWS($1:1)What's the use of ROWS($1:1)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-17922125791743253482018-11-08T01:20:47.613-08:002018-11-08T01:20:47.613-08:00Hi Thanks for the file. i dont want to ignore dupl...Hi Thanks for the file. i dont want to ignore duplicate, lets say if we have following data: 10, 10, 10, 9, 9,8 then it should generate 10,9,8Adnan's Bloghttps://www.blogger.com/profile/03335719779009414582noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-16872713987903847252015-09-10T09:58:29.547-07:002015-09-10T09:58:29.547-07:00Nice article. In my experience, ROWS($1:1) won'...Nice article. In my experience, ROWS($1:1) won't work in an array formula. It will generate all 1's, unlike with the non-array version. I usually use ROW(INDIRECT("1:5")) to generate that sort of list within an array formula.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-63602870563790793072015-02-14T07:38:59.858-08:002015-02-14T07:38:59.858-08:00Thanks for sharing this excellent formula.Thanks for sharing this excellent formula.Anonymousnoreply@blogger.com