Microsoft Excel Worksheet Functions

Post thread
M
conditionally format anumber format
  • Montana
Replies
5
Views
423
[email protected]
R
S
find all same numbers in a column without dropdown listing
  • ShoDan
Replies
3
Views
356
CLR
C
A
Find value in more than 100 worksheets at once
  • Alamgir Farooq
Replies
2
Views
373
Dave Peterson
D
G
copy and paste.
  • Gary
Replies
1
Views
345
Bernie Deitrick
B
L
Capitalize first letter in sentence
  • Lightjag
Replies
13
Views
2K
Gaurav
G
N
Accumulating Attendance Base upon Age Group
  • Neon520
Replies
5
Views
593
Bob Phillips
B
T
Array or SumProduct or other?
  • TMK
Replies
3
Views
405
TMK
T
A
Replacing a Table-array with a cell reference in vlookup
  • Allan
Replies
4
Views
2K
Mike H
M
M
Challenge: Return the rightmost 12 values (rolling 12 months)
  • mr tom
Replies
2
Views
383
mr tom
M
R
Use Formula to sort two strings
  • Ray Ray
Replies
2
Views
318
David Biddulph
D
C
Auto populate data from a table into cells after a match is found
  • CrashOz
Replies
5
Views
589
Pete_UK
P
P
Calculating time
  • Pastor Selma
Replies
4
Views
450
carlo
C
S
Ranking with Duplicates
  • shocksterman
Replies
1
Views
330
T. Valko
T
R
Convert numbers to words
  • Rick
Replies
2
Views
548
Rick Rothstein \(MVP - VB\)
R
L
Autocomplete combo box
  • Learning Excel
Replies
5
Views
2K
T. Valko
T
R
Convert Number to Words
  • Rick
Replies
2
Views
440
Gord Dibben
G
P
Problem w/formula referencing another sheet
  • PatrickP
Replies
1
Views
406
PatrickP
P
T
add file extensions to a column
  • The DLC
Replies
3
Views
444
T. Valko
T
H
Remove Negative Signs from Formula Results
  • Holly
Replies
4
Views
5K
T. Valko
T
B
Copy from worksheet to worksheet
  • Bob
Replies
3
Views
337
Colleen A
C
R
Average & Deviation
  • ross27
Replies
1
Views
333
Tyro
T
K
count(if(... using array formula: can I use a named range in my ca
  • katy
Replies
1
Views
561
katy
K
N
If Then Or Statement
  • nabanco
Replies
3
Views
285
Max
M
G
invalid references
  • Guest
Replies
2
Views
554
Gord Dibben
G
N
Leave Cell BLANK if no criteria met
  • Neon520
Replies
2
Views
629
T. Valko
T
L
I have the checkmark beside print gridlines and they won't print
  • Lois
Replies
3
Views
429
MartinW
M
B
Worksheet tab labels
  • Brenda463
Replies
7
Views
413
Gord Dibben
G
N
NOT equal to
  • Neon520
Replies
5
Views
482
Neon520
N
C
How Do You Stop Annoying Excel Message Boxes?
  • Colin Hayes
2
Replies
36
Views
6K
Colin Hayes
C
M
What function do i use?
  • motorman2008
Replies
2
Views
352
LiveUser
L
J
Explode field
  • JustJo
Replies
3
Views
439
Jim Cone
J
L
SUMPRODUCT, INDIRECT, dates...
  • LongTermNoob
Replies
5
Views
770
T. Valko
T
R
reference first cell in a named range
  • Robert H
Replies
3
Views
644
Robert H
R
B
Converting a Formula stored as String to real Formula
  • BlueD
Replies
3
Views
950
JP
J
M
Probelm with macro
  • mac
Replies
5
Views
409
Gord Dibben
G
S
Nesting SUMIF with Wildcard
  • ShannaD
Replies
3
Views
687
T. Valko
T
G
average(if not working properly
  • Gaurav
Replies
7
Views
713
Gaurav
G
M
constant date
  • medavino
Replies
3
Views
383
Gord Dibben
G
I
Excel macro spreadsheet that is rejected by other firewall. Why?
  • illini10000
Replies
2
Views
2K
Roger Govier
R
B
No. of Saturdays between 2 dates
  • Bhupinder Rayat
Replies
5
Views
515
Ron Rosenfeld
R
D
6 cell sum
  • dc04wrightl
Replies
2
Views
312
RB
R
M
date entry
  • medavino
Replies
1
Views
268
CLR
C
B
Not sure which function to use - need multiple lines of data
  • Bob
Replies
1
Views
349
Duke Carey
D
R
referencing a 3D Named Range
  • Robert H
Replies
3
Views
602
Harlan Grove
H
N
how do I change a date to show the year only?
  • Nicholw
Replies
2
Views
372
CLR
C
M
Duplicates in a spread sheet
  • Martha
Replies
3
Views
441
ryguy7272
R
F
"Grouping" based on value in a column
  • Fred
Replies
3
Views
352
ryguy7272
R
R
Basic Statistics - which function?
  • REM
Replies
3
Views
337
ilia
I
O
Macro error
  • orquidea
Replies
2
Views
382
orquidea
O
A
Automatic Drop Down List
  • aeddave
Replies
3
Views
301
JP
J
Back
Top