Unique Character

[Sefty]

Hello, i need help If I want to fill in the empty row above "PRO-P" in column "K", the result will be as highlighted in yellow.
which in this column is a combination of the contents of the Prop below it. so just combine the Prop instances on the blue highlights

because previously the column highlighted in yellow was empty.
Thank's

matrix_pembangunan_rkp (4).xlsx
	A	B	C	D	E	F	G	H	I	J	K
2
3		KP	02.30.02								067 - Kementerian Desa, Pembangunan Daerah Tertinggal dan Transmigrasi
4		KP	02.30.02								010 - Kementerian Dalam Negeri
5		KP	02.30.02								067 - Kementerian Desa, Pembangunan Daerah Tertinggal dan Transmigrasi
6											010 - Kementerian Dalam Negeri
7		PRO-P	02.30.02.01								010 - Kementerian Dalam Negeri
8		PRO-P	02.30.02.02								010 - Kementerian Dalam Negeri
9		PRO-P	02.30.02.03								010 - Kementerian Dalam Negeri
10		PRO-P	02.30.02.04								010 - Kementerian Dalam Negeri
11		KP	02.30.03								010 - Kementerian Dalam Negeri
12		KP	02.30.03								010 - Kementerian Dalam Negeri
13											010 - Kementerian Dalam Negeri 067 - Kementerian Desa, Pembangunan Daerah Tertinggal dan Transmigrasi
14		PRO-P	02.30.03.01								010 - Kementerian Dalam Negeri
15		PRO-P	02.30.03.02								067 - Kementerian Desa, Pembangunan Daerah Tertinggal dan Transmigrasi
16		PRO-P	02.30.03.03								054 - Badan Pusat Statistik
17		KP	02.30.04								054 - Badan Pusat Statistik
18											054 - Badan Pusat Statistik
19		PRO-P	02.30.04.01								054 - Badan Pusat Statistik
20		PRO-P	02.30.04.02								054 - Badan Pusat Statistik
21		PRO-P	02.30.04.03								054 - Badan Pusat Statistik
22		PRO-P	02.30.04.04								054 - Badan Pusat Statistik
Sheet3

Cell Formulas
Range	Formula
B12:C12,B4:C5	B4	=B3

 

[LazyBug]

Hello!
Do you know how to use conditional formatting (apply to the range $K$2:$K$26)?

=AND(ISBLANK(($B2);$B3="PRO-P")

 

[Joe4]

LazyBug,

If I read the question carefully, it looks like they want to fill the cells with values. Conditional Formatting cannot do that. It cannot populate values, only formatting.
I think the confusion may lie in the fact that they are using the yellow highlighting to show us the cells that they want to fill in.
So I don't think they are asking how to highlight those cells yellow, but rather how to fill in those yellow highlighted cells with the values shown (I assume that they are blank to start).

 

[LazyBug]

LazyBug,

If I read the question carefully, it looks like they want to fill the cells with values. Conditional Formatting cannot do that. It cannot populate values, only formatting.
I think the confusion may lie in the fact that they are using the yellow highlighting to show us the cells that they want to fill in.
So I don't think they are asking how to highlight those cells yellow, but rather how to fill in those yellow highlighted cells with the values shown (I assume that they are blank to start).

I apologize. My mistake, you're absolutely right.
(I don't understand how the K13 cell is filled in.)

 

[Joe4]

I apologize. My mistake, you're absolutely right.
(I don't understand how the K13 cell is filled in.)

Yeah, me neither. I don't understand why the "054..." value from line 16 wouldn't also be included in there, according to their description.
Not sure if that was just an oversight on their part, or there are more rules here that they did not tell us about.

 

[Sefty]

that right

I apologize. My mistake, you're absolutely right.
(I don't understand how the K13 cell is filled in.)

I want to fill cells K13, with unique characters in cells k14-k15because I have a lot of data up to 2000, can I use a macro based on column K if column B is Prop?

 

[Joe4]

that right


I want to fill cells K13, with unique characters in cells k14-k15because I have a lot of data up to 2000, can I use a macro based on column K if column B is Prop?

But B16 is also "PRO-P". So why isn't the value from K16 also included in the value you show in K13?
It seems like it should, according to the rules you have explained to us.

 

[Sefty]

for PRO-P in B7-B10 the result will be written in K6 while B14-B16 results in B13

because after PRO-P there is KP so KP is a separation/differentiator between the KP groups whose K column you want to take

The one highlighted in yellow is the desired result, which is taken from the combination of the columns highlighted in blue which are directly below it

 

[Sefty]

But B16 is also "PRO-P". So why isn't the value from K16 also included in the value you show in K13?
It seems like it should, according to the rules you have explained to us.

for PRO-P in B7-B10 the result will be written in K6 while B14-B16 results in B13

because after PRO-P there is KP so KP is a separation/differentiator between the KP groups whose K column you want to take

The one highlighted in yellow is the desired result, which is taken from the combination of the columns highlighted in blue which are directly below it

 

[Joe4]

You still have not answered the question I asked. I will try one last time, before moving on.

Why does cell K13 show:

010 - Kementerian Dalam Negeri
067 - Kementerian Desa, Pembangunan Daerah Tertinggal dan Transmigrasi

and not:

010 - Kementerian Dalam Negeri
067 - Kementerian Desa, Pembangunan Daerah Tertinggal dan Transmigrasi
054 - Badan Pusat Statistik

as it appears that the value in cell K16 meets your criteria, and should be included in cell K13?