Hi, I am trying to dynamically create the range statement in Countif formula but for some reason it doesn't work. At present I am hard coding the information...

I've been trying for the last several hours to get this right. Here's the logic I'm trying for: 1. If Column D is earlier than of equal to 7/1/2003, and...

I have two columns of data, HOUR AND MINS. I WILL LIKE TO ABOUT TO CONVERT THE MINS TO HOURS. THIS FUNCTION IS NOT GIVING ME THE EXACT...

Hello everyone, i have a macro that imports a text file and i have to manually run the wizard to select my columns. The text imports 5 columns and i have...

Hi Mat, Is this any good? =VLOOKUP(B2,{1,0.19;2,0.17;3,0.15;4,0.13;5,0.11;6,0.09;7,0.07;8,0.05;9,0.03; 10,0.01},2,FALSE)*A2 -- HTH

I downloaded a self-extracting file that is a text file with carat delimiters. I want to convert to an Excel 97 file without the delimiters.

I'm making a record sheet of sorts in excel to keep track of truck repairs and maint. Each line (row) will contain a CATEGORY and the AMOUNT of the repair...

IM SWICHING TO EXCEL 2002 FROM 2000 AND CANT SEEM TO FIND THE INVOICE FUNCTION UNDER TOOLBAR TO BRING UP THE BOX FOR AUTOMATIC NUMBERING OF THE INVOICE NO. ARE...

I have a real problem, I've got a bunch of links I've got to create between workbooks. Neither are protected (I removed all protection) there is no VB code...

When I do a search, the "Column Headers" appear in the search results, but not as column headers, they get mixed in, and included in the "alpha" sort. How do...

Hi Rudy Add two dummy sheets(empty sheets)with the name start as the first sheet and one with the name end as the last sheet of your workbook. this are empty...

Hi guys, This is probably a really silly question. But, is it possible to embed some kind of control that allows you to click on a cell or command button and...

I know I've seen this, but the brain is totally locked. First column data is area inspected, 2nd column is date of last inspection. Need to know date of last...

is there any way to insert a cell's value into a hyperlink. for example, i want to be able to place the cells value into a web search without inserting...

what is the funtion to post a letter grade corresponding with the percentage you receive

I am trying to find a formula to count the number of rows that have BOTH a "4" in column C AND a "ph" in column H My info shows...

Most yield to call or yield to maturity bond calculators do not work for preferred shares where the call price is usually $25.00 per share. These instruments...

Hi. In SUMPRODUCT, is there a way to specify the arrays to cover non-sequential cells? For instance, I want to use sumproduct by specifying the following...

Hi Guys & Gals: My problem is to obtain an average from selected row-cells that are separated (non-contiguous). For example: A D F H K 2 3 ...

Have you tried hitting the HOME key. Bernard PS why are your shouting at us? "ksnocturnal" wrote in...