Solved

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

Posted on 2013-11-12
7
478 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 50

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 50

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
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

831 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