Microsoft Excel Worksheet Functions

Post thread
S
Using SUMIF with a drop down.
  • Steve
Replies
3
Views
696
Steve
S
N
Define a generic name
  • Nelson
Replies
3
Views
345
Dave Peterson
D
M
Lock Unlock Cell Protection
  • Mike Josephson
Replies
2
Views
504
Mike Josephson
M
T
Run a macro in active cell only. Want to place current date/time.
  • time clock watcher
Replies
1
Views
1K
Luke M
L
C
formula setting cell type to blank and conditional formatting
  • CEG_Staffer
Replies
6
Views
582
CEG_Staffer
C
K
Multiple Lookups
  • Kokomojo
Replies
5
Views
277
Shane Devenshire
S
A
formula will only recalculate when i hit the save button -
  • Andey9
Replies
2
Views
515
Shane Devenshire
S
B
Forgot Password on a sheet and tab - how do I copy and paste
  • Benjamin
Replies
2
Views
440
T. Valko
T
J
How to do a lookup using multiple values
  • jose123
Replies
4
Views
478
T. Valko
T
A
Help with large texts in excel spreadsheets
  • Anne
Replies
1
Views
400
Shane Devenshire
S
N
Copy rows based on parameters
  • npop03
Replies
2
Views
469
npop03
N
Q
How do I get cursor to move left and right in excel?
  • Q-Bear
Replies
3
Views
5K
Meebers
M
C
summing only certain numbers in calumn
  • carourke
Replies
2
Views
384
Shane Devenshire
S
I
compare cells, copy, loop
  • Immortal_Creations
Replies
2
Views
603
Bernie Deitrick
B
Y
Worksheet to Worksheet
  • Yoli
Replies
1
Views
329
Teethless mama
T
J
selecting the penultimate cell from a column of data
  • jfp
Replies
3
Views
2K
jfp
J
M
How do I add up the last 12 cells (containing values) in a column.
  • Michelle D
Replies
4
Views
633
Teethless mama
T
K
Data validation against seperate worksheet
  • Kcope8302
Replies
1
Views
507
Max
M
M
Ifs
  • myname
Replies
2
Views
420
myname
M
M
colum is not found thats missing a column B how to find it
  • meena
Replies
1
Views
397
Stefi
S
R
How to concatenate cells that meets a specific criteria in threecolumns
  • ramana
Replies
6
Views
1K
Bernd P
B
P
Merge base on same code number
  • Pran
Replies
3
Views
318
Pran
P
K
Data Verification between worksheets
  • Kcope8302
Replies
1
Views
423
Max
M
B
Omitting whole numbers when formatting decimals
  • BunnyHop
Replies
2
Views
474
Shane Devenshire
S
T
Get Cell Style
  • Thomas M.
Replies
2
Views
564
Thomas M.
T
K
Saving workspaces (.xlw) Get error message
  • KatCook
Replies
1
Views
355
Jacob Skaria
J
D
Can I format one cell so that it affects another cell?
  • David
Replies
4
Views
693
David
D
J
Conditional Formatting and cloring cells and date calculations
  • John
Replies
1
Views
544
Rajesh Mehmi
R
C
conditional format of entire row based on a single cell in row
  • CEG_Staffer
Replies
7
Views
7K
Rajesh Mehmi
R
D
--(a1:a4)
  • dcstoo
Replies
1
Views
485
Dave Peterson
D
T
How do I make worksheet into fillable form?
  • Tiana Herrera
Replies
1
Views
618
Dave Peterson
D
C
VLOOKUP with two sheets
  • C Kreig
Replies
2
Views
569
Per Jessen
P
K
Vlook-up in report with column Expansion
  • Ken Mock
Replies
5
Views
599
T. Valko
T
M
sum if with an and
  • Marlaine
Replies
2
Views
318
Per Jessen
P
T
SORTING WORKSHEET TABS
  • Tree
Replies
1
Views
296
Tree
T
R
If any cell in a range has a value, return "True"
  • raystub
Replies
1
Views
404
Lars-Åke Aspelin
L
C
Recover columns in a worksheet
  • cjennings
Replies
1
Views
376
libby
L
A
If, then, vlookup
  • akemeny
Replies
1
Views
651
Squeaky
S
J
Calculating 10 Business Days from the Last Business Day of the Mon
  • Jeff H
Replies
5
Views
814
Ron Rosenfeld
R
E
I need help creating a score sheet with weighted values. Help Plea
  • Erin
Replies
2
Views
555
Erin
E
S
Data Validation-pick from dropdown and next cell auto fills in inf
  • sunsetsweete
Replies
1
Views
653
T. Valko
T
L
SUMPRODUCT with Date Range
  • LouD
Replies
4
Views
514
LouD
L
V
Sumproduct formula not working
  • Vince
Replies
7
Views
478
Don Guillett
D
Z
Match
  • Zhead
Replies
2
Views
342
Zhead
Z
C
Conditional Formatting on several sheets of the same file
  • CEG_Staffer
Replies
2
Views
440
CEG_Staffer
C
T
Hide Columns based on a cell value
  • Tami
Replies
10
Views
796
Don Guillett
D
D
text string
  • Dinesh
Replies
2
Views
408
Jacob Skaria
J
Y
SUMIF FORMULA?
  • Yoli
Replies
1
Views
280
Jacob Skaria
J
B
Search
  • BadBoy
Replies
2
Views
484
BadBoy
B
R
savings yearly earnings ; 6.000.00 annual at 5.5%
  • rog
Replies
1
Views
416
JoeU2004
J
Back
Top