Hello Experts,
Is array possible to get following Prime numbers from a given cell?
1,2,3,5,7,11,13,17,19,23,25,27,29,31,37,41,43
Thanks
Hello Experts,
Is array possible to get following Prime numbers from a given cell?
1,2,3,5,7,11,13,17,19,23,25,27,29,31,37,41,43
Thanks
1 isn't prime, but aside from that, you want a list of prime numbers?
Entia non sunt multiplicanda sine necessitate
Hi SHG,
Thanks ! I thought 1 is prime number...
I want only up to 43 and not beyond,
Thxs,
Karnik
You already have that list ...
Hi SHG,
My data in columns is up to 2080 nos and numerous cell contains individual prime number...
I wish to copy in new cell.. some how my following formula is incorrect ( I use Excel 2007)
=IF(A1={2,3,5,7,11,13,17,19,23,25,27,29,31,37,41,43},A1,"")
THX
Karnik
change that to a vlookup, and put the primes in theor own table...
=IFERROR(VLOOKUP(A1,C2:C8,1,FALSE),"")
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
happy to help, and thanks for the rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks