Formula for pulling data from 1 sheet copying to another and removing the blank cells.

blanx

New Member
Joined
Mar 10, 2018
Messages
11
So I have a Sheet "Roster" in I8:I35 I have Names, not all cells are full, some days they are some they are not.

On a second sheet i want to have a formula that will copy only the Cells with Data in them and put them in B17:B???

Im having trouble figuring out what formula combinations to use.
 

Some videos you may like

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
42,653
Office Version
365
Platform
Windows
How about
=IFERROR(INDEX(Roster!$I$8:$I$35,AGGREGATE(15,6,(ROW(Roster!$I$8:$I$35)-ROW(Roster!$I$8)+1)/(Roster!$I$8:$I$35<>""),ROWS($A$1:A1))),"")
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
42,653
Office Version
365
Platform
Windows
You're welcome & thanks for the feedback
 

Watch MrExcel Video

Forum statistics

Threads
1,102,334
Messages
5,486,229
Members
407,538
Latest member
kbendelac

This Week's Hot Topics

Top