I made a worksheet for a month, with bookmarks and hyperlinks. I want to make copies of the worksheet for each month. The problem is, when I copy the...

Please could someone help me with this problem? The formula in cells of column D must check 'Week Number' (column A) to see if it is blank. If it is blank...

The formula below works fine. I need replace "?" with If(A3A2), search up coulmn for first A3 match,C2, ""), Clear as mud?...

Hi, I'm looking to calculate the differnce between two numbers, Say I have 24 in a columnand next to it in the next column I have 25, I would like it to show...

I've copied/pasted numbers from a screen to excel. The data represents hours in xx.yy format. I am trying to subtract 2 cells, but get an error. I...

My Data Situation: A B 33007014220000 33007014220000 DLL 33007014220000 CND ...

I have a table with information such as Salesperson, Customer, Sales $, Year, Month, Date_Customer_Started. The data contains info for 2009 and 2010. I am...

How do I calculate cubic feet in excel? I need to be able to do it two ways. With all feet or with feet and inches. example... 2' x 4' x 3' or 2' x 4' x...

How do I calculate 6 working days from any date. e.g. 5th January 2009 is my starting date, what formula to I use to work out 6 days excluding weekend. Thank...

Can somebody advise a newbie please? I've got three IF functions that I am trying to...

Can anyone help? If I have a column of 10 digit numbers, is there a function which can identify when a number is repeated e.g. A ...

I have 3 sets of data. One set drives the other two numbers. How would I compare the other two numbers taking out the affect or leveling the affect of the...

Data is dumped into Sheet1 and on Sheet2 I need a formula to pull out certain pieces of information. Here is what the data looks like: D.......P..R S 10 ...

Hi All I have posted in programming my problem , and maybe it can be done with a formula . Please for help . Here is my the description of my problem...

Hi, I need to calculate work experience in years ,months, days. I did a formula =DATEDIF(Q18;Q19;"y")&" years "&DATEDIF(Q18;Q19;"ym")&" months...

i have 12 defined names correspond to year monthes (represented in 12 folders) in each folder i have workbook with the same name and structure but sure...

I tried to rename a sheet in a workbook but discovered that the rename option is inactive when i right-clicked on the sheet. How do i make it active ?

hi, is there a way to have a vlookup see an empty cell and rather than filling it in with a 0 it could leave it blank? here's my vlookup...

I am creating a course development spreadsheet. One sheet has a list of all of the course developers and their contact information. A second sheet lists all...

DATA (in colum A cells 1-5): 14 11 12 16 8 ISSUE: How can I automatically populate YES or NO into column B beside each data point in column A based on the...