Microsoft Excel Worksheet Functions

S
find all same numbers in a column without dropdown listing
  • ShoDan
Replies
3
Views
263K
CLR
C
A
Find value in more than 100 worksheets at once
  • Alamgir Farooq
Replies
2
Views
72K
Dave Peterson
D
G
copy and paste.
  • Gary
Replies
1
Views
176K
Bernie Deitrick
B
L
Capitalize first letter in sentence
  • Lightjag
Replies
13
Views
455K
Gaurav
G
N
Accumulating Attendance Base upon Age Group
  • Neon520
Replies
5
Views
368K
Bob Phillips
B
T
Array or SumProduct or other?
  • TMK
Replies
3
Views
142K
TMK
T
A
Replacing a Table-array with a cell reference in vlookup
  • Allan
Replies
4
Views
189K
Mike H
M
M
Challenge: Return the rightmost 12 values (rolling 12 months)
  • mr tom
Replies
2
Views
82K
mr tom
M
R
Use Formula to sort two strings
  • Ray Ray
Replies
2
Views
125K
David Biddulph
D
C
Auto populate data from a table into cells after a match is found
  • CrashOz
Replies
5
Views
331K
Pete_UK
P
P
Calculating time
  • Pastor Selma
Replies
4
Views
391K
carlo
C
S
Ranking with Duplicates
  • shocksterman
Replies
1
Views
100K
T. Valko
T
R
Convert numbers to words
  • Rick
Replies
2
Views
473K
Rick Rothstein \(MVP - VB\)
R
L
Autocomplete combo box
  • Learning Excel
Replies
5
Views
369K
T. Valko
T
R
Convert Number to Words
  • Rick
Replies
2
Views
204K
Gord Dibben
G
P
Problem w/formula referencing another sheet
  • PatrickP
Replies
1
Views
217K
PatrickP
P
T
add file extensions to a column
  • The DLC
Replies
3
Views
119K
T. Valko
T
H
Remove Negative Signs from Formula Results
  • Holly
Replies
4
Views
444K
T. Valko
T
B
Copy from worksheet to worksheet
  • Bob
Replies
3
Views
356K
Colleen A
C
R
Average & Deviation
  • ross27
Replies
1
Views
53K
Tyro
T
K
count(if(... using array formula: can I use a named range in my ca
  • katy
Replies
1
Views
381K
katy
K
N
If Then Or Statement
  • nabanco
Replies
3
Views
383K
Max
M
G
invalid references
  • Guest
Replies
2
Views
229K
Gord Dibben
G
N
Leave Cell BLANK if no criteria met
  • Neon520
Replies
2
Views
239K
T. Valko
T
L
I have the checkmark beside print gridlines and they won't print
  • Lois
Replies
3
Views
45K
MartinW
M
B
Worksheet tab labels
  • Brenda463
Replies
7
Views
219K
Gord Dibben
G
N
NOT equal to
  • Neon520
Replies
5
Views
83K
Neon520
N
C
How Do You Stop Annoying Excel Message Boxes?
  • Colin Hayes
2
Replies
36
Views
2M
Colin Hayes
C
M
What function do i use?
  • motorman2008
Replies
2
Views
365K
LiveUser
L
J
Explode field
  • JustJo
Replies
3
Views
32K
Jim Cone
J
L
SUMPRODUCT, INDIRECT, dates...
  • LongTermNoob
Replies
5
Views
444K
T. Valko
T
R
reference first cell in a named range
  • Robert H
Replies
3
Views
215K
Robert H
R
B
Converting a Formula stored as String to real Formula
  • BlueD
Replies
3
Views
531K
JP
J
M
Probelm with macro
  • mac
Replies
5
Views
536K
Gord Dibben
G
S
Nesting SUMIF with Wildcard
  • ShannaD
Replies
3
Views
264K
T. Valko
T
G
average(if not working properly
  • Gaurav
Replies
7
Views
391K
Gaurav
G
M
constant date
  • medavino
Replies
3
Views
356K
Gord Dibben
G
I
Excel macro spreadsheet that is rejected by other firewall. Why?
  • illini10000
Replies
2
Views
146K
Roger Govier
R
B
No. of Saturdays between 2 dates
  • Bhupinder Rayat
Replies
5
Views
232K
Ron Rosenfeld
R
D
6 cell sum
  • dc04wrightl
Replies
2
Views
286K
RB
R
M
date entry
  • medavino
Replies
1
Views
176K
CLR
C
B
Not sure which function to use - need multiple lines of data
  • Bob
Replies
1
Views
81K
Duke Carey
D
R
referencing a 3D Named Range
  • Robert H
Replies
3
Views
292K
Harlan Grove
H
N
how do I change a date to show the year only?
  • Nicholw
Replies
2
Views
145K
CLR
C
M
Duplicates in a spread sheet
  • Martha
Replies
3
Views
46K
ryguy7272
R
F
"Grouping" based on value in a column
  • Fred
Replies
3
Views
369K
ryguy7272
R
R
Basic Statistics - which function?
  • REM
Replies
3
Views
31K
ilia
I
O
Macro error
  • orquidea
Replies
2
Views
109K
orquidea
O
A
Automatic Drop Down List
  • aeddave
Replies
3
Views
187K
JP
J
L
Compare two lists; return only unique records
  • Lkyred19
Replies
3
Views
198K
ryguy7272
R
You must log in or register to post here.
Back
Top