| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can i choose only visible cells from a autofilter? | Excel Worksheet Functions | |||
| how can i choose only visible cells from a autofilter? | Excel Worksheet Functions | |||
| How do I put combo box values into cells (without using @CHOOSE) | Excel Worksheet Functions | |||
| Choose function gives different results from different cells????? | Excel Worksheet Functions | |||
| Randomly Choose Cells from Colum/Row | New Users to Excel | |||
Linear Mode
