I have one column with data down the first 50 rows. I need to insert 3 new rows for each of the existing rows of data. I failed an attemp using a formula...

Hi In column P I have cells which are blank , and cells which have word content. I need to replace all the blank cells with the words 'A-Z' , and leave...

I hope someone can help me. I devised a s/sheet in Excel 2007 using the COUNTIFS function. However, not all my colleagues like 2007 and have reverted back to...

Hi, Jan3-8 Jan10-15 Jan17-22 Jan24-29 Wk1 Wk2 Wk3 Wk4 Wk5 Wk6 Wk7 RcvdRL 6728 6732 7462 ...

I'm sure there is a way to do this with VLOOKUP or a similar function, I just don't know how..... I want to compare two lists of numbers. If the second list...

In the C column I have categories and in the J column I have Hours Is there a formula to where I can look up the category "Library" in C and add only those...

Apparently when you have an Excel 2007 Table anywhere in a workbook the "Custom Views" feature is disabled. Is this correct? Are there any...

I have to import hundreds of .csv files into Excel 2003 spreadsheets. The MSN MoneyCentral files in the My Data Sources file are of no use to me and are in...

This formula is working fine, except that my data is imported from MS Access and Excel seems not to recognize the correct data type. I have two data sets...

In a worksheet that I inherited, I will select a cell and it highlights it as usually. When I start to type, the cell above is then 'covered' and I cant see...

+Hi- I have set up a rank using a standard ranking formula. I have a total of 156 items that I am ranking. The values of the rank range from -660 to 756. ...

I have a range of cells that hold 4 possible entries and another range that holds 3 possible entries. Is it possible to COUNTIF/SUMPRODUCT if you for more...

I want to use a IF fuction for greater than or less than IF A1 is greater than 3000, but less than 4000, than I want C1 to be a "X" how do i do this Thanks

I entered two conditional formats into cell A1. I want the formats to apply to every cell in column A. I selected cell A1, clicked on format painter, and...

I have an IF Statement to give me a number based on sum of another cell. It looks like this: =IF($B$54000000, "0",...

I'm trying to use the same random number twice in the same cell formula: I entered "=TEXT(RANDBETWEEN(1,255),"000 ")&CHAR(RANDBETWEEN(1,255))" to display both...

I have a list of thousands of employees with a security clearance number between 1 to 20. I now need to substitute that number with a position or title. ...

How can I use as a criteria dates between a start and end dates in sumif function. I wand to sum B cells if dates in A are between 1/1/2009 and 31/3/2009.

I have a spreadsheet I am trying to build that has 3 tabs. The first are my employees and thier statistics by week. What I want is on my second tab to be...

I have been tasked with creating an inventory of all my wireless devices. I have a master started, but I get the monthly data on a spreadsheet from multiple...