New data list that removes blank entries

[Norts]

[FONT=&quot]I have a list of numbers in column A containing duplicates, and a list of text values in column B. Some of the cells in column B are blank. I would like a formula that generates a new list (on a new workbook or tab) that only pulls through numbers from column A that have a value in column B (and also pulls through this data). I appreciate a simple filter would also do this but I need to use a formula. I hope this makes sense![/FONT]

 

[Peter_SSs]

Welcome to the MrExcel board!

I have done this on a single sheet but hopefully you can adapt to doing it on a separate sheet. Post back if not.

Formula in D2 is copied across and down.

Excel Workbook
	A	B	C	D	E
1
2	3	r		3	r
3	4			3	x
4	3	x		4	d
5	2			5	r
6	1			3	v
7	4	d
8	5	r
9	3	v
10	3
11
New List

 

[Norts]

worked perfectly, thank you!!

 

[Peter_SSs]

worked perfectly, thank you!!

You're welcome. thanks for letting us know.