Earlier I posted the following request, asking for a formula to calculate Columns E and F: I have a spreadsheet with the following columns: Col A - Start...

I am trying to figure out how to input a character into a cell and have it repeat the complete width of the cell. In other words, it won't matter how wide the...

You could insert a column in front of your existing data and populate it with the RANK numbers. Then you can use VLOOKUP to extract the specific ranks you...

I have managed to use the PMT function to calculate the payments on a fixed rate loan, I am however stumped at how to work out the payments on one of these PCP...

thanks for your responses: Each column heading is the "named range" Col A Col B Col C Col D program type ...

Hi! The sumif function returns "0" if a cell to be added is a string value. Is there a way to return the string (or error) and not a zero? Cheers, Andreas

I have to input a great deal of data in an Excel spreedsheet One of the col is the person's phone number.It is VERY important that the number be entered as...

I need to be able to filter employee records and then count the records as a result of the filter. For example, I have 600 employees and filter them by...

How do I get excel to refresh the displayed rows when a filter is applied? Example Col1 Col2 1 2 2 2 3 2 4 2

I used template wizard to set up a database file, every time I saved an invoice, Excel 2002 will save a record in the database. The problem is that when I...

hi i want to create drop down list having options to the right of cell so that i neded not type evey option in the cells below in the column. pls tell me how...

i'm trying to link cells on different worksheets in the same workbook to that when i make a change to the cell content or format on the source document the...

I'm creating a report that flips the numerator and denominator of a formula when a 1 is typed in a designated cell. Since the results of the formula might be...

I'm trying to pull data from one sheet that exists in every third cell, and place it into another sheet in consecutive cells. Of course, once my initial...

Hi I am wanting to count the number of cells in a range that contain a value greater than X AND less than or equal to Y.

Hi, Does anyone know the macro or VBA code to disable printing. I want to prevent users from printing a worksheet. They can edit, view, but they CANNOT...

can I get the cube root of a number? All I see available is the square root.

I'm trying to set up a column that is formatted MM/DD/YY HH:MM, with each cell 1 minute apart. I thought I could format the first cell as a number after...

I am summing a row of cells to calculate return mail over a range of days. Each day's outgo number is multiplied by a different return rate (this is...

How would i write a macro or script. I have 2 lists of text and want to click on a cell in list 1 and have the text show up in the cell at the bottom of list...