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.
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
