how do i count the amount of items in a spreadsheet with a specific part number but not count them if there is an exclude character (x) in a separate column. ...

Hello, I'm new to these more complex formulas in Excel, so I thought I might get some help here please. I am looking to do the following: I am looking to...

Hello, I have in some cells some formulas that look for a value in other cells and then do their calculations. But when these cells, that are looked at, don't...

How do I navigate on a click between linked worksheets in Excel?

Hi All, I (believe) have read all the postings on counting unique entries using SUMPRODUCT. However, to my surprise,they donot workforme! My requirement/data...

Dear All, In our group, we manage people related data with a set of excel files. Normal files extract the people related information (DOB, Emp ID etc.) from 2...

Dear Experts, I am an user of excel with mediocre knowledge in functions & macros. However, here is a requriement which is driving me crazy: 1. I have a row...

when I copy from one sheet to the clipboard and then paste into another sheet, I sometimes get a change in the year of the date. The change is usually 4...

I have an invoice in excel I would like to set it up so that I can have a different invoice number created with each new invoice. How do I do this?

In Conditional fromatting, is there any way for using the OR operator to check multiple conditions. -- Anisa

Can and body help me to unlock formulas and unhide sheets that are password protected? Thanks in advance. -- Anisa

Hi All, Is there a function in Excel, wich allows you to know the value of currency at it's existing value. -- Rani

Dear L&G, Need your help. I have a work Sheet as follows A B C D E F G 1 Hours Emp No Day 1 Day 2...

Hi, I need help.. I have an excel sheet as mentioned below... C D 9 Project Project Code 10 In C10 (there is a list with all...

I have a very simple problem that is frustrating me... I have an existing column of numbers and they Format/Cells/Number/General assigned to them. Over to...

I am using 2003 and have a summary sheet in Excel that I want to use to display information from other sheets. I know how to create a link. The problem is,...

Is it possible, without code, to do a vlookup across multiple sheets? as 65536 rows isn't enough. I don't want to have to select the ranges each time though...

Not sure how to replace words to new ones in certain cells in excel

Hello Can someone explain what this function does? I have to do a support call for a customer and have never come across the Ttest function before. ...

I have a spreadsheet and in one column in says 66.5 - that's the time it takes me to run x amount of miles. I did a formula to divide that answer by 60...