# nth

1. ### Formula to find a value by going right, down, and then left.

I am looking for a formula that will find the value in cell B1 in the row B5:I5. Then go down from that date to the first non-blank cell. Then go left and return the corresponding value/name in column A6:A12 into cell F1. Thanks in advance. I have been racking my head trying to figure this out...
2. ### 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.
3. ### 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...
4. ### 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...
5. ### 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...
6. ### 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.
7. ### 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
8. ### 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...
9. ### 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?
10. ### 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...
11. ### 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...
12. ### 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"...
13. ### 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?
14. ### 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...
15. ### 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...
16. ### 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...
17. ### 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?
18. ### 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...
19. ### 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...
20. ### 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...

### This Week's Hot Topics ### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?    1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option. Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com". Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button. Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button. Go back