Exclude empty cells

**Busk** · 04-21-2017, 09:50 AM

Hi everyone!

The goal with this excel is to calculate the cost for certain items (fruits in this example) based on total value and the quantity.
Then I want to export the data to another program (just with Clipboard, Ctrl+C)

Please take a look at the example file where I have added the information needed, but now I need a simple way to export the data without the blank rows (H4:H19).

Simplicity for the user is the key, so my first idea was to make a button with a macro that simply copy the range H4:H19, but then all the empty/blank rows is included.

Hopefully it will make more sense after you look at the file, but otherwise please let me know and I will try to explain my question better.

Maybe there is a totally different solution that is better?
Grateful for your help!

BR,
Erik

**Special-K** · 04-21-2017, 10:12 AM

=IFERROR(INDEX($A$4:$A$19,SMALL(IF(($C$4:$C$19<>0),ROW($A$4:$A$19)-3),ROW(A1)),1),"")
Array formula, use Ctrl-Shift-Enter

copy down for as many rows as you have in column A

**ChemistB** · 04-21-2017, 10:53 AM

Here is a non-arrayed solution (very similar to Special K's)

In A26 copied down and across

=IFERROR(INDEX(A$4:A$19,AGGREGATE(15,6,(ROW($A$4:$A$19)-ROW($A$4)+1)/($C$4:$C$19>0),ROWS($A$26:$A26))),"")

**Busk** · 05-15-2017, 02:54 AM

Thank you guys!
Sorry it took me so long to answer, but I went for Special Ks solution and it worked like a charm.

Exclude empty cells

LinkBack

Thread Tools

Rate This Thread

Display

Exclude empty cells

Re: Exclude empty cells

Re: Exclude empty cells

Re: Exclude empty cells

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Count according to date & exclude empty cells

[SOLVED] Exclude empty cells from a calculation

Excel 2007 : exclude empty cells

Exclude empty cells

Excel 2007 : how to Calculate formula to exclude empty cells

How do I exclude empty cells from being printed?

How to exclude cells that are empty?

Bookmarks

Bookmarks

Posting Permissions