I am setting up a database that will show me how many wrong entries have been made onto our server. Each row will have info regarding the entry and the last...

I would like to put a short name like "BILL" in column C and have it return a whole block of preentered text about Billing. I need a validated Lookup where I...

I am altering REPLACE functions for different parts of my data. This works OK, but it would be more efficient if I could apply one function to all of my...

This is wrong. The number you are looking for is A1-(A1/1.07) NOT A1*7 "Paul B" wrote: Your welcome -- Paul B Always backup your data before trying...

Hi all, I am trying to find out whether it is possible to password protect a worksheet within a workbook. I have 3 worksheets in my workbook and want to...

Im sure this is a real simple thing to do, but I wasn't able to find anything using the forum search. This is probably because i don't know what I am trying...

Does anyone know how to convert a date into a single number so that you can do calcuations with it? For example, Nov,2005 minus January, 2004 equals 23.

Would someone have an example of how I would use vlookup to produce the outcome from the if statements that are listed below. I want to be able to check one...

I have two separate workbooks. In one workbook there is a code with no description. In the other, the code includes the description in the next column. My user...

I am using the following function in Master.xls =SUMIF(Source.xls!Colours,A1,Source.xls!Values) As long as both workbooks are open, it calculates...

Hi Everyone! I'm using VLOOKUP to match last names. The problem i'm having is multiple people with the same name. VLOOKUP returns the fist match, what are...

Hello, I've created excel worksheet that auto-populates certain cells with today's date to facilate filling out a purchase order worksheet. But problem is...

I'm experiencing a slight rounding error in comparing the Excel product of simple multiplication equations versus the product achieved using a calculator! ...

I am altering REPLACE functions for different parts of my data. This works OK, but it would be more efficient if I could apply one function to all of my...

If any one can help with this query would be much apprieciated i'm very in need of it thanks; Simple example of what i need; on my work sheet i have a row...

"Angela33" wrote: How do you make a column automatically place items in alphabetical order? Also, how do you make a column automatically put dates in...

I need help. Is there aynone out there who can do some data tricks for me in Excel. I have a list of emails and associated account numbers. The problem is that...

I'd like to control the tab order of an Order Entry sheet I'm creating. Can I do this or would I have to recreate it as a form? Thanks

Can I expand the character limit in an Excel row? The column size is 101.4 and the row size is 138 and part of my text is still missing. Is there a remedy to...

I want to copy my page setups from one worksheet to another within a workbook. When I copy and paste, all the worksheet stuff is there but not the page setups...