Good day. I am using Excel 2002 with Windows ME. I have a worksheet that I use to produce order sheets for products that I sell. On the worksheet there is...

Hi, In my active worksheet, I am using the following formula in cell A10 =IF('Adjustments'!A10="","",'Adjustments'!A10) If there is data in cell A10 of the...

I need to generate a random list of the whole numbers 1-52 with no duplicates and no decimal places.

I need to add the following to my present macro if possible. In column Q, which often contains a sentence or two of text, sometimes nothing, I need to add the...

Anyone know (have) a function or macro to relocate entire arrays from rows to columns? I have a set of calculations that are just easier for me to deal...

I've searched on MSFT's Knowledge Base for references on how to Start/Stop the RTD links from continuously populating, but except for the Manual calculation...

Hi All Can anyone help please. I have a team of 8 manager's monthly results on a spreadsheet for which I am trying to set up a league table . Their...

I'm trying to do something simple, or at least I thougth I was. If I have the word BLAH in cell C20 and then in cell D20 I have the formula...

As an example, in cell A1 - I have text of someone's name (assume name of "John") in cell A2 I have a number (assume number = 1). In cell B2, I have created a...

I would like to look in the range of c4:c216 for the occurrence of the word "No" which appears as the first two characters as part of a longer sentence in any...

Hi, I have 2 columns of data i'm working with. column 1 is dec.04 dates, column 2 are jan,feb,mar.05 dates. i had to identify which names in the dec.04...

How can I make cells change to red according to a criteria ina IF function ? What is the syntax IF(b3, than make it red, if not leave black) Also I want to...

Hi, I'm using MS Excel 97. How do I sort columns in alphabetical order, and keep the rows together? Right now, the way I'm doing this is to move the column...

I have a spreadsheet like this: Name Total week1 week2 week3 week4 week5 etc Site A 5 5 Site B 10 ...

how do i make a template for value premium market and assumed values thank you.

I have created a macro that sends a file via email. Within the macro, i have it copy into a new workbook, then save the file, then email the file. Can you...

The below formula when viewed in 'Formula Auditor' refers to '(L4)' as a 'constant'. How do I get it to recognize it as a 'valid reference'. I am trying to...

Is there a way to convert the data returned from a formula to text and remove the formula? For example, I have a cell containing this formula: =IF('Current...

Hi everyone, Can anyone help wit hthe following please? I have a cashflow where the first expressed in years where the first few years are negative (aloss)...

Here's my example: column a will be materials, column b will be total quantity available for the project, and then columns c-z will be a date, and the amount...