Microsoft Excel Worksheet Functions

Post thread
D
complex lookup
  • Doug
Replies
8
Views
567
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
420
Don Guillett
D
P
extracting data from one cell to another
  • pat67
Replies
8
Views
895
Ron Rosenfeld
R
C
Using Fill command in Editing Group
  • Caz
Replies
2
Views
641
Gord Dibben
G
K
Macro for Time Recording
  • karim
Replies
2
Views
391
Gord Dibben
G
S
Format Ratio Q
  • Seanie
Replies
2
Views
505
Dana DeLouis
D
D
question related to merging multiple statements
  • Dharmesh
Replies
5
Views
522
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
493
Sean
S
S
how do i use format cells to alpha / numeric values
  • Samvid69
Replies
2
Views
669
ozgrid.com
O
G
Maximum number of cells for 'SUM' ?
  • Groybs
Replies
7
Views
567
ozgrid.com
O
J
Copy formula from one worksheet to another to get value in 2nd wks
  • JR
Replies
1
Views
847
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
367
samrah
S
M
Logical Test for blank and then for score
  • Mikesnhu
Replies
1
Views
522
PatM
P
G
summary values across worksheets within the same workbook
  • Gordon
Replies
2
Views
559
Ormond
O
C
Count Multiple Text Entries
  • Craig
Replies
1
Views
405
ker_01
K
W
Drop list and redirect
  • WT
Replies
1
Views
378
L. Howard Kittle
L
O
Sharing workbook
  • Olivier
Replies
3
Views
962
Gord Dibben
G
A
YES or NO formulas
  • Alyssa
Replies
3
Views
602
FSt1
F
W
Sumif Function
  • worduser
Replies
1
Views
487
Lars-Åke Aspelin
L
J
determine a range using a formula
  • Jonathon Shull
Replies
2
Views
501
Jonathon Shull
J
P
Need some help with auto-fill
  • Per Carlsson
Replies
1
Views
375
Pete_UK
P
A
VBA to autofill from relative location
  • AlexJarvis
Replies
2
Views
956
AlexJarvis
A
G
Finding most recent date for each customer - XL 2007
  • Geoff B
Replies
2
Views
528
Herbert Seidenberg
H
E
SAMPLE EXCEL DATA
  • EricB
Replies
2
Views
439
Jacob Skaria
J
R
negative value
  • Radhakant Panigrahi
Replies
6
Views
539
JLatham
J
W
Multiple AND OR functions
  • Woodi2
Replies
5
Views
429
Steve Dunn
S
H
Pick List + Alphabetical Skip To or Auto Complete
  • Hark2k
Replies
2
Views
649
Steve Dunn
S
M
IF formula help
  • Mark D
Replies
2
Views
345
Ms-Exl-Learner
M
M
VLOOKUP help (possible format issue)
  • Mark D
Replies
6
Views
469
Mark D
M
S
counting unique text values in an array of data
  • selltrue
Replies
1
Views
470
Steve Dunn
S
D
search excel for overpopulated cells
  • darrick
Replies
1
Views
416
Steve Dunn
S
C
Help with lookup
  • CW
Replies
3
Views
394
Eduardo
E
R
Dynamic sheet reference in Name formula
  • Raj
Replies
1
Views
563
Bob Phillips
B
K
need to install DVZXLAddin.xla
  • kiran
Replies
1
Views
701
Ms-Exl-Learner
M
N
Average If...
  • Nadine
Replies
12
Views
871
Steve Dunn
S
S
protection error
  • Selen
Replies
2
Views
320
Jacob Skaria
J
C
adding time in a work schedule
  • Chris
Replies
5
Views
627
Jacob Skaria
J
M
Vlookup return 2nd match
  • MarkinArk
Replies
2
Views
752
T. Valko
T
S
Average IF Function
  • SandiVaughn
Replies
3
Views
608
T. Valko
T
N
Adding fill to cells only when value is "No" in another cell
  • Noel
Replies
1
Views
527
Fred Smith
F
J
Counting Results of Formulas
  • jgupte
Replies
1
Views
513
T. Valko
T
M
need formula to add two different criteria in a range
  • Meenie
Replies
6
Views
501
Dave Peterson
D
J
Keeping the format but update the data
  • JoeM
Replies
2
Views
408
JoeM
J
S
Deleting/Clearing duplicate range of cells
  • Steve
Replies
4
Views
629
Steve
S
C
Count Text to get a Percentage
  • Craig
Replies
4
Views
416
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
435
JLatham
J
Back
Top