nth

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

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

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

Is there a way to sum a range of rows every nth column. For example I want to sum rows 10 - 30 every 4th column. Can I use SUMIFS somehow to do this?

I've got a dataset with the following columns: UniqueID | Date | Action [Ex: U123 | 12/1/16 | purchased widget] I need a formula to put in each row that will tell me what step it is for that unique id. I the example above, if "purchase widget" was the 5th thing U123 did, the formula would...

I currently use .Find to find the first instance of a value then use .FindNext to find the second instance. It works great because I use it to insert a page break after the second instance. Now I need it to find the 10th instance of a value. If there are less than 10 the pagebreak will be at...

Hello, I am trying to use the frequency formula, but with multiple values. For example: I have 2 columns: "'Nth' Visit" and "Days between visits". In the "nth" visit it shows which number visit a certain date is for a customer. This ranges from 1 visit to 7 visits. What i am wanting to do...

Hey, I need to find the max number between B2:B100 but only looking at B2, B5, B8 etc and then return the header in A2:A100. I can find the max between nth using =MAX(IF(MOD(COLUMN(B2:M2)-4,3),,B2:M2)) CSE but can't seem to work an index into that. Thanks,

Hi, I need to extract G1 and then J1, M1, P1 etc.. Thanks,

Hi guys, I am trying to plot a graph but I have a lot of data. I have 213,792 rows of data but Excel only lets you plot 32,000 data points on a graph. How do I plot every 7th row of data instead? Below is a small look at what my columns look like (and the rows would be filled in of course)...

Hello! I am having some trouble trying to add cell values together starting from N14 through to N1805. I would like the formula to include these cells and every 9th cell in between. For Example, the first cell in the sum would be N14, then N23... Through to N1805. I believe it is a MOD...

Hi. Been searching and struggeling with this a while now. Here is the deal: I have a list (a column few hundred numbers). I also have a form (A whole A4 page) that i want to fill out with this list. Therefore i want to copy a cell in the list to another cell in the form, drag down the whole...

I'm trying to find a way to have the formula find the SECOND match of a specific item that appears twice in a sheet. As an example, I have a Google sheet that lists the two video card inside a computer. The title "VIDEO CARD CHIP TYPE" appears twice in column C and in column D it shows the...

I have a table of data, an extract of which looks like this: <tbody> Country Product Office Sales UK Shoes Leeds 100 UK Shoes Leeds 100 UK Shoes Leeds 150 UK Shoes London 200 UK Shoes London 340 UK Shoes London 560 UK Shoes Birmingham 800...

Good evening All, I have spent several days searching for the first step to begin my A3 printable sheet which will provide me a yearly overview of all bill payments and remaining funds at the end of each wage cycle I have used a tangible Year Planner but I now want to attempt to automate the...

Please help me with a formula to determine if a specific date is nth day of the month. Specifically, I need to know if a date in column A is either the 2nd or 4th Thursday of the month. Column A is a list of all dates for an entire calendar year. The formula would be in column B and return TRUE...

Hi, I am trying to extract the nth word (last name) from a cell following a unique combination of characters (ID #-). I do not want to use VBA, only functions. I need to extract the last name out of each cell which follows 'ID #-', which is not the first name, but the second name after the 'ID...

Hi All, I am trying to have every 118th cell in a column of one sheet refer to every 9th cell of a column in another sheet. Any way to do this? Thanks, Sam

I want to be able to find the nth value using VLOOKUP, INDEX, or something similar. Example: =VLOOKUP(2,A1:B5,2,0) would return "Blue" <tbody> A B 1 3 Green 2 2 Blue 3 4 Green 4 2 Red 5 5 Red </tbody> But, if I want it to find the 2nd "2" so that it returns "Red," how would I...

Given: Formula in cell A1: =Data!A1 Formula in cell A6: =Data!A2 I need cell A11 to reference A3 on the data sheet and so on. Is this possible? Luke