Hi: I have data in the following format: \\192.100.1.94\documents and settings\user\my documents\file.pst I want to extract the IP address from this...

Hi there. I have a cell that contains one long sumproduct formula. It is basically combining 3 results into 1 cell with a "/" separating them. This formula...

It's awkward for me to use "A, B, ...CW..." as column names, when large matrices of data are processed. I couldn't find a way to change the column name...

We work in a 24/7 environment. I calculate production for a seven days schedule but, we do close for holidays. Networkdays, by default, excludes weekends when...

okay I have a VERY SIMPLE spreadsheet that is used to create shipping labels I need to be able to have a cell formatted so that it reads like this... p (in...

Hi, Can anyone suggest the answer to a simple problem, I want excel to calculate a nett date on an invoice. If I put a date in for example 16/12/2005 I want...

I am not familiar with the SUMPRODUCT function. I asked someone to do some work for me on a spreadsheet and he added the following expression to a...

Hi All, I have a Row of numeric data ( in individual columns) that I would like returned to individual cells in a single column. My data starts in Column C...

I want to perform an sumproduct type of function with on column of data (1 x n) and the minimum value in each row of a 2 x n matrix. Is there a simple formula...

How do I write the following to show a blank in the cell, it is currently returning a zer because the cell it is pulling from has a 0 value. =IF('Rep & Store...

D7=Start Date F7=End Date B13:B31 Data Dates C13:C31 Data I need a formula that will count the number of entries in range C13:C31 that are between the dates...

Looking for a way to make the cells in column B based on the contents of cells in colum A (text string) show as below please? Column A ...

I have a huge worksheet, consisting of codes in Column A, a product name in Column B and a cost price of the item in Column C. Each product some times appears...

I think I'm losing my...

I have a formula that looks as follows: =VLOOKUP(A70,'Staffing Assumptions'!$A$64:$D$75,4,FALSE) There are some values in Column A that are not in the Table...

Hi everyone, is it possible to insert a picture/image into a cell using formulas alone, i don't want to use macros. For example: If cell 'a1' contains the...

I am trying to extract data from a spreadsheet using a search function that has two search criteria. For example, I have a worksheet filled with employee...

I am using sumproduct to count a total number of cases. The formula I have been using is: =SUMPRODUCT((report!$Y$4:$Y$40060)*(report!$Y$4:$Y$400-60)) I...

when using vlookup referencing a value between 71% to 79% in a chart using roundup function will not work properly.

:confused: I'm working on a simple Excel doc that is used to take readings on power usage three times a day for every day of the month. The month and year is...