Microsoft Excel Worksheet Functions

Post thread
G
count if for more than one criteria
  • Gerardo
Replies
5
Views
430
Roger Govier
R
P
Sumproduct gives #VALUE
  • Phil_S
Replies
3
Views
497
Don Guillett
D
A
in ms excel how to count the no of cells
  • anji
Replies
3
Views
241
Dana DeLouis
D
K
Summing values, x rows deep, depending on a criterion
  • klm
Replies
2
Views
495
klm
K
M
password protect certain cells change
  • Miree
Replies
1
Views
291
Otto Moehrbach
O
S
Login Name and now function
  • saran
Replies
3
Views
335
saran
S
C
Database price updating
  • chefdoug
Replies
3
Views
559
Max
M
R
Counting number of cells that match name AND number
  • Ronster
Replies
4
Views
493
Mike H
M
A
How do I use the excel function "funformula"?
  • Ade
Replies
1
Views
215
Héctor Miguel
H
E
Macro Button or Auto Protect Formula
  • enna49
Replies
3
Views
472
enna49
E
S
ColorIndexOfOneCell
  • shank
Replies
8
Views
2K
shank
S
S
help with formula
  • so confused
Replies
3
Views
310
Mike H
M
A
Average for times using minutes and seconds
  • aj81a
Replies
2
Views
529
Sasa Stankovic
S
S
How to copy cells from one worksheet to another if the value in ra
  • sgtpsychosis
Replies
4
Views
428
Otto Moehrbach
O
L
Word size for each cell
  • Lookup formula limitation?
Replies
1
Views
297
Sasa Stankovic
S
N
Multiple question requiring asistance please
  • NoodNutt
Replies
2
Views
449
JLatham
J
V
Advanced Filter how to include columns
  • V
Replies
1
Views
425
Debra Dalgleish
D
B
Count occurrents based on criteria in different column
  • Blueagm
Replies
1
Views
450
T. Valko
T
M
Conditional formatting & decimal part of a number in cell
  • Mac
Replies
2
Views
727
Mac
M
R
tabs are missing even though 'tools-options-view-sheet tabs' ok?
  • rgranell
Replies
3
Views
906
Gord Dibben
G
M
Summarising Data
  • Murray
Replies
5
Views
470
Mike H
M
E
Sort Worksheets (without VB)
  • Elgee
Replies
4
Views
289
Don Guillett
D
A
change data of entire column from small case to upper case
  • Ann
Replies
1
Views
584
Dave Peterson
D
D
Take a 3 or for digit time and convet it to time in one cell
  • Djbaker70
Replies
8
Views
442
Héctor Miguel
H
M
Sort by color: Is there an easy way to sort columns or rows in EX
  • MGP
Replies
5
Views
725
Bob Phillips
B
J
countif on cells with formula's won't work correctly
  • JusMe
2
Replies
21
Views
2K
JusMe
J
D
Converting Millitary Time to Hours worked and OT hours
  • Djbaker70
Replies
3
Views
769
Peo Sjoblom
P
D
Making a cell change time to hours
  • Djbaker70
Replies
2
Views
308
Héctor Miguel
H
K
Use the custom filter dialog in a macro
  • KenInPortland
Replies
3
Views
487
Héctor Miguel
H
M
Visual Basic Erro 400
  • Minitman
Replies
2
Views
414
Minitman
M
T
How to schedule an auto "Save As" of an Excel spreadsheet daily...
  • Turbine Mechanic
Replies
2
Views
2K
NoodNutt
N
J
Changing text colors for editing
  • Jalynno
Replies
1
Views
354
Gord Dibben
G
L
COUNTIF a cell value is between two numbers
  • LAWNDALE
Replies
3
Views
1K
T. Valko
T
P
EXCEL CELL MERGE
  • Patricia
Replies
3
Views
329
Patricia
P
G
SUMPRODUCT formula compare then count
  • Greg in CO
Replies
3
Views
1K
Greg in CO
G
T
Eliminating Values from a worksheet
  • Terry
Replies
4
Views
426
pshepard
P
P
How to reference or redirect a formula in a base row?
  • Paul Schrum
Replies
3
Views
719
pshepard
P
D
today functions
  • diggs
Replies
4
Views
335
Gord Dibben
G
J
SEARCH and IF
  • Jorge
Replies
3
Views
265
T. Valko
T
L
"COUNT IF BELONGS" formula?
  • lorenzo
Replies
10
Views
535
Roger Govier
R
B
help with adding up hours and mins please
  • baz
Replies
3
Views
1K
T. Valko
T
A
Use of IF with arrays
  • Andrew L
Replies
5
Views
402
T. Valko
T
J
Assigning times to shift
  • Jon M
Replies
5
Views
460
Jon M
J
F
Data trapping
  • Flipper
Replies
5
Views
669
Glenn
G
G
Data pick-up 02
  • Geoffric
Replies
3
Views
447
Teethless mama
T
R
Using Vlookup where the Lookup Value also uses Vlookup
  • reddy
Replies
6
Views
820
reddy
R
F
Is this weird or what?
  • Finance Guru
Replies
8
Views
385
Jarek Kujawa
J
D
vlookup with offset?
  • d0711
Replies
5
Views
475
Jarek Kujawa
J
F
More conditional formatting...
  • FIRE GIRL
Replies
2
Views
269
FIRE GIRL
F
S
plus-minus buttons in far left column (1)
  • Steve
Replies
3
Views
527
Steve
S
Back
Top