I have a client that needs help and I know the sumif function would work here, but I must be doing something wrong. She has one column with a letter from A to...

Hi I'm trying to use the network days function to calculate how many days there are between today() and a list of project deadlines. The function i'm using is...

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. ...

Hi, I have a sheet ("January") in which some cells are colored with particular color, i would like to know if exists a method how to detect these...

Is there a way to program all empty cells in a column to be filled with text copied from the cell above each empty cell?

I have pulled information from another application into an Excel spreadsheet. The date column is in a format that I don't like & I would like to change it, but...

Is vlookup able to find the file refering to column's header? I need to get data to column B. Formula below shows that source file has the same name as column...

I have imported data from an FMPro Database which is already in Title Case into Excel. When it imported, it became Upper case. since this data is to be used...

Is there a way to copy conditional formatting to other cells, just like copy formula? Right now, I have to do it manually for each cell. Thanks.

I am unable to insert, move or copy worksheet. The options are not highlighted for me to use them. Can anyone help? I will be most gratefull.

I am drawing 120 randomly ordered rows of data from a summary worksheet to separate worksheets. The data consists of a Name, a Category, and a number, e.g.,...

Hi, I'm running a helper column, AI, with this formula: =IF(COUNTIF($A$3:$A$1341,A3)1,"Duplicate","") Both rows with duplicate information are flagged in AI...

Hello, I want more details regarding EI_CALC function, I couldn't find in HELP. Thanks, Patricia

I want to create a drop down menu in excel and have no idea how to do this - can someone help?

I have a list of concatenated arguments that are two characters in length for each argument. How can I display only 26 characters of that output into another...

I am trying to find data between a beginning date and an end date that the user can change. An example is looking for returns between January of 1980 through...

I am modifying a spsh with the data entry function =FORMULA(INPUT("Enter the RCS Pressure (psia)",1,,,,,),DELTSTWS.XLS!$F$128) I cannot find a description of...

I've got a spreadsheet containing tracking information for a number of projects. Each row in the spreadsheet contains the following kinds...

I have values in cells a1 and b1 however a1 or b1 can be blank. The formula in c1 should add the values of a1 and b1 only if there is a value in a1 and b1...