Ask Your Question
0

Summary from sheet with blank rows

asked 2018-09-12 20:49:49 +0200

jamesb gravatar image

Hi

I have a sheet which produces results something like this:

image description

I'd like to display these results in sequential rows in another sheet. I'm a little stumped, but feel sure that there is some way of making an array match to do this. I'd be most grateful for assistance.

Many thanks.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2018-09-13 07:07:44 +0200

JohnSUN gravatar image

Try this trick

Using Filter.gif

Or any of these tricks - look at YouTube

edit flag offensive delete link more

Comments

Hi JohnSUN

Thank you kindly for your reply. I'm most grateful. Although this method works for non-calculated data, it doesn't seem to work for calculated data. In my sheet, the first cell of the first row shown contains the following formula:

=IF(L2=1,F2,"")

All the other cells contain the identical formula, relative to their position in the sheet. I think I need to show the filtered results in another sheet by some form of array search. Does anyone have another idea?

Thanks again :-)

jamesb gravatar imagejamesb ( 2018-09-13 11:31:50 +0200 )edit

And what other value in column L? Zero or empty cell? In this case, you can use this column as filter criteria and put to report values from column F :-)

JohnSUN gravatar imageJohnSUN ( 2018-09-13 14:06:23 +0200 )edit

Hi JohnSUN. Thanks again. As I said, all cells contain the identical formula, relative to their position in the sheet. No cell is raw data, every cell is a formula. This method only seems to work on raw data.

I'm hoping either I'll figure out the array match method myself, or some kind person will tell me and put me out of my misery! :-)

jamesb gravatar imagejamesb ( 2018-09-13 15:54:37 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-09-12 20:49:49 +0200

Seen: 19 times

Last updated: Sep 13 '18