To display the content of the cell

[rampure]

Hi,

I am trying to display the contents of the cell based on a condition.

I have a state column,store column, two retails column of two months, say Jan and feb and a change column.

Now i am trying to display the state based on the change column.
If there is no change in retail, display the number of store in that state.

Here's what I have for the data.

State Store Jan Feb Change
CT 173 17.88 17.88 0
CT 184 17.88 17.88 0
DE 15 17.99 17.99 0
DE 178 17.99 17.99 0
FL 108 17.29 17.99 1.70
FL 171 17.29 17.99 1.70


Thanks in advance for your help.
Smitha

 

[SkipVought]

Hi,

Turn on your AutoFilter an filter on Change "<>0"

Skip,

_{Have you heard that the roundest knight at King Arthur's round table was...
Sir Cumference!}