In your reply in Negative Values on the 28th you stated:- The formatting options only apply to the cells selected at the time the options are applied. If you...

Is there a way of ALWAYS getting the figures of a negative value of currency shown in read on a worksheet? If there is how do I arrange it? I tried...

I want to look up values from a closed workbook, and found my way to the free add-in 'Morefunc' via this fantastic community. However, after installing it...

I have a column of times, gathered from (Miles/MPH)/25 to yield total time it takes to travel a certain distance. All are formatted :mm and sum to equal...

Any clues for speeding things up to return the location/range of the last filled cell in a column? Function LastInRange(InputRange As Range) Dim CellCount As...

I am trying to change the format from number to text, and then back to number. I am able to make the changes to the format, but when trying to change a...

I posted this question once before but the answer didn't solve my problem. I have a spreadsheet that I pulled values from a second worksheet. I was trying to...

I was given this code from another post "How do I convert a cell(s) from the formula to it's contents?" . Private Sub Worksheet_Change(ByVal Target As...

Using Excell 2000 ... I have data being retrieved from another sheet Cell A1 of the Input Sheet, for example might contain the words "This is a TEST" Cell A1...

I have named a range of cells based on the top row in each column. S1:CR20. Some names need signs like"/" and "-" and """, etc. This doesen work with...

Hi Can I use SUMPRODUCT to lookup two criteria text values in sheet1, cell A2:A100 and B2:B100 and return the text from C2:C100? The formula will be in...

My data in B2:B1000 contains text and numbers. In D2:D1000 I need to return the findings of a search in B2. Eksample: The text in B2 is "Add FCM#6". I want...

Is ther a way to force the Auto Complete to reference another sheet? What i want to do is have sheet 1, row 1 referece sheet 2, row 1 for the auto complete...

Im trying to work out a time sheet for work and the problem is that i work with 24 hr clock and shifts can start at any time over that period and finish...

I have an EXCEL file (named 'Master') with 2 worksheets. On each of these worksheets I have formulae which links with data on 2 different EXCEL files (named...

I have an EXCEL file (call this "Database") that in a simplified form looks like this (Col. & Row Headings shown):- A B C D E F G 1 Day Loc. 1 Loc. 2 Loc....

Hello, Can somebody help me? I am working on my excel file & need to open this file in a new window without using the mode. The thing is I need to look...

2007 ä¸*的工具列é*…ä¸*: 資料--資料工具--å�‡è¨*ç‹€æ³�分æž�--資料表, è«‹å•�這功能我如何在2003版ä¸*找到???

I am looking for a function or group of functions that can help me count the unique entries that meet two other criteria. The table is similar to: Column A: ...

I'm trying to calculate the number of weeks cover an inventory value represents. My worksheet is laid out as follows: Each Row represents a week Col A ...