Logic test: Checking a number against multiple divisors

Excel sages,

I've got a column with a list of numbers in ascending order. I'd like to make a formula for the second column that draws out only those numbers that are not divisible by previous numbers in the column. I am not looking for prime numbers. I'm just trying to check divisibility (with no remainder) against multiple cells. Because my column A is in ascending order, I figured I could make the formula simpler by making the "divisor" any previous cells.

I've created a mock-up to show what I'm going for:

(Column A)
Number list in ascending order
5
7
12
15
20
24
53
242

Because 15, 20, and 24 are divisible by either 5 or 12, I'd like them to be dropped from Column B, and would like Column B to show:
7
12
53
242

I tried the formula =IF(MOD(A9,(A2:A8))=0,"",A9) and pasted it in B9, but it returned #VALUE!

I've used the MOD=0 formula before, but only using a single divisor. I imagine I'm getting the error because I'm using a range of cells as the divisor. NOTE: I'd rather not do each cell as an individual formula because although I've made my data smaller here, in the actual worksheet there are hundreds of numbers. I attached a simplified Excel worksheet here.

Please help!

Thanks
J

Bo_Ry, that worked like a charm. Thanks so much!

I have a follow-up question. When I made the "sample spreadsheet" I took out any blank cells in Column A, but my original spreadsheet actually has blank cells. So the equation works until it hits a blank cell, then gives an error. Any suggestions?

Sorry that I didn't account for that when I gave my example.

See attached. As I said, I'm hoping to create one more column to the right that extracts only the numbers not divisible by the numbers above it. The formula you provided worked great but had a problem once I tried it out on a spreadsheet where the column had empty cells.

Could you just wrap the formula Bo_Ry gave you in an IF() function to check if A2 is "" first and return a "" if it is?

IF(A2="","",(The formula Bo_Ry provided))

I tried that. No luck. It gives a VALUE! error. But thanks!

You guys are amazing and so so helpful. Jete, I posted your second equation and it resolved the #Value! error I was getting. But it isn't ignoring numbers that have divisors. I'll post the updated Excel spreadsheet to show you.

**=IF(SUMPRODUCT(N(NOT(IFERROR(MOD(D2,D$2:D2),1))))>1,"",D2)

** It is an array formula, enter with Ctrl + Shift + Enter.

Or try array formula:

**=IF(COUNT(1/(MOD(D2,D$2:D2)=0))>1,"",D2)

Thanks, Phuocam. Unfortunately, I already tried that first formula (JeteMc provided the same one). But I tried your second formula with the same result.

The formulas you guys provide allow me to avoid the #Value! error, but then it lists all the numbers...not just the numbers that don't have divisors. What I'm hoping is that it won't show 25, for instance, since 25 is divisible by 5, which already appeared higher up the list. But instead it lists both 5 and 25. See what I mean?

What I was hoping to do is avoid creating a macro, since I don't know anything about macros. The only thing I can think to do would be to create a macro that removed all numerals and then compressed them into a new column without empty cells. Then I could use the formula that Bo_Ry provided. But I'm hoping to avoid that.

THAT'S IT! Thank you, all, for your patience. You are all rock stars. This was my first time trying to enter an array formula. I must've been doing it wrong. That fixed it.