Listing Values Found in A Column to Another Column

[zakmuh]

Hi. As shown in the attached screenshot, column E finds numbers from column C, checking column A for non empty cells; =IF(ISBLANK(A2),"",C2). I need help with listing column E values into column G, without any gaps between cells, and I want the duplicate values as well.

Thanks a lot in advance.

Zak

 

[Peter_SSs]

Oops, my original responses deleted as I missed that this is most likely a Google Sheets question?

 

[zakmuh]

Hi Peter. Yes its for Googlesheet but Im working on Excel at the moment. DO they work differently with regards to formula?

 

[Peter_SSs]

In Excel, if you have Microsoft 365, you can do it like below. I am not very familiar with Sheets.

21 10 24.xlsm
	A	B	C	D	E
1
2	a		1		1
3	b		2		2
4			3		5
5			4		7
6	c		5		7
7			6		11
8	d		7		7
9			8		7
10			9
11	k		7
12	l		11
13			12
14	m		7
15			14
16	y		7
zakmuh

Cell Formulas
Range	Formula
E2:E9	E2	=FILTER(C2:C16,A2:A16<>"")
Dynamic array formulas.

 

[zakmuh]

In Excel, if you have Microsoft 365, you can do it like below. I am not very familiar with Sheets.

21 10 24.xlsm
	A	B	C	D	E
1
2	a		1		1
3	b		2		2
4			3		5
5			4		7
6	c		5		7
7			6		11
8	d		7		7
9			8		7
10			9
11	k		7
12	l		11
13			12
14	m		7
15			14
16	y		7
zakmuh

Cell Formulas
Range	Formula
E2:E9	E2	=FILTER(C2:C16,A2:A16<>"")
Dynamic array formulas.

Thanks, it worked with sheet!
Your formula finds the values and also listing them but I want to extract the numbers from that particular FOUND column E. So I changed it to this =FILTER(E2:E16,E2:E16)