Microsoft Excel Worksheet Functions

Post thread
D
complex lookup
  • Doug
Replies
8
Views
581
Bernd P
B
H
finding 10 smallest numbers from last 20 input
  • handicapper
Replies
8
Views
1K
Bernd P
B
S
code to copy range
  • smith82
Replies
1
Views
426
Don Guillett
D
P
extracting data from one cell to another
  • pat67
Replies
8
Views
914
Ron Rosenfeld
R
C
Using Fill command in Editing Group
  • Caz
Replies
2
Views
644
Gord Dibben
G
K
Macro for Time Recording
  • karim
Replies
2
Views
391
Gord Dibben
G
S
Format Ratio Q
  • Seanie
Replies
2
Views
506
Dana DeLouis
D
D
question related to merging multiple statements
  • Dharmesh
Replies
5
Views
533
Rick Rothstein
R
B
IRR showed #NUM!
  • bakbuk
Replies
16
Views
9K
Dana DeLouis
D
S
Nested formular to give a word answer based on 2 cells
  • Sean
Replies
4
Views
500
Sean
S
S
how do i use format cells to alpha / numeric values
  • Samvid69
Replies
2
Views
675
ozgrid.com
O
G
Maximum number of cells for 'SUM' ?
  • Groybs
Replies
7
Views
574
ozgrid.com
O
J
Copy formula from one worksheet to another to get value in 2nd wks
  • JR
Replies
1
Views
858
Groybs
G
N
Conditional Formatting on Index,Match formula
  • Nadine
Replies
3
Views
3K
T. Valko
T
C
Conditional formatting problem
  • Coco212
Replies
3
Views
374
samrah
S
M
Logical Test for blank and then for score
  • Mikesnhu
Replies
1
Views
526
PatM
P
G
summary values across worksheets within the same workbook
  • Gordon
Replies
2
Views
565
Ormond
O
C
Count Multiple Text Entries
  • Craig
Replies
1
Views
413
ker_01
K
W
Drop list and redirect
  • WT
Replies
1
Views
385
L. Howard Kittle
L
O
Sharing workbook
  • Olivier
Replies
3
Views
964
Gord Dibben
G
A
YES or NO formulas
  • Alyssa
Replies
3
Views
603
FSt1
F
W
Sumif Function
  • worduser
Replies
1
Views
493
Lars-Åke Aspelin
L
J
determine a range using a formula
  • Jonathon Shull
Replies
2
Views
516
Jonathon Shull
J
P
Need some help with auto-fill
  • Per Carlsson
Replies
1
Views
377
Pete_UK
P
A
VBA to autofill from relative location
  • AlexJarvis
Replies
2
Views
959
AlexJarvis
A
G
Finding most recent date for each customer - XL 2007
  • Geoff B
Replies
2
Views
531
Herbert Seidenberg
H
E
SAMPLE EXCEL DATA
  • EricB
Replies
2
Views
442
Jacob Skaria
J
R
negative value
  • Radhakant Panigrahi
Replies
6
Views
546
JLatham
J
W
Multiple AND OR functions
  • Woodi2
Replies
5
Views
433
Steve Dunn
S
H
Pick List + Alphabetical Skip To or Auto Complete
  • Hark2k
Replies
2
Views
655
Steve Dunn
S
M
IF formula help
  • Mark D
Replies
2
Views
351
Ms-Exl-Learner
M
M
VLOOKUP help (possible format issue)
  • Mark D
Replies
6
Views
472
Mark D
M
S
counting unique text values in an array of data
  • selltrue
Replies
1
Views
474
Steve Dunn
S
D
search excel for overpopulated cells
  • darrick
Replies
1
Views
420
Steve Dunn
S
C
Help with lookup
  • CW
Replies
3
Views
397
Eduardo
E
R
Dynamic sheet reference in Name formula
  • Raj
Replies
1
Views
567
Bob Phillips
B
K
need to install DVZXLAddin.xla
  • kiran
Replies
1
Views
702
Ms-Exl-Learner
M
N
Average If...
  • Nadine
Replies
12
Views
897
Steve Dunn
S
S
protection error
  • Selen
Replies
2
Views
323
Jacob Skaria
J
C
adding time in a work schedule
  • Chris
Replies
5
Views
633
Jacob Skaria
J
M
Vlookup return 2nd match
  • MarkinArk
Replies
2
Views
753
T. Valko
T
S
Average IF Function
  • SandiVaughn
Replies
3
Views
614
T. Valko
T
N
Adding fill to cells only when value is "No" in another cell
  • Noel
Replies
1
Views
534
Fred Smith
F
J
Counting Results of Formulas
  • jgupte
Replies
1
Views
520
T. Valko
T
M
need formula to add two different criteria in a range
  • Meenie
Replies
6
Views
519
Dave Peterson
D
J
Keeping the format but update the data
  • JoeM
Replies
2
Views
409
JoeM
J
S
Deleting/Clearing duplicate range of cells
  • Steve
Replies
4
Views
630
Steve
S
C
Count Text to get a Percentage
  • Craig
Replies
4
Views
420
Craig
C
J
date from sheet name
  • JBoulton
2
Replies
22
Views
1K
T. Valko
T
S
SUMIF? or not?
  • Scott A
Replies
1
Views
441
JLatham
J
Back
Top