Reply to forum topic "How to filter some data and copy some cells"
This is a reply to forum topic "How to filter some data and copy some cells":
excelexperts.com/how-filter-some-data-and-copy-some-cells
There is two sheets with two solutions. The first one is a simple and just copy the corresponding row if fulfill the condition. Disadvantage of this is that produce an empty rows for data that not fulfill the formula condition. In the second example I use a little more complex formula which avoid the disadvantage of the first example. To make it to work for you just change the cell references.
Note: If you use the second example there is an array formula and after you type it you must press CTRL + SHIFT + ENTER instead of only ENTER.
Download an example file to see the solutions.
Attachment | Size |
---|---|
IncomeOrExpenseExample.xlsx | 18.31 KB |
- manny's blog
- Login or register to post comments
- 4618 reads
Recent comments
5 years 34 weeks ago
6 years 20 weeks ago
6 years 32 weeks ago
6 years 35 weeks ago
6 years 36 weeks ago
6 years 42 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago