= 2643F pg 2 of 3 Orange Friday

The easiest way to do this would be use Autofilter and filter on column 6 =
blank

Here's a formula to do this:

Entered as an array using the key combination of CTRL,SHIFT,ENTER (not just
ENTER):

=IF(ROWS($1:1)<=COUNTBLANK($G$1:$G$10),INDEX(B$1:B $10,SMALL(IF($G$1:$G$10="",ROW(B$1:B$10)-MIN(ROW(B$1:B$10))+1),ROWS($1:1))),"")

Copy across 4 cells then down until you get blanks

Biff

"plb2862" wrote:

I have a sheet with (6) columns and (306) rows. I would like to search for
empty cells in column (6) and return the values in columns {2, 3, 4 & 5}.
And continue until the last row 308 is processed.

For Example:
G307 is empty returns
B307 2643F
C307 pg 2 of 3
D307 Orange
E307 Friday

= 2643F pg 2 of 3 Orange Friday

The empty Cell is
G308
B308 2643F
C308 pg 3 of 3
D308 Orange
E308 Friday

= 2643F pg 3 of 3 Orange Friday

Is there a non VBE/VBA solution?

TIA,
Phil