All Forums  Origin Forum  Origin Forum  finding index of cell

Note: Only the poster of this message, and the Moderator can edit the message.

Screensize: 640 x 480 800 x 600 1024 x 768 1280 x 1024 UserName: Password: Anti-Spam Code: Format Mode: Basic  Help  Prompt  Format: Font Andale Mono Arial Arial Black Book Antiqua Century Gothic Comic Sans MS Courier New Georgia Impact Lucida Console Script MT Bold Stencil Tahoma Times New Roman Trebuchet MS Verdana   Size 1 2 3 4 5 6   Color Black Red Yellow Pink Green Orange Purple Blue Beige Brown Teal Navy Maroon LimeGreen Forum: Origin Forum Subject: Message: * HTML is OFF * Forum Code is ON Smilies Hi all, I need to find the index of a certain cell, and am not sure how to do this. Basically what I want is the value of a cell in the neighbour column of a max value cell. for example: A6309 is the max of col(A). I need the value of B6309. However, I don`t know where the max value of col(A) is. The problem with =index is that the data set is not strictly monotone, therefor the output of the command is a default error value of "-2". Would really appreciate timely help, thanks a lot! Paul   Check here to subscribe to this topic.