Filling the blank cells based on a criteria

banerg

New Member
Joined
Oct 8, 2004
Messages
33
I have a data set with 50,000+ rows.

In col 1, I have zip codes and in col 2 I have B_Codes, in col 3 there is mem_info. For Each given zip and B_code, there are multiple values of mem_info. I want to use pivot table to analyze mem_info using zip & B_code. But the problem is: Zip code value and B_code value are only in the first row.
Eg:
Zip 1 B_Code 1 Mem_info 1a
blank blank Mem_info 1b
blank blank Mem_info 1c
blank blank Mem_info 1d

Zip 2 B_Code 2 Mem_info 2a
blank blank Mem_info 2b
blank blank Mem_info 2b


I want to copy that B_code value to all the rows in the given Zip for the given Mem_info.

I was trying using VBA's xldown function, but due to blankcells in the Zip & B_Code column, I was not able to select the entire column.

I would appreciate your help very much. I am very new to programming. Also, how do you post a sample of your data in this board ( I wanted to post that to facilitate my question). Thanks.
 

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

banerg

New Member
Joined
Oct 8, 2004
Messages
33
Thx so much, but the other part of my question was my main problem. Thx anyways.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,370
Messages
5,595,768
Members
414,017
Latest member
surajks

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top