Forum Discussion
Replace certain cells
I have a set of data that I want to sort, simply it has a list of questions 1 through 19, then a case question and a situational questions I tried the format as Text but the slicer goes Quest...
It sorted the numbered questions, but returned "Null" for case and situation as the column data type is numbers
when I replace errors, I can only change one so it's either all shows as case or situation
I'm trying to show this list in a slicer if that helps