Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Feltond
 
Posts: n/a
Default need to fill cells automatically

I've imported a data file into Excel that has a unique 'key' value in column
A and a list of associated values in Column B. The number of values in
column B will vary and the 'key' value in column A only appears once per set
of associated Column B values. I need to fill in the blank cells in column A
with the 'key' value so that each row will have a values in A and B.

This is too large a file to do manually with a manual fill-down each time a
new value in column A is encountered. Any suggestions or solutions?
  #3   Report Post  
Gord Dibben
 
Posts: n/a
Default

Select column A and F5SpecialBlanksOK

With the blanks selected type an = sign in activecell.

Point with cursor to cell above with 'key' and hit CTRL + ENTER.

The 'keys' will fill down.

Copy Column A and Paste Special(in place)VlauesOKEsc.


Gord Dibben Excel MVP

On Fri, 18 Feb 2005 14:01:03 -0800, "Feltond"
wrote:

I've imported a data file into Excel that has a unique 'key' value in column
A and a list of associated values in Column B. The number of values in
column B will vary and the 'key' value in column A only appears once per set
of associated Column B values. I need to fill in the blank cells in column A
with the 'key' value so that each row will have a values in A and B.

This is too large a file to do manually with a manual fill-down each time a
new value in column A is encountered. Any suggestions or solutions?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can an excel cell automatically change fill colors based on values John Clark Excel Discussion (Misc queries) 1 February 5th 05 06:21 PM
Change a cell's fill color dynamically? Arlen Excel Discussion (Misc queries) 2 January 22nd 05 10:51 PM
Excel - formula to calculate colored fill cells within a range wi. MA Excel Worksheet Functions 1 January 7th 05 05:06 PM
Fill blank cells jenny Excel Discussion (Misc queries) 2 January 7th 05 03:33 PM
Protected cells -automatically format to a different color Fred Evans Excel Discussion (Misc queries) 9 December 3rd 04 01:59 PM


All times are GMT +1. The time now is 01:22 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"