1. J

    nth Composite Number UDF

    I am looking for a UDF to compute the nth composite number (nth non-prime number) similar to the nth prime. for e.g., 1st prime number is 2. 1st composite is 4. 10th prime number is 29. 10th composite is 18. 100th prime number is 541. 100th composite is 133.
  2. J

    Need Formula for Timeband Name in Answer Column as per Below Details

    <colgroup><col><col><col><col><col><col><col></colgroup><tbody> Telecast Date Telecast Day Day Start Time End Time Time Zone Answer 1-Aug-19 Thursday Weekday 7:00:00 12:00:00 Morning Prime Time 2-Aug-19 Friday Weekday 17:00:00 21:00:00 Evening 3-Aug-19 Saturday Weekend 13:00:00 16:00:00...
  3. P

    Find a prime factor of a number

    Say I have a number, for example 212, is there a formula which will find me a prime factor, preferably the smallest or else the largest, of that number (without counting 1 or the number itself)? In this case it would be 2. Note that the smallest factor of a number (again, not counting 1 or the...
  4. J

    Excel combine charts

    hi guys, i have a question about Excel charts, can someone plz help? i have the two data sets below. i want to combine it into one chart, where i show stacked bars for each of mortgages, Lines, and Prime Based across time but then on the same chart at the top i want to include two lines for...
  5. P

    VBA help - Count Prime Numbers

    I have created a function PRIME(n) with Boolean output to check if a number is prime or not I am now looking to create a function that counts the prime numbers between two numbers n1 and n2 Help much appreciated!
  6. V

    Combine text content of cells, basing on a given syntax

    Hello! I have a worksheet including a table (see the below link) with more similar / repeated sections, referring to some specific elements. The sections combine some titles with identic name (Materii prime pentru ………… and Subtotal costuri materii prime pentru ………………..), with other...
  7. E

    Move rows to sheets based on alpha numeric value

    Greetings, I'm officially stumped on this one. I've searched numerous threads and cannot find what I'm looking for. I'd like a macro created that will copy or paste, whichever is less time consuming, entire rows into other sheets based on a range of alpha numeric characters found in column A...
  8. S

    Prime Factors

    Hi Guys :) I do these days an analytical research and i need some of help in this issue I need to find a way to extract the prime factors of numbers with some special conditions .. Let's take an example to make it much more clear IF i have an an integer number .. let's say 12682 I want to...
  9. P

    How to make a cell turn red if the value is a prime number

    I know how to do the Conditional Formatting stuff for cells, but I need to make a cell that turns red if the number is a prime number. I just need to know if there is a formula that returns true if the value is a prime number and false if it isn't. And if you guys know of an add-in for excel...
  10. W

    Prime number test Mod overflow error

    I'm trying the google, "find the first 10 digit prime in the digits of PI problem" and I'm stuck. I have the logic for it but i keep running into mod errors. Some of this code is lifted as I crashed while doing my last itteration and am too fried to rewrite. Any help is appreciated. Sub...
  11. 2

    Formula Needed if possible

    Can anyone give me a formula that will count prime numbers in a range :confused:

Some videos you may like

This Week's Hot Topics

  • Check VBA code to locate value in cell
    Hello this is the current code I have [CODE=vba] Private Sub TextBox1_AfterUpdate() Dim m As String Dim rx As String rx = Trim(TextBox1.Text)...
  • Reverse Numbers Formula
    Hello Everyone! My computer is Asus My Operating system is Windows 10. Can someone please help me with a formula that I can drag down (or up) to...
  • Count If Issue
    Hi all, I'm trying to create an spreadsheet which counts certain words in a cell only once and gives me a total. I can do this but some of the...
  • VBA Check for multiple cell values and copy the cell in column A
    Hello! So I have this code that checks for the values in column "L" in this case it's 25. But I want to change this code so that it actually...
  • Sending mails to specific recipients based on a cells value
    Good morning, I am trying to get excel to send out an email to different sales reps. So if row X is an error code of "999" then excel needs to...
  • Matching Number in Textbox
    Hello Excel Users, I come with a request. Hope all are doing fine. So I have 1 textbox to type in numbers etc. 12345 (it will always be 5...