Hello, I have two worksheets which have similar values but are repeating. How do i compare the two and get the items which are not reconciled. Eg Sheet 1 ...

I have successfully created a drop-down list in a excel worksheet. One of the values in the list is 'Miscellaneous'. If a user selects this option, I would...

Hi, I am having a little bit of trouble trying to get the following formula to work: =IF('SSC OTCsuresh'!E2:E1272,"YSM-France-Order-Committal",COUNTIF('SSC...

I am using VLOOKUP in workbook to retrieve information from other files. My formula looks like: =VLOOKUP(B10,'C:\Documents and Settings\alopez\Desktop\Excel...

Sheet 1 cell a1 = vlookup data cell b1 is where I want Vlook up results...curent formla is =VLOOKUP(A1,'sheet2'!$A$10:$I$24,9,"false") Sheet 2 vlookup range...

Hi I have this problem: AF5 has the following...

I am trying to sum a column of hours and minutes to calculate straight hours and overtime. If the sum is =40, then sum; otherwise move excess to the next...

Hi, have read the posts, but still don't have an answer, i am getting "Personal Macro Workbook in the startup folder must stay open for recording" when...

Basically, I've got a spreadsheet that has a range specified for each day of the year. The formula is looking to subtract a previous date (2 weeks ago - Nov...

Hi all, I have a list of related accounts in column P, and the sales budgets on Sheet1. I have tried the following formula to get the total sales budget for...

I have two workbooks,, and i would like to link text from one to another. So when i enter a name on one workbook, the name is linked to the other? Any...

Hi Friends, Here's the equation that isn't working: =if(and(E5$A$2,F5time(06:00:00),F5=time(14:00:00)),"1st...

I'm running Excel 2003 SP2 under Office XP, and I'm having a problem with subtotals above the data that don't appear in the correct order. I've read several...

I have a column that has Y's and N's in it, I need to tally the number of Y's in the column. Is there a function or some other option for doing this?

I have a worksheet (Summary) that pulls information from another worksheet (Manager). I want to run a macro from the Manager worksheet, that first looks at...

Hey, I need Excel to repeat a formula with a interval of 11. My goal is to get this: ='DATA LINK'!F14 ='DATA LINK'!F25 ='DATA LINK'!F36 ='DATA...

I have a spreadsheet with the following column headers: NAME ADDRESS1 ADDRESS2 CITY ST ZIP KIT PHONE DATE This spreadsheet has about 45,000 rows. I need to...

I have been adding data to a very large spreadsheet, but i am now receiving data with the same id number. Is there anyway i can have excel telling me this id...

I need to copy the info from Sheet1 a11 to Sheet2 a4, but then the next entry is Sheet 1 a12 to Sheet2 a 24, Sheet 1 a13 to Sheet2 a44 etc.... with the...