My tab key in Excel moves the cursor a whole page to the right. Pressing enter moves the cursorone space right. HGow do I change the movements to a normal...

what formula do i use to find new suppliers in a big list? I have a spreadsheet with suppliers and qty of goods received for each of them. I have formula in...

Is there a way to protect the worksheet while allowing users to insert a comment box in the unprotected cells of the worksheet?

The following formula is returning a ‘0’ outcome: =SUMPRODUCT(--('TB SAICMB'!B2:B1000="'Computer Sales"),--('TB SAICMB'!D2:D1000="Admin"),--('TB...

Hi, I have a worksheet in which I add a new column each month for the new activity in the trial balance. that information is in one sheet. In separate...

I have a huge spreadsheet where all the dates in the date column are listed as myy. For example "586" should be May 1986, and "801" should be August...

Example, I want to add a new monthly data worksheet to by workbook and pull all the present and past monthly data for a specific client. Currently the data...

Hi All, Using Excel 2007. I have the following data A B C D E F G 45 30 38 75 14 202 3.22 My problem is how to get F...

Using Conditional formating Icons (Arrows) Cell 1 has a YTD formula, Cell 2 through 4 has Numerical Data Using the default formula of: Up Arrow = 67% Side...

We are trying to remove the slashes in the birthdate field but keep the leading zero. We have used text to columns to separate the fields, then converted...

I need to (in formula not VB code) lookup the last non zero value in a row and return the "header record value" for that column e.g below - I want to see...

I filtered non-numerical data in a spreadsheet and need to count the number of remaining rows. The row numbers are not in order due to filtering. What is...

I have the following formula: =SUMIF('weekly dates'!A1:AZ1,""&A5,Details!L7:BK7) Weekly dates is a static sheet, &A5 is the current date and Details!L7:BK7...

i am preparing a master worksheet to roll up numerous jobs. i want to add all cells in the same position behind the master sheet. is there a sum fourmula...

I am not sure if this has been asked/answered before but I couldn’t find anything that would help me, so please if you have any ideas they would be...

I have a column that has first and last name or it may have first, middle and last name. I need to know how to pull the first name in a separate column and...

Hi and thank you in advance I have a large spreadsheet where they have populated values like 3x3ml, 5x0.5ml etc. They are all pretty different. We only need...

I am trying to total all amounts for 1 specific key in one cell. Example: search key is "boy" in a table. Since this key is used various in this specific...

Hi there, I was wondering if anyone would be kind enough to help. I have a report that I receive daily and need to total month to date lots by 2 fields...

Hi, At the place where I work we have an excell workbook containing a list of employees and their duties that they are doing that day, and also the bus...