Search results for query: *

understood, thanks, I've resolved the issue. when i added the quotes around the M, NT, and S earlier on, i also redefined my tables. Unfortunately i fixed the formula problem using Skips observation and then created another by having the names using the ranges from the wrong sheets. What an...

Thanks, What I noticed is that the reference column to look at is a concantenation result. Would that make a difference. when i debug it, it just goes to a #N/A. Is there a different way to debug it? I use the show calculation steps to evaluate the formula. I'm not familiar with the Index and...

i've made the correction and get a #NA error. evaluating the expression I get to the point where the second vlookup occurs since the selected variable create a true condition. it is this second expression that creates a #NA result. I don't know why the Vlookup doesn't find the target cell value...

I'm trying to populate certain cells on one sheet using other sheets as a source. I will select from one drop down list a prefix (M, S, NT) this will be the identification of which vlookup function to execute. Each vlookup will have a different named range. The target item number to look for...

Thanks Skip, So far works great, and will save alot of updating time later. Gary

JOB 250 198 212 211 232 233 FPY1 0.8 0.5 1 0.7 0.8 0.9 FPY2 0.3 0.9 0.9 0.7 0.8 0.9 RTY 0.24 0.45 0.9 0.49 0.64 0.81 This data starts in row 11, and Column B (B11 contents is JOB) Row 1 contains some Product line information, nothing that changes on any basis. Likewise down thru to row 11...

this was copied from microsofts site Name Definition Date =OFFSET(Sheet1!$A$1,COUNTA($A:$A)-30,0,30 Price =OFFSET(Sheet1!$B$1,COUNTA($B:$B)-30,0,30) These formulas tell Excel to start at the 30th row from the end of the populated area and create a range encompassing 30 rows and 1...

I'm inserting because i'm creating empty cells to be populated with data collected from the operating floor. it does not exist yet in electronic form until entered by the technician. Inserting allows older data to trailoff the sheet to the right, and still avaialble if needed at a later time...

I have some charts whose values and axis labels comes from cells in 4 rows. (10 cells in each row). I have a macro which will insert a new column of 4 cells, moving the existing cells right. my goal is to have the chart reflect only the most current set of data (10 cells) ignoring the oldest...

thanks again, I have and will continue to brush up on their advantages Gary

i just realized i used the shortened formula "sumprodct" which obviously doesn't work thanks for all the help and the education on this formula, this will work out well, gary

now these work =SUMPRODUCT(--(PROJECT=N14),--(TASK=O14),(HOURS)) or =SUMPRODUCT(--(PROJECT=N14)*--(TASK=O14)*--(HOURS)) i musta pissed off the first buncha formulas somehow

Here are the 2 formulas i tried to evolve from your example =SumProdct(--(H16:H27=$N$14)*--(I16:I27=$O$14)*(J16:J27)) =SumProdct( --(PROJECT= N14) * --(TASK = O14) * --(HOURS)) where i have created names for the ranges. i reviewed the sumproduct description you provided and found it very...

I should clarify one item. While the table i provided shows 4 different task numbers which repeat, in reality there are many more. I would like to return the hours based on selected project, and selected task. I tried the sum product, but that made no sense to me and returned a #name? error...

here is a sample of the data i'll be working thru each month. we have a project name, task number , and reported hours. I'd like to make a formula that allows me to select the project name from a drop down, select the task, again from a drop down, and then have it report the associated hours. i...

perfect.. so the first formula is creating cell adress' in intervals of 300. the second does the same except it reports back the value in the cell at that adress. vuuurrrry nice.. changing 300 to another variable will allow adjustment of the resolution (number of samples per minute used)of the...

Geoff, I tried the formula for formula for creating the 1-300 pattern. that works well. I then used the second formula for extracting values. it created 112 new values. The range of values in that column look correct. But i am unsure of how that formula works. How do i explain to the next person...

i used the method of creating a column with a pattern, and then filtering based on one of the values. That worked OK. I'm going to pursue the concept of averaging every so many values, meaning take every 50 values, average them, put that average in a new cell take the next 50, and so on down the...

i may be thinking too hard but is there an easy way to take a column of sequential values 10-500 incremented by 10's and have it copy down. I can create the pattern, and drag it down, but thought there must be an "excel" way to define it. I get bored dragging down the pattern for 38000 rows Gary

We have large data dump files created from data aquisition equipment. The data is captured at about 30 times a second. I'd like to pull from the data about 1 data point for every 1 - 10 seconds. The data imported into excel OK but the times are carry out 9 places when converted to text. I need...