Microsoft Excel Worksheet Functions

Post thread
D
complex lookup
  • Doug
Replies
8
Views
617
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
446
Don Guillett
D
P
extracting data from one cell to another
  • pat67
Replies
8
Views
947
Ron Rosenfeld
R
C
Using Fill command in Editing Group
  • Caz
Replies
2
Views
648
Gord Dibben
G
K
Macro for Time Recording
  • karim
Replies
2
Views
399
Gord Dibben
G
S
Format Ratio Q
  • Seanie
Replies
2
Views
515
Dana DeLouis
D
D
question related to merging multiple statements
  • Dharmesh
Replies
5
Views
565
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
515
Sean
S
S
how do i use format cells to alpha / numeric values
  • Samvid69
Replies
2
Views
689
ozgrid.com
O
G
Maximum number of cells for 'SUM' ?
  • Groybs
Replies
7
Views
602
ozgrid.com
O
J
Copy formula from one worksheet to another to get value in 2nd wks
  • JR
Replies
1
Views
885
Groybs
G
N
Conditional Formatting on Index,Match formula
  • Nadine
Replies
3
Views
4K
T. Valko
T
C
Conditional formatting problem
  • Coco212
Replies
3
Views
388
samrah
S
M
Logical Test for blank and then for score
  • Mikesnhu
Replies
1
Views
546
PatM
P
G
summary values across worksheets within the same workbook
  • Gordon
Replies
2
Views
591
Ormond
O
C
Count Multiple Text Entries
  • Craig
Replies
1
Views
438
ker_01
K
W
Drop list and redirect
  • WT
Replies
1
Views
396
L. Howard Kittle
L
O
Sharing workbook
  • Olivier
Replies
3
Views
976
Gord Dibben
G
A
YES or NO formulas
  • Alyssa
Replies
3
Views
617
FSt1
F
W
Sumif Function
  • worduser
Replies
1
Views
515
Lars-Åke Aspelin
L
J
determine a range using a formula
  • Jonathon Shull
Replies
2
Views
563
Jonathon Shull
J
P
Need some help with auto-fill
  • Per Carlsson
Replies
1
Views
386
Pete_UK
P
A
VBA to autofill from relative location
  • AlexJarvis
Replies
2
Views
980
AlexJarvis
A
G
Finding most recent date for each customer - XL 2007
  • Geoff B
Replies
2
Views
576
Herbert Seidenberg
H
E
SAMPLE EXCEL DATA
  • EricB
Replies
2
Views
446
Jacob Skaria
J
R
negative value
  • Radhakant Panigrahi
Replies
6
Views
569
JLatham
J
W
Multiple AND OR functions
  • Woodi2
Replies
5
Views
471
Steve Dunn
S
H
Pick List + Alphabetical Skip To or Auto Complete
  • Hark2k
Replies
2
Views
767
Steve Dunn
S
M
IF formula help
  • Mark D
Replies
2
Views
382
Ms-Exl-Learner
M
M
VLOOKUP help (possible format issue)
  • Mark D
Replies
6
Views
502
Mark D
M
S
counting unique text values in an array of data
  • selltrue
Replies
1
Views
487
Steve Dunn
S
D
search excel for overpopulated cells
  • darrick
Replies
1
Views
428
Steve Dunn
S
C
Help with lookup
  • CW
Replies
3
Views
419
Eduardo
E
R
Dynamic sheet reference in Name formula
  • Raj
Replies
1
Views
589
Bob Phillips
B
K
need to install DVZXLAddin.xla
  • kiran
Replies
1
Views
703
Ms-Exl-Learner
M
N
Average If...
  • Nadine
Replies
12
Views
997
Steve Dunn
S
S
protection error
  • Selen
Replies
2
Views
335
Jacob Skaria
J
C
adding time in a work schedule
  • Chris
Replies
5
Views
676
Jacob Skaria
J
M
Vlookup return 2nd match
  • MarkinArk
Replies
2
Views
767
T. Valko
T
S
Average IF Function
  • SandiVaughn
Replies
3
Views
652
T. Valko
T
N
Adding fill to cells only when value is "No" in another cell
  • Noel
Replies
1
Views
558
Fred Smith
F
J
Counting Results of Formulas
  • jgupte
Replies
1
Views
580
T. Valko
T
M
need formula to add two different criteria in a range
  • Meenie
Replies
6
Views
548
Dave Peterson
D
J
Keeping the format but update the data
  • JoeM
Replies
2
Views
413
JoeM
J
S
Deleting/Clearing duplicate range of cells
  • Steve
Replies
4
Views
719
Steve
S
C
Count Text to get a Percentage
  • Craig
Replies
4
Views
434
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
467
JLatham
J
Back
Top