Microsoft Excel Worksheet Functions

Post thread
M
Copying and pasting with SUMIF and COUNTIF
  • mwdawg721
Replies
3
Views
964
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
662
aminh
A
S
Sum if not blank
  • SKSmith
Replies
2
Views
1K
Glenn
G
G
If Function with multiple criteria
  • GPearson
Replies
2
Views
447
Luke M
L
E
Index Match Error
  • EZ
Replies
1
Views
418
EZ
E
C
Can I put button on spreadsheet to make it print a specific part?
  • CindyMc
Replies
2
Views
589
JCS
J
E
Count text occurences in range when criteria in other column is me
  • eliyahuz
Replies
3
Views
547
Jacob Skaria
J
L
Conditional Formatting
  • Lynne
Replies
2
Views
313
Pete_UK
P
A
Referencing a cell in the worksheet as the criteria for a formula
  • Alagra
Replies
4
Views
521
Alagra
A
E
Count occurences of text in range only when Yes appears in other c
  • eliyahuz
Replies
9
Views
575
Pete_UK
P
T
Counting Unique occurences of text in a column
  • Tan
Replies
12
Views
732
T. Valko
T
C
csv delimeter
  • csv delimeter
Replies
3
Views
423
Gord Dibben
G
F
Ranking Sales Reps
  • Frustrated
Replies
2
Views
531
ryguy7272
R
R
IF Function formula (I think?)
  • Rocktaxi
Replies
4
Views
491
Rocktaxi
R
D
Conditional Formatting based on values from other sheet
  • Dmox
Replies
3
Views
475
Dmox
D
J
IF to group months
  • John McDonnell
Replies
3
Views
382
Ashish Mathur
A
C
FAO Mike
  • Caroline
Replies
9
Views
570
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
424
JLatham
J
B
More columne sorting
  • BEOPS
Replies
4
Views
430
David Biddulph
D
H
Look up last and next entry
  • Huggy
Replies
7
Views
549
Huggy
H
E
sumif using "AND" and "Date"
  • Excel_Kiwi
Replies
2
Views
384
Jacob Skaria
J
N
Formula have a VLOOKUP but want it to =0 if no value is found
  • Nicole
Replies
3
Views
450
T. Valko
T
A
Formula for payout & interest
  • Atreyu
Replies
3
Views
535
JoeU2004
J
K
User Defined Function and VLookUP
  • Kevin
Replies
11
Views
815
Kevin
K
P
Match value return a text
  • ppp
Replies
6
Views
477
Jacob Skaria
J
A
Allocate Value Across Monthly Periods
  • AlanR
Replies
1
Views
620
Jacob Skaria
J
J
Match Column and copy to cell Column D
  • Jeffrey Yau
Replies
1
Views
406
Ashish Mathur
A
C
nper
  • cdh625
Replies
1
Views
439
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
370
BSc Chem Eng Rick
B
H
WildCards in Sumif Function
  • Hardeep Kanwar
Replies
2
Views
506
Bob Phillips
B
D
Sum formula when cell cantains alphabets too
  • d3graph
Replies
0
Views
505
d3graph
D
C
Numbering years and months
  • Colin Hayes
Replies
4
Views
599
Colin Hayes
C
B
Colors too dark!
  • BiT212
Replies
1
Views
442
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
476
CellShocked
C
L
SUMIFs function
  • lefty
Replies
2
Views
504
Gord Dibben
G
L
display number if date is in a range
  • lmarty
Replies
4
Views
409
Rick Rothstein
R
B
Using wildcard * in MATCH
  • berniean
Replies
6
Views
740
Max
M
T
how do i use IF to substitute for another cell?
  • Tim
Replies
1
Views
383
Gord Dibben
G
N
using sort in excel 2003
  • naj
Replies
2
Views
343
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
756
Teethless mama
T
S
I have a column of 50 numbers
  • Skip
Replies
5
Views
465
Pete_UK
P
L
Do while not last row
  • littleredhairedgirl
Replies
2
Views
483
Mike H
M
G
BeforeRightClick
  • gk
Replies
4
Views
377
gk
G
L
Text Item Processor
  • littleredhairedgirl
Replies
1
Views
388
littleredhairedgirl
L
Back
Top