excel 2007 formulas

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

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

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

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

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

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!

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

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

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

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

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

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

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

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

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

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

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