|
|
How do i find a sequence by
LiAD
Sorry I have already asked this but the answer has been lost somewhere, or i
can't find it now.
I have a list of data which i want to match the words then...
( 1 2 3)
|
August 26th, 2008 05:31 PM
by LiAD
|
20 |
424 |
|
|
|
|
0 |
79 |
|
|
Counting cells with multiple criteria by
Charlie510
I'm trying to count the number of cells that meet criteria in multiple columns:
Column AI contains a job number
Column AJ contains "blank", "0", or...
|
|
3 |
134 |
|
|
SUMPRODUCT Function Compare Date by
Raj
I have two sheets in a workbook that have the following columns
Sheet1
Col1 Col2
01/01/2008
01/03/2008
02/09/2008
Sheet2
Col1 ...
|
|
3 |
74 |
|
|
|
|
3 |
87 |
|
|
|
|
1 |
101 |
|
|
Help with IF function by
Michelle
Am trying to create a formula that will tell me: if the range of cells has
the single letter "R" or the single letter "T" in the individuals cells, it
will...
( 1 2)
|
|
13 |
133 |
|
|
Rest of the Year Calculation by
Gfunc
HI,
I am trying to make a cormula that calculates what someone would be on time
to achieve, based on their current number and then project what they would...
|
|
5 |
66 |
|
|
Dealing with column headers by
Pawan
Hi...
I am learning about writing macros. I always stuck up at one point.
I need to do various activies on columns based on their headings. e.g. I
have to...
|
August 26th, 2008 02:44 PM
by Pawan
|
2 |
88 |
|
|
Restricted Access by
SB
I have a large workbook with several different woksheets in it.
Each worksheet refers to a different individual. Is there a way that I can
set up this...
|
|
1 |
107 |
|
|
|
|
6 |
141 |
|
|
Vlookup question by
Daniel
Hi. i have a workbook with multiple worksheets and some of them contain
matching data. say, i have worksheet A where i have numbers in column 1, and
i have...
|
August 26th, 2008 01:50 PM
by Daniel
|
9 |
73 |
|
|
Using the IF Command by
Eugene
How do I set up my worksheet to use the IF Command.
I have Columns C D E G in a Row
C can only have a value of 1 to 5. If this value is filled...
|
August 26th, 2008 01:25 PM
by EddS
|
2 |
64 |
|
|
Un protect sheet by
venumadhav g[_2_]
Hi ,
I have given pwd protection to my worksheet and now i forgot the pwd of the
worksheet. Kindly tell me "how to Break the Password of a protechted...
|
|
2 |
100 |
|
|
|
August 26th, 2008 01:21 PM
by Pete_UK
|
3 |
65 |
|
|
|
|
2 |
111 |
|
|
How do I use lookup for this case ? by
Serhat Cengen
I have an excel file with 5 different sheets. I want to check sheets 1..4
against there is a match for my data in sheet 5. How do I do this ? What
happens if...
|
August 26th, 2008 01:17 PM
by Pete_UK
|
1 |
101 |
|
|
Percentage and copying formula by
teo410
I have made the following formula in a spreadsheet im working on to find the
amount of packs in a delivery as a percentage ((J48/SUM($J$48:$J$50)*100)
and...
|
August 26th, 2008 12:39 PM
by teo410
|
2 |
79 |
|
|
Using values from macro to userform by
Pawan
Hi..
I have created a macro. One variable is defined there as:
dim var1_d as integer
var1_d=200
Then on the userform, I have a textbox (var1) and a checkbox...
|
August 26th, 2008 11:58 AM
by Pawan
|
2 |
89 |
|
|
|
|
4 |
130 |