I didn't expect Excel to understand gene data. I expected that scientists would have used an appropriate tool for gene data. >complex models for others in Exce

I didn't expect Excel to understand gene data. I expected that scientists would have used an appropriate tool for gene data. >complex models for others in Excel It's best not to do that except in cases of emergency, I think. If you are going to get complex, SQL may be a much better solution, or something else.