When I want to find the last used cell value, I use: Dim LastRow As Long LastRow = Range(“E4:E48”).End(xlDown).Row Debug.Print LastRow I’m getting the wrong output when I put a single element into a cell. But when I put more than one value into the cell, the output is correct. What’s the reason behind this? … Read more
Lets say I have one cell A1, which I want to keep constant in a calculation. For example, I want to calculate a value like this: =(B1+4)/(A1) How do I make it so that if I drag that cell to make a calculation across cells in many rows, only the B1 value changes, while A1 … Read more
Is there an efficient way to identify the last character/string match in a string using base functions? I.e. not the last character/string of the string, but the position of a character/string’s last occurrence in a string. Search and find both work left-to-right so I can’t think how to apply without lengthy recursive algorithm. And this … Read more
I need to return an empty cell from an Excel formula, but it appears that Excel treats an empty string or a reference to an empty cell differently than a true empty cell. So essentially I need something like =IF(some_condition,EMPTY(),some_value) I tried to do things such as =IF(some_condition,””,some_value) and =IF(some_condition,,some_value) and assuming B1 is an … Read more
Is there an in-built function to check if a cell contains a given character/substring? It would mean you can apply textual functions like Left/Right/Mid on a conditional basis without throwing errors when delimiting characters are absent. 11 Answers 11
Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers. Want to improve this question? Update the question so it’s on-topic for Stack Overflow. Closed 7 years ago. Locked. This question and its answers are locked because the question is off-topic but has historical significance. It is not currently accepting … Read more
How can I construct the following string in an Excel formula: Maurice “The Rocket” Richard If I’m using single quotes, it’s trivial = “Maurice ‘The Rocket’ Richard” but what about double quotes? 13 Answers 13
