I have a 1000+ list and i want to enter a blank row after each entry that does not equal the prior one. The repeated entries are not evenly spaced. Can a...

want to setup formula using networkdays through which end date which is 30 workingdays from start date can be calculated.

Hi all, I have a simple table with two columns: -What was agreed (2 digit code eg. FV, PC, PE...) -Was it acheived (Y/N) This is a daily log over a 5 day...

in one column i have names and in other column i have values. each same name can have lot of values so in column A all the names are written , (one name can...

Hello, Is there a way by which I can make the contents of a comment box dynamic, i.e. based on the contents of one or more cells in the spreadsheet? My...

Why doesn't this formula work!?! =LOOKUP(LEFT(A1,1),NUMS,LETS) Column A contains numbers with multiple digits. NUMS is a list of single digit numbers...

I have to save my excel sheet as a CSV, but the numbers I am using are 15 digits long and need to be kept that way. Every time I re-open the document 15...

How do I enter same formula in the same cell on multiple sheets?

I want to write a macro to sort uppper and lower bounds form a sries of data (numerical).

Excel 2003 - hope this is the right group to ask. I am trying to find a formula for a time sheet for employees. I will try to show an example: Col A (job...

Hi, This is my spreadsheet. Column C has the LOOKUP formula. A B C 53 a a LOOKUP(A2,$A$2:$A$14,$B$2:$B$14) 447 b b LOOKUP(A3,$A$2:$A$14,$B$2:$B$14) 1...

I have long database of our dealer network and I like to grade them. The methodology I like to use is to create a normal distrubition curve and eliminate the...

in a spreadsheet done by x coleague she had a formula in cell as =+D101. D101 is a sum of D60 to D100 cells in the column, which needs to be shown in...

I am trying to find an easy way to take a full spreadsheet and using different sheets write a formula to take certain inflormation into a new sheet a re sort...

I am creating a part numbering system using drop down boxes. Drop down box 1 consists of main categories. Drop down box 2 is for sub categories of drop box...

I had posted this same question. I did not get a good answer. But now I have simplified my own question. Hope this will help. I need a formula that deletes...

I downloaded a huge file in to excel. I selectively need to delete some entries which in this case are all in "rows" NOT columns. Is there a formula to do...

I have a spreadsheet with the following characters - some columns are inaccessible for input, some cells are protected, there is a section of the spreadsheet...

Here is my problem. In column A I have numbers with different colors. The colors have meanings. They represent a team. On column B, some of these numbers have...

I have 4 "if" scenarios for which I am looking a formula. It is just a basic scenario where I have 4 choices and I need this formula to read the four options...