Ignoring Null Cells In The Sort Function (1 Viewer)

BowDan

New member
Local time
Today, 10:43
Joined
Jun 22, 2023
Messages
13
Hello,
I'm currently working on a file for cataloguing data on clients.
One of my columns contains a formula that spits out -null- spaces under some conditions (on purpose) and now i'm encountering the issue, that when using the sort function, these cells appear on top, hurting the functionality of the file.

This file is made to be used by excel novices, so i'm trying to build it in a way that no one in the coming years would have to know how to format/ edit formulas.

Is there a way to force the sort function to ignore blank cells without it also ignoring future inputs?
/ is there a way to have a formula spit put -blank- instead of -null-? (Which, as far as i can tell, would also solve my issue)


Apologies in advance for not attaching a file, but it contains too much sensitive information for me to attach, and deleting all content would take a while.
 
What happens if the calc returns an empty string? Do you want these records to sort last?
 
What happens if the calc returns an empty string? Do you want these records to sort last?
Yes, I would like the empty at the bottom too, please. Thank you.
 
Create a sort group column - could be as simple as

sgroup: mycalculation is null

then sort by sgroup desc, mycalculation
 
you can create a new Expression on a Cell and include it in your sort:

=IF(B2="","z","a")&B2

:: if there is no value on cell B2, put "z" otherwise but "a".
 

Users who are viewing this thread

Back
Top Bottom