nth

  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. A

    find nth smallest value with multiple criteria

    Hello everyone, I am stuck to find nth smallest value from a range of cells with multiple criteria. I have a formula to extract nth largest values but not being able to reverse that formula to get the nth smallest value. The formula i'm using to extract nth largest value is as follows...
  3. C

    Concatenate Index Small Row

    Guys, So I'm using and index, small, row formula to find the nth occurrence of a result. I'm using the below formula to concatenate the results. {=CONCATENATE(INDEX(Table7[REPAIR NEEDED],SMALL(IF(Table7[ACTION]=$A$22,ROW(Table7[ACTION])-ROW(E24),""),1)),INDEX(Table7[REPAIR...
  4. T

    List Nth item from a range.

    Howdy, I need a UDF to return the nth value from a row or a column. Ex. I want the 4th item (from left to right) in range A2: P2 or I want the 5th item (top to down) from range A2: A16 If it were not very complicated, it would be perfect if I had the choice of the opposite, ie from right to...
  5. J

    Select Every nth cell in a Column and Paste in to a Row of another Sheet

    Could someone please provide assistance in transposing every nth cell of a column to a row on a separate spreadsheet.
  6. D

    Return nth day of the month

    I need a formula that will read a date and return the nth day of that month. For example 01/02/2019 = 1st Friday
  7. S

    Formula to sum every nth row but not all the nth row

    Hi I have some numbers in column A (A1:A200) I want to be able to add every 9 rows from A1 but not all the way In cell C1 i have the number to determine how far i go down so in this example say in C1 i have the number 1 the Return A2 if i have the number 2 then add A1 + A10 if i have the...
  8. D

    Finding the nth day of a month

    How can I find the date of the nth day of a month such as the 10th day of the month using vba and using a excel formula?
  9. R

    Is it possible to store more than one number in a cell (i.e. an array in a cell), and how can the nth element be referenced in formulas?

    Hello, I'm wondering if it is possible to store more than one number in an array. I'm hoping I can reduce the size of my large score sheets by storing the scores of each student in one cell where for example the first element would be math score, the second physics score, the third chemistry...
  10. K

    Cell Reference of the nth Non-Blank cell in a column

    I need a formula that will return the CELL reference (not the value in the cell) of the Nth non-blank cell. This is so I can exclude the column header. So really I need the 2nd non-blank cell, but thought it might be helpful to add the flexibility. So basically if he first non-blank that...
  11. M

    Highlight from the bottom n'th number Cell

    Hello,</SPAN></SPAN> I would like to highlight from the bottom n'th number Cell of the column, column range is variable (the n'th number is in the D2=8 is for column D & the n'th number is in the E2=12 is for column E</SPAN></SPAN> Like this <b></b><table cellpadding="2.5px" rules="all"...
  12. M

    need to insert values from column A into column B every n rows

    I have two columns of text Column A contains 100 rows Column B contains 500 rows I want to insert a value from Column A into Column B every 5th row. How could I do this?
  13. J

    Array Populated with Every Nth Row in a Range

    Hey guys! I need to copy 1 out of every "n" number of rows up to the end of the table from one worksheet to another. I've managed to do it with a For Each loop. Using that method takes a while to process all data depending on the number of cells though. I believe that can be optimized by...
  14. R

    Index Match on NTH value

    =IF(AND($D5="Cost",$L5<0),SUM(V5+INDEX($A$3:$S$116,MATCH($A4,$A$3:$A$116,0),MATCH($V$2,$A$3:$S$3,0))),"") Hi all, This index/match works okay - apart from the fact I need it to look at the second (duplicated) value in column A. For a bit of context, I have 2 identical project codes for...
  15. B

    Replace text after nth occurance of character?

    I have a list of IP addresses: 10.9.8.14 10.9.8.24 10.9.8.17 10.9.8.56 10.115.4.3 10.115.4.16 10.115.4.88 10.24.2.132 10.24.2.55 I am looking for a formula to take this column and generate the following in the next column: 10.9.8.0 10.9.8.0 10.9.8.0 10.9.8.0 10.115.4.0 10.115.4.0 10.115.4.0...
  16. D

    Return first 3 characters after nth comma

    Hi, I have a text string like the one below: France, Germany, Mexico, Australia, Croatia I am wanting to return the first 3 characters after the nth comma, i.e. Mex or Aus. How can I go about this?
  17. P

    Renaming every Nth repeated value using macro!

    Hello guys, Can anyone think of a way to add a value to every Nth cell that has a repeating value? Example: <tbody></tbody> <colgroup><col style="width:48pt" width="64"> </colgroup><tbody> Bob Bob Bob Bob Bob Bob Bob Bob...
  18. E

    Insert random data from a set to ranges Nth times

    Using formula or VBA , i want to populate a range with some specific data xtimes coming from another range of cells. my excel sheet is show below. Now i want to randomly fill range F1:J5 with the subjects found in A2:A5 the number of occurrence should match the value in B2:B5 No subject...
  19. V

    Min between two values without a defined nth range

    Hey All, Been working on this for a while and couldn't figure it out, tried offset, and Match/INDEX. I still cant get around the issue of the range not being a consistent nth row. <tbody> 10:00 100% 10:01 95% 10:02 100% 10:03 95% 10:04 92% </tbody> As the above table illustrates the...
  20. K

    Return Nth word from the RIGHT

    Hello Everyone, After a lot of thinking and reading I could not find a solution, so I thought someone might be able to help. I managed to return first and last word from a cell, even managed to return the Nth word from a text, but could not manage to find a function to return Nth word, if...

Some videos you may like

This Week's Hot Topics

Top