?
Solved

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

Posted on 2013-11-12
7
Medium Priority
?
493 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 52

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 52

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
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.

 
LVL 85

Accepted Solution

by:
Rory Archibald earned 2000 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

This article describes how to import an Outlook PST file to Office 365 using a third party product to avoid Microsoft's Azure command line tool, saving you time.
This article describes a serious pitfall that can happen when deleting shapes using VBA.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

764 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