You are very welcome
--
Gary''s Student


"leo" wrote:

> worked like a charm, thank you
>
> "Gary''s Student" wrote:
>
> > =IF(NOT(ISBLANK(B1)),B1,A1)
> >
> > --
> > Gary''s Student
> >
> >
> > "leo" wrote:
> >
> > > i want to put in column c the value from coulmn B if there is a value in
> > > columns A or B. If there is a value in column A only then populate with that
> > > value.
> > >
> > > for example
> > >
> > > A B C
> > > 1 1
> > > 2 3 3
> > > 2 2