Hello Friends, I want to change the duplicate as well as triplicate entries in a table having some codes with the help of some excel formula....i want to...

Hi I have 25 sheets in one workbook, and neet to copy a column from another workbook into 25 sheets in woork book budsjett.xls Have tried :...

-- Janice I need to Create a formula that calculates the employees tenure in years. In cell G7 But I'm having trouble I don't understand how to do this.

I have 3 columns A-part numbers, B-Date (year, month, date) and C-quantity. What I'm trying to figure out is how to get a Qty for Part for a month for each...

I am unskilled in Excel macros & am attempting to add a background color to all columns in a spreadsheet under the width of .8. (Ver. 2007) What I have tried...

Hello, My excel file collects information from another excel file, where I have three columns: start_time, end_time, and another cell that is suppose to...

I have 2 sheets with Item Numbers, Quantities, And Descritpions. The Description of the Item May be 1 row or Multiple rows. On a third sheet, I need to...

I AM WORKING ON CAM DATA.WHAT I WANT IS TO FIND INTERMIDIATE VALUE OF A CURVE. FOLLOWING IS MY DATA ,WHAT I NEED IS TO FINF THE VALUE SAY AT 11.3...

Spreadsheet A has the phone number in one cell formatted like: (123) 456-7890 Spreadsheet B has the phone number separated in three separate columns...

Colored fills are visible in print preview but not in normal view of the spreadsheet.

Help! I am racking my brain trying to figure out how to input a dollar figure into a cell (A1)that updates another cell (A2) with the running total (easy to...

I need to take 4 quarterly pivot tables and make a yearly pivot table because of the 65k roow limit. can this be done

Hi all, I am trying to copy a complete row of data to another sheet when it meets the criteria: Source data is in sheet: Master, cols A to AU, data from row...

Is there a way that you can keep formulas from showing 0's. I want the totals to only show when the value is 0

Is there a method for calculating a targeted IRR (an irr lookback) without using Solver? I need to know what the last period's cash flow should be to achieve a...

I have a spread sheet that emails when i press a button . I want the subject line to read information from two cells on the excell page eg cell a1 has the...

I want to set up a template that when opened in one cell will give me #1 the first time it was used, then #2 the second time. I want the numbers to be...

I have to prepare a worksheet that summarizes the latest data from about 6 columns in 180 detail worksheets. Any thoughts on how this can be done...

How can i write a function with the following criteria? IF 3 cells values are all within a given range,say -1 and 1, then "A comment", otherwise, "B...

Hey guys I have a project workbook that contains the project data for each employee and i have used the vba code so everytime u open the file the main sheet...