Peter_SSs
MrExcel MVP, Moderator
- Joined
- May 28, 2005
- Messages
- 64,869
- Office Version
- 365
- Platform
- Windows
I'd definitely vote for that one!-The ability to resize the 'Evaluate Formula' window.
I'd definitely vote for that one!-The ability to resize the 'Evaluate Formula' window.
Improvement to the INDEX function so you could get it to (easily) return a null string instead of a zero if the target cell is empty.
So we don't have to do constructs like
=IF(INDEX(A1:A6,3)="","",INDEX(A1:A6,3))
True. Would be useful even for something as simple as =A1Hello Peter
But that applies to every lookup function.
So it should be a more general approach like: IFEMPTY() or IFNULL().
True. Would be useful even for something as simple as =A1
Obviously VBA can be used to make cells empty….. Along the lines of lookup type....
…….lots of inconsistent problems finding last cells, empty cells, as well as strange inconsistent memory increases in File size that do not tie up with wot is there, after clearing, deleting etc. So a command like Cells(y,x).Forget would be good..
But that applies to every lookup function.
So it should be a more general approach like: IFEMPTY() or IFNULL().
I like this idea... have you ever encountered any Excel induced rounding issues with the double reciprocal such that X ends up not equaling 1/(1/X)?Then, rather than repeating the whole main clause again I employ a construction with IFERROR, taking advantage of the fact that only zero will produce an error when reciprocated with unity, along the lines of:
=IFERROR(1/(1/(...
I like this idea... have you ever encountered any Excel induced rounding issues with the double reciprocal such that X ends up not equaling 1/(1/X)?