excel 2007 formulas

  1. A

    Restrict value input in a column based on another column

    Please help... How could I make it so the user can only input an "X" either in column "D" or column "E" (on the same row) but not in both columns? Basically if there is an "X" marked in one column (either "D" or "E" on the same row), the other column will be restricted to enter a value. Mich...
  2. D

    I don't understand why vlookup is returning 0

    Hi Using excel 2007 My formula is this: "=IF(I3="","",IF(ISERROR(MATCH(I3&L3,Lists!S:S,0)),"",VLOOKUP(I3&L3,Lists!S:T,2,FALSE)))" Column S in Lists is formatted as general, column T is date. The format of the output (formula) cell is date. I3 is formatted as general, L3 date. Let's say I3 is...
  3. C

    Excel 2007 Identify bad meter readings

    I have a series of meter readings sent in by field techs that tend to have finger checks & provide absolutely bizarre readings. Do you have any idea how I can identify the "Bad" meter readings using excel? .... Thanks! <tbody> <colgroup><col width="71"></colgroup><tbody> <colgroup><col...
  4. S

    Excel 2007 (I know) Conditional Formating

    I still have 2007 and am trying to use a formula to pull a match from another worksheet but 2007 will not allow "AnotherWorksheet!" Is there way like Vlookup or Match that I can use to look at worksheet 2 for a match and if so highlight cell in worksheet 1? Thanks, Steve
  5. M

    Creating a formula for a football stats spreadsheet

    I’m new here so would like to say Hello all and thank you for reading J I’m creating a stats spreadsheet for football and have managed so far with all required formulas but this particular one is just killing me The below formula basically looks at A2 and finds the sheet reference and works...
  6. L

    conditional formatting formula help excel 2007

    I need to write a formula that will highlight all of the transactions that occur within 3-5 seconds of each other. My data cell contains a dated timestamp in this format: 9/30/2011 6:29:46 PM. Thanks for the help in advance!
  7. D

    Help with if formula within if formula

    HI, Can someone please help me??? In cell L3 I need to execute this formula... =IF((L8-I14)>0,"YES","N/A") but I only want this formula to run if the cell I10 contains the text YES. If the cell I10 contains NO I want the cell I10 to display N/A. PLEASE HELP ME!!!!! I have spent hours...
  8. W

    Extract words from the middle of a description?

    ARLINGTON AWR.24"X30" Double Door Wall Cabinet (KITCHEN) OAK I want to extract the "Double door" from J3's description and fill into a new cell like jj3. I tried =mid(formula) as it states in the help. But it didn't work. Help....
  9. W

    Excel 2007 creating a search from a spreadsheet?

    Can someone kindly help me on how to create search terms for a spreadsheet that I have been working on? Please help...
  10. JoETV

    Excel 2007 absolute path names case sensitive

    Hi everyone, in Excel 2003 absolute paths were not case sensitive, in Excel 2007 they are. Hope this can save you time troubleshooting recently converted spreadsheets (from 2003 to 2007). Specifically, for VLookup to network files you get a '#N/A' error
  11. T

    How to tell if a value is between two other values from a list

    I have a spreadsheet in Excel 2007 (on Windows Vista) which has two columns of numbers (they're actually currency amounts) similar to this: A............B 0.00......30.00 30.01.....32.50 32.51.....35.00 35.01.....37.50 37.51.....40.00 40.01.....42.50 ... And so on, up to 242.50.....245.00...
  12. H

    HELP with picture in excel 2007

    Hello In cell A9 I have the name "Bob" and in cell B9 I have the name "Smith". In cell A10 I would like the picture for "Bob Smith" to appear. Here is the formula that I am trying but its not working. The picture is named Bob Smith.jpg and is currently located c:\Bob\Golf\Golf Tracker\...
  13. H

    Help with COUNTA formula

    Hello Working in excel 2007 and I am trying to use "COUNTA" to count how many "TRUE"'s I have in a range. This is what I have but it's not working. What am I missing? =COUNTA(C10:K10) Any help or suggestions will be greatly appreciated. HDfatboy03
  14. S

    Relative Referencing not Working...Please Help

    I have this LONG formula in a cell (J895). When I copy and then paste it to J937 I would expect it to act RELATIVE in respect to the rows on the same sheet. But instead, it pastes the same formula, like an ABSOLUTE. Please help me find what I am missing. Many Thanks...
  15. S

    I Need a Macro Clear Button

    I am using Excel 2007. We have a Database in Excel 2007 (at least that's what I call it ;)). It's used in the field to input ventilation and chemical exposure readings. One sheet we use is named Generic Ventilation. Is there a way to create a macro button (that would not show up on the...
  16. S

    Need to use Print Preview while using BeforePrint Event

    I am using Excel 2007 I have this code in my ThisWorkbook Module: Private Sub Workbook_BeforePrint(Cancel As Boolean) Sheets("Sheet1").Range("B2,B5,B8,B13").Font.ColorIndex = 2 End Sub I have this code in each Worksheet Module I want to use it for: Private Sub...
  17. M

    Need help with a complicated excel formula!!

    I am completely stumped! I work for a tutoring center and I have a form that I am trying to make user friendly for ALL of our employees. I'd like to be able to use it as a time sheet however, I can't seem to get the calculations right. I was able to do the time in, time out, and total hours...

Some videos you may like

This Week's Hot Topics

Top