Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. falcon4

    excel if functions with various vloopups

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

    excel if functions with various vloopups

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

    excel if functions with various vloopups

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

    excel if functions with various vloopups

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

    Updating charts with fixed cells

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

    Updating charts with fixed cells

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

    Updating charts with fixed cells

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

    Updating charts with fixed cells

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

    Updating charts with fixed cells

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

    trying to select a value based on 2 criteria defined in 2 drop lists

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

    trying to select a value based on 2 criteria defined in 2 drop lists

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

    trying to select a value based on 2 criteria defined in 2 drop lists

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

    trying to select a value based on 2 criteria defined in 2 drop lists

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

    trying to select a value based on 2 criteria defined in 2 drop lists

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

    trying to select a value based on 2 criteria defined in 2 drop lists

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

    selecting certain cells from large data file

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

    selecting certain cells from large data file

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

    selecting certain cells from large data file

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

    selecting certain cells from large data file

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

    selecting certain cells from large data file

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

Part and Inventory Search

Back
Top