ExcelBanter - Choose the cells where there is a value

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Choose the cells where there is a value (https://www.excelbanter.com/excel-discussion-misc-queries/199088-choose-cells-where-there-value.html)

firroo

Choose the cells where there is a value

Hi all,

I have two columns where there is a value in one of them ( column for
negative & the other one is positive ) I want to have a third column shows
the values of the 2 columns before, as I have 500 rows to look at. Can any
one help on this.

Thanks in advanced.

Regards

Gary''s Student

Choose the cells where there is a value

Say data is in columns A & B. In C1 enter:

=IF(A1="",B1,A1) and copy down
--
Gary''s Student - gsnu200800

firroo

Choose the cells where there is a value

"Gary''s Student" wrote:

Say data is in columns A & B. In C1 enter:

=IF(A1="",B1,A1) and copy down
--
Gary''s Student - gsnu200800

Thank you so much it works.

Regards

Gary''s Student

Choose the cells where there is a value

You are very welcome!
--
Gary''s Student - gsnu200800

"firroo" wrote:

"Gary''s Student" wrote:

Say data is in columns A & B. In C1 enter:

=IF(A1="",B1,A1) and copy down
--
Gary''s Student - gsnu200800

Thank you so much it works.

Regards

All times are GMT +1. The time now is 09:05 AM.