Hello,
Is there a way of filtering a list to show only specific values?
By this i mean if i've got a list which has a mix of some cells with characters & numbers, and other cells that ONLY have numbers - is there a way of displaying JUST the numbers (i.e. removing the mix of chars & no's from display), without deleting any info from the list?
I've messed around with text filters 'does not contain', but can't find a way of saying any non numeric character.
Does anyone know a way around this?
Thanks
Bookmarks