Copy Cells Conditionally in Excel

How to copy cells conditionally in Excel? You have a huge list, you have highlighted them in colors (using some formula), you want to move over the IDs that are not highlighted. How can you do it?

There is really no copy method or function in Excel. One may say you can use VBA to copy cell over, but you can do that right in Excel, using some improvisation. Instead of spending effort on copying data, we are going to use IF formula in the column where you want to copy the cells. If it meets the criteria, it will be copied, if it did not, it will not be copied.

Example

Comming up

Example 2 – more complicated criteria

This example will copy cell overs to the new column if the ID in the original column does not exists in the column where you are looking at the IDs

Use the following formula in the cell where you want to copy the cell conditionally. Then drag this cell over the number of rows depending on how many rows of data you want to copy.

=IF(COUNTIF($E$3:$E$30195,A2492),,A2492)
This entry was posted in Tutorials/Tips and tagged . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s