If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#21
|
|||
|
|||
Leo Heuser wrote...
... I simply won't waste more of my time holding a discussion in such a spiteful and antisocial ambience. As long as you can have the last word that is. Too bad. FWIW, you were correct that my original formula would always return the last entry in the OP's data, but your diagnosis of the cause was incorrect. If the COUNTIF call's criteria forces text comparison, the formula works for any text. The formula you had provided in your first response to me would only work with numeric text, in which case it was inferior to the other formulas already provided, including your own. If that formula were applied to a range with any nonnumeric text, it would return #VALUE!. --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Running Access from network | Alan Fisher | Using Forms | 4 | July 3rd, 2004 02:37 AM |
problem with IF function with results from MATCH function | michelle | Worksheet Functions | 3 | October 24th, 2003 11:53 PM |
Excel "IF" function problem | Johan | Worksheet Functions | 2 | September 15th, 2003 03:08 PM |