[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[RT] Re: excel question



PureBytes Links

Trading Reference Links

> how do i ask   in excel. how many times did  column  c  was larger
> then d

you could do something like

cell e2 =if(c2>d2,1,0)
then copy that down column e and sum that column

> and how do i ask it  to highlight  all cells in column  c larger then  1.5

select column c and go to format/conditional formatting

-- 
  Dennis