Forum Discussion
Yijie
Jan 28, 2019Copper Contributor
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 VogelIron ContributorHi! 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