Microsoft Excel Worksheet Functions

Post thread
D
complex lookup
  • Doug
Replies
8
Views
566
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
416
Don Guillett
D
P
extracting data from one cell to another
  • pat67
Replies
8
Views
893
Ron Rosenfeld
R
C
Using Fill command in Editing Group
  • Caz
Replies
2
Views
639
Gord Dibben
G
K
Macro for Time Recording
  • karim
Replies
2
Views
389
Gord Dibben
G
S
Format Ratio Q
  • Seanie
Replies
2
Views
504
Dana DeLouis
D
D
question related to merging multiple statements
  • Dharmesh
Replies
5
Views
521
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
490
Sean
S
S
how do i use format cells to alpha / numeric values
  • Samvid69
Replies
2
Views
665
ozgrid.com
O
G
Maximum number of cells for 'SUM' ?
  • Groybs
Replies
7
Views
562
ozgrid.com
O
J
Copy formula from one worksheet to another to get value in 2nd wks
  • JR
Replies
1
Views
843
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
362
samrah
S
M
Logical Test for blank and then for score
  • Mikesnhu
Replies
1
Views
518
PatM
P
G
summary values across worksheets within the same workbook
  • Gordon
Replies
2
Views
554
Ormond
O
C
Count Multiple Text Entries
  • Craig
Replies
1
Views
402
ker_01
K
W
Drop list and redirect
  • WT
Replies
1
Views
374
L. Howard Kittle
L
O
Sharing workbook
  • Olivier
Replies
3
Views
961
Gord Dibben
G
A
YES or NO formulas
  • Alyssa
Replies
3
Views
597
FSt1
F
W
Sumif Function
  • worduser
Replies
1
Views
485
Lars-Åke Aspelin
L
J
determine a range using a formula
  • Jonathon Shull
Replies
2
Views
496
Jonathon Shull
J
P
Need some help with auto-fill
  • Per Carlsson
Replies
1
Views
374
Pete_UK
P
A
VBA to autofill from relative location
  • AlexJarvis
Replies
2
Views
955
AlexJarvis
A
G
Finding most recent date for each customer - XL 2007
  • Geoff B
Replies
2
Views
521
Herbert Seidenberg
H
E
SAMPLE EXCEL DATA
  • EricB
Replies
2
Views
438
Jacob Skaria
J
R
negative value
  • Radhakant Panigrahi
Replies
6
Views
537
JLatham
J
W
Multiple AND OR functions
  • Woodi2
Replies
5
Views
425
Steve Dunn
S
H
Pick List + Alphabetical Skip To or Auto Complete
  • Hark2k
Replies
2
Views
648
Steve Dunn
S
M
IF formula help
  • Mark D
Replies
2
Views
339
Ms-Exl-Learner
M
M
VLOOKUP help (possible format issue)
  • Mark D
Replies
6
Views
467
Mark D
M
S
counting unique text values in an array of data
  • selltrue
Replies
1
Views
466
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
391
Eduardo
E
R
Dynamic sheet reference in Name formula
  • Raj
Replies
1
Views
559
Bob Phillips
B
K
need to install DVZXLAddin.xla
  • kiran
Replies
1
Views
700
Ms-Exl-Learner
M
N
Average If...
  • Nadine
Replies
12
Views
856
Steve Dunn
S
S
protection error
  • Selen
Replies
2
Views
316
Jacob Skaria
J
C
adding time in a work schedule
  • Chris
Replies
5
Views
623
Jacob Skaria
J
M
Vlookup return 2nd match
  • MarkinArk
Replies
2
Views
750
T. Valko
T
S
Average IF Function
  • SandiVaughn
Replies
3
Views
604
T. Valko
T
N
Adding fill to cells only when value is "No" in another cell
  • Noel
Replies
1
Views
523
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
498
Dave Peterson
D
J
Keeping the format but update the data
  • JoeM
Replies
2
Views
407
JoeM
J
S
Deleting/Clearing duplicate range of cells
  • Steve
Replies
4
Views
625
Steve
S
C
Count Text to get a Percentage
  • Craig
Replies
4
Views
413
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
432
JLatham
J
Back
Top