Report Lookup Data

amcmlt

Board Regular
Joined
Feb 2, 2015
Messages
82
Hello,

I am struggling with a solution to select data within cells and skip cells that are blank. The following is a description of what I have going:

Group 1 - Book Size
6 cells in 1 row
Cell shows the size based on selection made. The selection can require up to 3 sizes.

Group 2 - Book Weight
6 cells in 1 row
Cell shows the weight based on the selection made. Again if 3 sizes are needs, 3 weights will display

How do I create a report that will only include the cells that are not blank?

Report would be displayed as:

Group 1 first size listed and Group 2 first weight listed

This would repeat should 3 size/weight combinations are required.

Hope someone can show me the proper method to accomplish.

Thank you!
 

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

Watch MrExcel Video

Forum statistics

Threads
1,090,247
Messages
5,413,291
Members
403,472
Latest member
ArtisticOwl

This Week's Hot Topics

Top