Excel Formula Concise List for blanks

[Steph04]

Hello--
I need assistance with creating a formula that checks to see if column B is blank-- if it is blank then I want it to pull the information in Column A. This will be an on going spreadsheet so a vlookup wont work because i'd like the results to be a concise list of the results with the column A data. The results column in the real spreadsheet will be on a different tab and there for we would only work those "numbers"

FOR EXAMPLE

Column A	Column B	Results
4		4
3	Uploaded	9
6	Uploaded	2
9
0	Uploaded
2

 

[Fluff]

Hi & welcome to MrExcel.
How about

+Fluff 1.xlsm
	A	B	C
1	Column A	Column B	Results
2	4		4
3	3	Uploaded	9
4	6	Uploaded	2
5	9
6	0	Uploaded
7	2
8
9
Master

Cell Formulas
Range	Formula
C2:C4	C2	=FILTER(A2:A20,(B2:B20="")*(A2:A20<>""))
Dynamic array formulas.

 

[Steph04]

THANK YOU! This worked perfect!!!!

 

[Fluff]

You're welcome & thanks for the feedback.

 

[Steph04]

Hey Fluff if you're still out there i have a follow up question on this. Do you know if there's a way to use the Dynamic array formula to check multiple sheets that for columns that are blank and pull back that information on one sheet? Basically what you did above but have that check another sheet also?

 

[Fluff]

That's a completely different question, so needs a new thread.