Forum Discussion

Yijie's avatar
Yijie
Copper Contributor
Jan 28, 2019

How to sort a column with different cell format

Hi,

Does anyone who knows how to sort a column with different cell format. I used MATCH formula to find the overlapping genes. How can I sort those items with numeric value ignoring the #NA cells? Thanks.

1 Reply

  • Eva Vogel's avatar
    Eva Vogel
    Iron Contributor
    Hi! Can you pls. describe why there are different formats within the same column? I would make different columns out of that to avoid more problems in future. Or give screenshot here that I can figure out. Greets, Eva

Resources