Solved

How to use filter in Excel 2010 to fill in empty fields (cells)

Posted on 2013-11-12
7
491 Views
Last Modified: 2013-11-13
Hi,
I have a big worksheet in Excel 2010 with many lines (more than 2000) and different fields but I forgot to place some of the cells when I first entered them.
Now, when I use the filter function to try to correct and fill in the empty fields Excel won’t lt me do that adequately.
Does anyone know how to do that?
For instance, I need to fill in the field called DATE (column C), but there are lots of other lines, so I use the filter to choose only the lines with the word “Faxineira” in column B.
A good solution would be to copy column A to column C, but that doesn’t work when I am in the filter mode.
PROBLEM-WITH-FILTERS.png
0
Comment
Question by:Brejinski
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
7 Comments
 
LVL 51

Expert Comment

by:Rgonzo1971
ID: 39641788
Hi,

If you want all cells which are empty in Col C Click the Arrow in Col C / Text Filters / Equals then Click OK not entering anything

Regards
0
 

Author Comment

by:Brejinski
ID: 39641813
Thanks, Rgonzo1971, but I need to filter column B and then fill in column C with the same dates in column A...
0
 
LVL 51

Expert Comment

by:Rgonzo1971
ID: 39641870
Hi

You could use a helper's column with this formula and then paste the resulting column with Paste Values (not normal Paste)

=IF(C1<>"";C1;A1)

Open in new window

Regards
0
Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

 
LVL 85

Accepted Solution

by:
Rory Archibald earned 500 total points
ID: 39644315
Filter column B as needed. Select column C. Press Alt+; to select only the visible cells, then type = and select the cell in column A of the active row and press Ctrl+Enter instead of just enter.
0
 

Author Comment

by:Brejinski
ID: 39644928
Hi, rorya, amazing, incredible, unbelievable, fantastic, awesome solution you got there!!! How did you learn all that?
0
 

Author Closing Comment

by:Brejinski
ID: 39644939
Thank you all, guys, but rorya did give the best of the best answer.
0
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 39644956
Misspent youth. :)
0

Featured Post

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This article describes a serious pitfall that can happen when deleting shapes using VBA.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question