i have a column that returns "UP", "DOWN" OR "FLAT" BASED ON ANOTHER FORMULA. MY QUESTION IS, I WOULD LIKE TO START ANOTHER COLUMN THAT KEEPS A RUNNING TOTAL...

Hello, I have data from two groups interleaved in the same column. For the sake of simplicity, let's imagine group A: rows 1-3,7-9; group B: rows 4-6,10-12....

I have a workbook that I created for tst item analysis. On the main worksheet is used to enter sudent's response for every multiple-choice question. on...

Hi- need to get a formula which will count the number of times 2 seperate criteria are met- firstly that in column G the entry is Alicia, and secondly that...

Excel 2002 Is there a way in which Excel can set the print area by selecting all the cells that have contents? Is there any key/toolbar functions that sets...

In trying to split addresses which contain both number and street in one cell, I have extracted using these formulas: =REPLACE(B5,1,FIND(" ",B5,1)-1,"") and...

Hi is there any quick way of knowing what columns hold what information while doing a vlookup - I mean the index number? For example, in a small array of...

My worksheet area I need to sort consists of columns A thru W, and rows 7 to 30..... The challenge is this: rows 7,8,9,10 & columns A-W holds one set of...

Hello I have a file with 33 sheets and a VB code (below) in "This Workbook". The problem is that I don't want the first and last sheets obey this code. How...

Hi, I got a shortcut link of master workbook and I"m trying to find the location of shortcut linked file. E.G. 1) C:/master file.xls 2) C:/MyFolder/shortcut...

Dim rng As Range With Worksheets("Data") Set rng = .Range("a2", .Range("a" & Rows.count).End(xlUp)) End With rng.Select -------------------- With above...

Hello, First I just want to thank you for help in adavace. Well the issue that I'm having in trying to add up the amount time I have listed in cells L6:L50...

I need a function to determine if value "A" exists in range B1:B10. If A exists in B1:B10, return "C". If A doesn't exist in B1:B10, return "D." I have tried...

How do I circle a number on a form created in excel?

I have 2 worksheets. I have a main list that contains 1260 product codes and I need to lookup and match product codes from the second list. The main list...

I'm working with a worksheet of cells with general information (text) that I linked to various cells on worksheets within a workbook. I created the formula...

I would like to sort a column alphabetically and make sure that the info in the other columns stay with the sorted column. I realize that I must select all...

Is there any way to perform an advanced filter on columns with calculations in them and copy the data with calculations to another location.? It copies the...

Hello, I am trying to write a sum if array formula that will look up against multiple criteria and then finally compare to an array...here is an example of...