View Single Post
  #1   Report Post  
Andrew
 
Posts: n/a
Default Comparing cell values then labeling them based on comparision

Hi. I'm trying to find a function or way to compare two cells and then label
them according to if one cell is lesser, greater, or the same as the other.

I have a large data sheet where I want to compare many pairs of cells and
then have them labeled in this way. For example for each pair where the
second cell value is larger than the first it would put greater, where the
first is larger it would be lesser, etc.

Can anybody help me with this? also feel free to email me at
.

Thanks so much for your help.