|
|
if statement with or by
tinman[_3_]
Hello,
Could someone help me understand why it doesn't like "If cUser =
"XJOHN" Or "YPAUL" Then" in the macro below? Thanks.
Sub UnprotectAllSheets()
Dim...
|
|
1 |
97 |
|
|
Vlookup by
HS
Is it possible to do a vlookup and when the corresponding cell is empty that
it display nothing rather than a 0?
=VLOOKUP(B3,Data!A1:L1602,12,FALSE)
thank...
|
|
3 |
97 |
|
|
Area Test Figures by
Steve[_73_]
Hi Don,
As promised latest test figures by area these include David's latest tests.
--
Steve
|
|
0 |
97 |
|
|
Id instead of names...? by
excel, name, ids, relation
hellow i relly dont know too much about excel... and they ask me to do this:
i have 1 column with ID of employees, like: E01,E02,E03. and each id, has a
name...
|
|
2 |
97 |
|
|
add info to column by
jj348206
I have a list of over 1000 names in my a column but need to add @gmail.com to
the end of all of them. How can i do that in excel?
|
|
6 |
97 |
|
|
|
December 1st, 2009 01:10 PM
by MMattyK
|
0 |
97 |
|
|
Number displays by
TD8953
How do I display a number in thousands or millions without rounding the
number? For example, I would like to see 52,569,832 displayed as 52,569.
|
|
2 |
96 |
|
|
Date Fields by
Metalteck
I have a spreadsheet that has 4 columns.
H=Month, ex 4
J=Day , ex 1
K=Year, ex 5
L=Century, ex 20
How can I gather all of these fields so that it can look...
|
|
2 |
96 |
|
|
Data Query by
vb-i-m-lacking
I would like to create a query. .. ie. NFL sched for 2005. on the 1st sheet
that pulls individual team info from the 2nd sheet. So I will input a team,
and...
|
|
0 |
96 |
|
|
Using For - Next Loops in VB by
Biomed
Excel 2000 SR-1
I am trying to write a VB code using a For - Next statement to calcualate
cells.
The basic satement is:
For X = 1 to 7
= {Calcualtion} '...
|
|
1 |
96 |
|
|
filling a cell by
Terry
I have a worksheet that I use to keep track of my time
spent on projects. right now I just enter the time in
manually and have formulas to add up the time. I...
|
February 15th, 2005 09:16 PM
by Terry
|
2 |
96 |
|
|
excel user data by
Jnewsome
Is there a file that holds user data such as page break
locations that could be transferred to a new machine?
|
|
2 |
96 |
|
|
|
August 29th, 2004 03:11 PM
by Paul B
|
1 |
96 |
|
|
|
|
1 |
96 |
|
|
Formula ! need help. by
F3ct
Hi,
How to express the following formula in Excel format;
Formula 1 , ((A3+B3)/2)(B30/365)
Formula 2 , ((A5+B5)/2)/(B31(365))
I did try but not success.
|
November 6th, 2004 01:11 AM
by F3ct
|
3 |
96 |
|
|
|
|
2 |
96 |
|
|
|
|
1 |
96 |
|
|
how to create a psuedo hash in excel by
nlscb
I have 4 columns of data
first column is a list of US cities
second columns is the change in population from 1990 to 2000 for the
cities
in the first...
|
January 20th, 2005 03:07 AM
by nlscb
|
0 |
96 |
|
|
|
February 13th, 2005 12:13 PM
by Ragdyer
|
1 |
96 |
|
|
|
|
4 |
96 |