My personal macros workbook no longer opens when I start Excel. I have found it in the XLSTART, and I can't see anything wrong with it, but it doesn't open...

If I have in column Z1-Z10 ten company names, then in columns AA-AJ those same company names with the area's they cover in the respective rows. Is there...

Any ideas where I went wrong here. Can't leave the cell =IF(AND(U2="YES",OR(E2="Not-applicable",E2="Red"),"Yes",""))

Hi, When I use the weeknum formula to calculate the week number on today's date (5th April 2010), the result is 15 (week no.15) irrespective of the return...

I am trying to create a formula using multiple IF statements. Individually they all work but I don't know how to connect them in into one formula. ...

Hi Excel 2003 In C5 i have a start time eg 12.30pm and in D5 I have a finish time eg 20.45pm. I need to calculate the hours and minutes worked in E5, with...

Dear Expert, My office is still using Excel 2000. Conditional format can go up to 3 only. Is it possible to use if function to add more? Say certain certeria...

I want to make a UDF, in which I use the address of the cell itself in VLOOKUP. How do I define the address of the cell ? cell("address") give an...

I could use some guidance on this formula: {=SUM(IF((B$8:B$55="X")*(OR(J$8:J$55=2,J$8:J$55=9))*(IF(VLOOKUP(E$8:E$55,Codes!$M$2:$N$31,2,0)=1,1,0)),1,0))} I am...

I am having an issue where when I open an worksheet, it is automatically selecting cells and I can't figure out how to turn this off. As soon as I open the...

I have many items to input into my selection list in my worksheet. Hence, I came up with the Combo Box (from FORM under Toolbars) function. In addition,...

how can we get in words , when enter number that time display in words

Hi, Column A contains dates starting from A2:A500. H2 is where when i enter a date , get some results in H3. I then manually type those results in column B...

I'm using excel 2007. I'm looking to have a logical test in one cell that will populate a different cell if true, or a third cell if false. For example, the...

Can the countifs function be used to count cells across multiple worksheets? I keep getting a #VALUE! error. I have tried changing the format of the cells...

I have copied a column of numbers to excel and now cannot apply any formulas because the numbers are text. How can I convert the text to numbers? Thanks. --...

I have a list of 3500 names & addresses in an Excel workbook on one sheet and some are duplicates. How do I eliminate duplicates?

My SUMIF argument returns no value but when checking fx the Sum_range reflects the correct value, but Formula result is R – =SUMIF($A4,'TB...

I scanned a huge database into Excel. It has around 300 seperate sheets. All I need to do is combine all the sheets into one sheet. Copy & paste would take...

How can I round 980 to 1,000?