Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Data Fill for Rows

Status
Not open for further replies.
genuineblonde

genuineblonde

Technical User
Jun 8, 2001
30
US
I need to automatically populate blank cells based on the first non blank cell above. Any ideas?

Not all cells are blank in a row. Variable # of blanks rows.


 
Sort by date Sort by votes
Hi, GB,

I entered this formula in row 18. Adjust the range accordingly...
Code: 
=IF(ISNA(INDEX(A1:A17,MATCH(9,A1:A17,1),1)),INDEX(A1:A17,MATCH("z",A1:A17,1),1),INDEX(A1:A17,MATCH(9,A1:A17,1),1))
Hope this helps :) Skip,
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

GPnew
  • Locked
  • Question
Power Pivot Filter out Rows where data is not in all columns
Replies
14
Views
1K
combo
combo
remeng
  • Locked
  • Question
Power Query Split by Table Group by Rows into a new set of group by tables
Replies
2
Views
511
remeng
remeng
E
  • Locked
  • Question
Copying spreadsheet for posting
Replies
2
Views
512
combo
combo
grnzbra
  • Locked
  • Question
Force Data Entry Format in Excel
Replies
10
Views
664
combo
combo
jlr123
  • Locked
  • Question
Excel Formula for combining data
Replies
7
Views
477
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top