Solved

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

Posted on 2013-11-12
7
452 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
  • 3
  • 2
  • 2
7 Comments
 
LVL 48

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 48

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
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
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

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Over the years I have built up my own little library of code snippets that I refer to when programming or writing a script.  Many of these have come from the web or adaptations from snippets I find on the Web.  Periodically I add to them when I come…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

743 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now