nth

Hi guys, this is my first post. I am in desperate need of an experts help please: I have a list of dates in excel (i.e. 12/05/2012) and I want to populate a corresponding column with the Nth occurrence of whatever day it happens to be in that particular month (i.e. 12/05/2012 would output "2nd...

Hii, I need help with some code... I am stuck and have a feeling I'm nowhere near solving this myself! :( I have 24 sets of data in columns 3-26. Data is in rows 2-n (all datasets are same length). 'n' is typically around 2000. I am plotting 24 series on one chart. With about 2000 data...

Hello, This section of code I am working on requires me to find an exact text (I tried lookat:=xlWhole, but I can't get it to work right). The problem being is when it searches for Q1, Q10 is an acceptable answer ans so on. I need to get the 4th occurrence, but my research into Nth occurrence...

Hi, I have a range of id's and a range of monetary values. Col A Col B a 100 b 10 c 20 d 20 etc etc I would like to create a list in another worksheet that shows the n highest values (in col B) and the id of those values. so you would...

I have a large range of automatically generated columns that report daily predicted inventory levels going off into the future about a year so that's 360+ columns of data. These numbers can be positive, negative, or 0. Given a user supplied integer "N" I need to find the StartDate of the Nth...

Hello, I want to analyze the data from every 10th cell in column composed of 1000 rows (ie cells A10, A20, A30 ... A980, A990, A1000). When entering a formula, how do I specify the range which includes these 100 relevant cells, but excludes the 900 irrelevant cells? extraneous information...

Hi, I bet this is an easy question and as soon as someone answers I'll be kicking myself for not thinking about it... but how can I just select every other (nth) column based on a selection? So say I have data in columns A-G. I want to select the data block from A1-G100 and then run this...

Hey guys. I'm new to the Mr Excel message board, I just came out because I had a question that interested me. Sequences. Those lovely little chains going up by a certain number, like 1, 2, 3, 4 ... or 2, 4, 6, 8 ... or 5, 3, 1, -1 ... they have a common term that dictates the sequence. For...

i have a problem adding cells every 5th cell for example i have =SUMPRODUCT((C10:C67)*(MOD(ROW(C10:C67),5)=0)) this adds every 5th row in this range and it does it right as long as there is no text in the cells in between it works fine when it looks like this 1 1 1 1 1 1 1 but it does not...

I have a worksheet that has the quarterly data being presented in columns. As you can see below the quarters for each year are then followed by a summary for the entire year. What I need to do is get it so I can populate the summary cells (1992,1993,1994 etc) with an average of the 4 quarter's...