Hi All, Merry Christmas to all these wonderfull people who support everyone for free. And of course to all of us who need them. Merry Christmas, JP

We have a material code list in one column.many code has repeat. We want only one code come only one times.please help Material...

I've seen some workarounds for doing Smith, John to John Smith But I am looking for

i need a formaula that adds every third column i.e. formula in cell A1 adds D1,G1 ect ect can some one help with this?

I am using the COUNTIF function as follows. =COUNTIF(Data!AN2:AN533,LOV!A2) It works for the most part, however, the fields I am looking up (Data!AN2:AN533)...

In one workbook, I have 4 sheets of data and one reference table. The data tables have: A B C 123 47 Text 123 47 Text 456 55 Text 455 66 Text 888 07...

Is it possible to set the margins for the first page of my worksheet differently from the second page of my worksheet?

I want to sort a range of protected (locked) cells. When I set the protection for the cells I clicked on the Sort option, but my cells still will not sort....

Im trying to create a report using multiple IF criteria. My formula is working however how can i get the field to be blank if it doesnt meet the criteria?...

I need a function that will return all information for "truck 1" on another worksheet. The information below is an example of information on my worksheet. I...

How do I create a function that adds up certain numbers in one column that all have a certain value in another column. For example: column A Column...

I have a table of dates that looks like this: FY2010.Q1 FY2010.Q2 FY2010.Q3 FY2010.Q4 FY2010TOTAL 2009.Sep.30 2009.Dec.22 ...

My brain's on overload at the moment, so I'm turning to you guys for help. I need help w/ a formula that will count the number of sales that someone had based...

I'm looking for a solution for an item search box for an inventory. I have a spreadsheet that I need to find "Name of product" and scroll it up to the bottom...

Dear Sir, I am using MS office 2007, and want to know what is command/formula to count the number of worksheets in a Excel. I deals with some taxation matter...

col A the city were the employee located, col B the emploee #1234 Col C the employeee name OK simple vlookup right, well on sheet 2 the data is...

How do you get data from 2 differant columns to be in 1 other column. I have a column First Name and a Column Last name I want Column Full Name to...

I have a worksheet containing a User Type column and a Date/Time column. The User Type is a code between 0 and 9. The Date/Time is formatted as mm-dd-yyyy...

This is a DVD database that uses vlookups and advanced filters to achieve a database implementation that is faster than doing it in a real database. It...