|
|
COUNT CONSECUTIVE ENTRIES IN COLUMNS by
micoz
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...
|
|
1 |
103 |
|
|
|
|
2 |
163 |
|
|
|
|
4 |
123 |
|
|
Count if 2 criteria are met by
clare_s
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...
|
|
1 |
96 |
|
|
Set print area by
falcios
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...
|
|
1 |
91 |
|
|
Sorting cells with a string formulas by
Erik
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...
|
|
1 |
101 |
|
|
VLookUp Question by
Annie
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...
|
|
1 |
132 |
|
|
|
February 6th, 2010 10:32 PM
by KB
|
0 |
150 |
|
|
Code in certain sheets by
MAX
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...
|
|
1 |
98 |
|
|
|
February 6th, 2010 08:33 PM
by Kevin
|
12 |
233 |
|
|
selecting data in a row by
darkblue
Dim rng As Range
With Worksheets("Data")
Set rng = .Range("a2", .Range("a" & Rows.count).End(xlUp))
End With
rng.Select
--------------------
With above...
|
|
4 |
86 |
|
|
|
|
2 |
92 |
|
|
need a search/find/lookup function by
Jenn
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...
|
|
4 |
106 |
|
|
|
|
3 |
92 |
|
|
|
|
3 |
157 |
|
|
lookup and match by
genietrapped
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...
|
February 6th, 2010 02:39 AM
by John
|
2 |
130 |
|
|
Link cells with text not numbers by
--Viewpoint
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...
|
|
4 |
132 |
|
|
Sorting Alphabetically by
Vicki
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...
|
|
3 |
155 |
|
|
Calculations in filtered columns by
Dianeg
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...
|
|
4 |
89 |
|
|
Sumif with an array for criteria by
Chris
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...
|
|
3 |
113 |