Copying certain cells from one column
Closed
Emma
-
Jan 21, 2012 at 05:33 PM
venkat1926
venkat1926
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
Related:
- Copying certain cells from one column
- Compare cells of two columns excel 2007 ✓ - Forum - Excel
- Compare cell against multiple columns ✓ - Forum - Excel
- Merge adjacent cells in columns with same data/value in excel - Forum - Excel
- Suppose cell c5 contains the formula =b$6+c1. match each formula with its respective cell if you copied it. ✓ - Forum - Office Software
- Excel insert copied cells multiple times ✓ - Forum - Office Software
1 reply
venkat1926
Jan 21, 2012 at 06:31 PM
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
Jan 21, 2012 at 06:31 PM
in an empty cell in row 1 e.g. B1 copy this formla
=IF(A1<=2000,A1,"")
copy B1 dwn
=IF(A1<=2000,A1,"")
copy B1 dwn