How add constraints of not equal to when sign/relationship have only =, =, =, Int, or Bin ? eg. if a contraint is "rang C8:D13 are not equal to range...

when I put my flash drive in my computer will not give me a drive

Hello, I want to calculate the average value of a large range of cells in a column. The snag is that many of the cells are blank, or contain text. I only...

I have an excel document with credit card numbers and it is possible for me to to only show the first 4 and last 4 numbers and mask what is between. For...

I protected a worksheet for other users to enter data into and protected the worksheet against other changes. Now the CTRL-F feature does not work. How do...

I have a column with 14 digits in each row of the column. Is it possible to only show the last 8 digits of the number for each row? If show I can I do this?

How do I turn off the "Office Live" feature in Excel 2007 Vista?

I e-mailed a workbook to a collegue that contained 28 worksheets. On my PC, all the vertical page breaks were set so printing was done on one page for each...

I have read and reread through questions here on the site, but can't find an answer to my question: With Vista do I have to change the screen resolution...

I have a pivot table containing dates, products and amount. I have right clicked the date field to group the dates bi-weekly since the only dates in the...

I am trying to utilize a Vlookup but I have two cells I want the table to look up from to pull the price of an item. For one item we have a standard price...

Dear sir,with best regards, i have in attached file a scheduale contains some data like(invoice no.,date,amount, agent) ,i ask you kindly to help me to...

see subject

How can i sort this 1/1 1/2 10 191/2 2 201 202/5 280 3 3/2 to this 1/1 1/2 2 3 3/2 10 191/2 201 202/5 280? Please help!

Hi, I'd like to test whether there are any blank cells in range of cells I have. If there are blank cells in the range I'd like them to return "False" and...

i just had office 2007 installed on my computer at work. we have a shared drive here with tons of files that i need to review and manipulate. however, not...

I have 2 columns and wish to retrive the info from the 2nd column. If I type the name from the 1st column I get #N/A, if I copy directly from the 1st column...

HOW DO I ALPHABETIZE A LIST OF SCHOOLS

I have a total of 1346:16:00 hours formatted :mm:ss. When I try to divide this into number of peices picked 13384. I get 238.60 but when I have entered on...

i using windows2003 but when i'm typing and trying to use the spacebar it brings up dots instead. i'm not a computer whizz so could some help me step by...