Copying certain cells from one column
Closed
Emma
-
Jan 21, 2012 at 05:33 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jan 21, 2012 at 06:31 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jan 21, 2012 at 06:31 PM
Related:
- Copying certain cells from one column
- Protect pdf from copying - Guide
- Display two columns in data validation list but return only one - Guide
- Copy cells from one sheet to another - Guide
- How do i auto number a column in excel? ✓ - Excel Forum
- Clear only the formatting from the selected cell (leaving the content) - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jan 21, 2012 at 06:31 PM
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