Formula Help Please

[Jfloyd80]

Hi,

I was wondering if there was a formula that could automatically duplicate the first KeyLetter for each row until it changes then repeat?

ITEM LETTERKEY LETTERKEY DUPE
Item 1 A A
Item 2 A
Item 3 A
Item 4 B B
Item 1 B
Item 1 C C


Thanks!

 

[Joe4]

Let's say that your LETTERKEY field is in column C and the DUPE column is in column D, and your first row of data is on row 2.
Then enter this formula in cell D2 and copy down for all rows.

=IF(C2=C1,"",C2)

 

[braindiesel]

If you are just trying to fill in the gaps there is an easier way...
Are you looking for a "ditto" effect? Have each cell that is blank equal the cell above it?

 

[Jfloyd80]

Looks like the spaces were deleted in my fake table. Below is a link to example data.

https://ivie.box.com/s/453115rhj6r34ks6z6wu697az2prlcu7

 

[Jfloyd80]

If you are just trying to fill in the gaps there is an easier way...
Are you looking for a "ditto" effect? Have each cell that is blank equal the cell above it?

Yes, this is correct. I just need to fill in the blanks.

 

[Joe4]

Did you see/try my solution up in the first response?
If it does not work for you, please explain why.

 

[Jfloyd80]

Did you see/try my solution up in the first response?
If it does not work for you, please explain why.

It doesn't work. It's because the spaces in the fake table I created were removed. It was supposed to look like this. Sorry for the confusion.

ITEM LETTERKEY LETTERKEY DUPE
Item 1....A.......................A
Item 2.............................A
Item 3.............................A
Item 4....B.......................B
Item 1.............................B
Item 1....C.......................C

 

[braindiesel]

Step 1 - Select the range tha contains blanks
Step 2 - Press F5 (or Control G) - Go to window opens
Step 3 - Click "Special..." Button
Step 4 - In GOTO Special window choose "Blanks" and click OK
Step 5 - in active cell type "=" and click cell above active cell
Step 6 - Press Ctrl and Enter to put = cell above in every cell
Step 7 - Select range you selected in Step 1
Step 8 - Copy
Step 9 - Paste as Values
Done

 

[Joe4]

OK. I see now. Then use this formula instead:

=IF(C2<>"",C2,D1)

If, instead of wanting it in a new column, you wanted to populate the current column, use the steps outlined here: https://www.extendoffice.com/documents/excel/771-excel-fill-blank-cells-with-value-above.html

 

[Jfloyd80]

OK. I see now. Then use this formula instead:

=IF(C2<>"",C2,D1)

If, instead of wanting it in a new column, you wanted to populate the current column, use the steps outlined here: https://www.extendoffice.com/documents/excel/771-excel-fill-blank-cells-with-value-above.html

This formula works! Such simple logic. I was making it much harder than it needed to be. Thank you!