Microsoft Excel Worksheet Functions

Post thread
M
Copying and pasting with SUMIF and COUNTIF
  • mwdawg721
Replies
3
Views
999
Gord Dibben
G
S
Newbie needs help with chart
  • stryped
Replies
2
Views
362
John
J
J
count how many staff are scheduled between...
  • jatman
Replies
3
Views
687
aminh
A
S
Sum if not blank
  • SKSmith
Replies
2
Views
1K
Glenn
G
G
If Function with multiple criteria
  • GPearson
Replies
2
Views
468
Luke M
L
E
Index Match Error
  • EZ
Replies
1
Views
477
EZ
E
C
Can I put button on spreadsheet to make it print a specific part?
  • CindyMc
Replies
2
Views
599
JCS
J
E
Count text occurences in range when criteria in other column is me
  • eliyahuz
Replies
3
Views
572
Jacob Skaria
J
L
Conditional Formatting
  • Lynne
Replies
2
Views
331
Pete_UK
P
A
Referencing a cell in the worksheet as the criteria for a formula
  • Alagra
Replies
4
Views
545
Alagra
A
E
Count occurences of text in range only when Yes appears in other c
  • eliyahuz
Replies
9
Views
629
Pete_UK
P
T
Counting Unique occurences of text in a column
  • Tan
Replies
12
Views
771
T. Valko
T
C
csv delimeter
  • csv delimeter
Replies
3
Views
454
Gord Dibben
G
F
Ranking Sales Reps
  • Frustrated
Replies
2
Views
557
ryguy7272
R
R
IF Function formula (I think?)
  • Rocktaxi
Replies
4
Views
537
Rocktaxi
R
D
Conditional Formatting based on values from other sheet
  • Dmox
Replies
3
Views
505
Dmox
D
J
IF to group months
  • John McDonnell
Replies
3
Views
395
Ashish Mathur
A
C
FAO Mike
  • Caroline
Replies
9
Views
595
Glenn
G
P
? enter a static time (Excel) in a cell using the IF function
  • pmcfs111
Replies
2
Views
2K
Dave Peterson
D
E
help formula (ranking)
  • Eddy Stan
Replies
1
Views
434
JLatham
J
B
More columne sorting
  • BEOPS
Replies
4
Views
445
David Biddulph
D
H
Look up last and next entry
  • Huggy
Replies
7
Views
569
Huggy
H
E
sumif using "AND" and "Date"
  • Excel_Kiwi
Replies
2
Views
407
Jacob Skaria
J
N
Formula have a VLOOKUP but want it to =0 if no value is found
  • Nicole
Replies
3
Views
465
T. Valko
T
A
Formula for payout & interest
  • Atreyu
Replies
3
Views
573
JoeU2004
J
K
User Defined Function and VLookUP
  • Kevin
Replies
11
Views
851
Kevin
K
P
Match value return a text
  • ppp
Replies
6
Views
524
Jacob Skaria
J
A
Allocate Value Across Monthly Periods
  • AlanR
Replies
1
Views
665
Jacob Skaria
J
J
Match Column and copy to cell Column D
  • Jeffrey Yau
Replies
1
Views
419
Ashish Mathur
A
C
nper
  • cdh625
Replies
1
Views
451
Ron Rosenfeld
R
T
custom created table styles
  • TinaW
Replies
3
Views
1K
Gord Dibben
G
K
Workday function returns the wrong date when the duration is 5 day
  • KarenMA
Replies
4
Views
6K
Ron Rosenfeld
R
C
Split list query for Vlookups
  • CellShocked
Replies
1
Views
377
BSc Chem Eng Rick
B
H
WildCards in Sumif Function
  • Hardeep Kanwar
Replies
2
Views
704
Bob Phillips
B
D
Sum formula when cell cantains alphabets too
  • d3graph
Replies
0
Views
533
d3graph
D
C
Numbering years and months
  • Colin Hayes
Replies
4
Views
638
Colin Hayes
C
B
Colors too dark!
  • BiT212
Replies
1
Views
461
JLatham
J
K
Local Apparent Time (LAT) - real / actual solar time ?
  • Kelvin
Replies
1
Views
5K
ryguy7272
R
C
External data connections
  • CellShocked
Replies
1
Views
484
CellShocked
C
L
SUMIFs function
  • lefty
Replies
2
Views
546
Gord Dibben
G
L
display number if date is in a range
  • lmarty
Replies
4
Views
435
Rick Rothstein
R
B
Using wildcard * in MATCH
  • berniean
Replies
6
Views
768
Max
M
T
how do i use IF to substitute for another cell?
  • Tim
Replies
1
Views
391
Gord Dibben
G
N
using sort in excel 2003
  • naj
Replies
2
Views
360
Gord Dibben
G
W
Copying formulas from one cell to another
  • Woodie6
Replies
7
Views
1K
Gord Dibben
G
L
SUMIFS function
  • lefty
Replies
4
Views
832
Teethless mama
T
S
I have a column of 50 numbers
  • Skip
Replies
5
Views
492
Pete_UK
P
L
Do while not last row
  • littleredhairedgirl
Replies
2
Views
495
Mike H
M
G
BeforeRightClick
  • gk
Replies
4
Views
377
gk
G
L
Text Item Processor
  • littleredhairedgirl
Replies
1
Views
399
littleredhairedgirl
L
Back
Top