Microsoft Excel Worksheet Functions

Post thread
D
complex lookup
  • Doug
Replies
8
Views
601
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
435
Don Guillett
D
P
extracting data from one cell to another
  • pat67
Replies
8
Views
945
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
395
Gord Dibben
G
S
Format Ratio Q
  • Seanie
Replies
2
Views
511
Dana DeLouis
D
D
question related to merging multiple statements
  • Dharmesh
Replies
5
Views
545
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
514
Sean
S
S
how do i use format cells to alpha / numeric values
  • Samvid69
Replies
2
Views
685
ozgrid.com
O
G
Maximum number of cells for 'SUM' ?
  • Groybs
Replies
7
Views
599
ozgrid.com
O
J
Copy formula from one worksheet to another to get value in 2nd wks
  • JR
Replies
1
Views
867
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
386
samrah
S
M
Logical Test for blank and then for score
  • Mikesnhu
Replies
1
Views
539
PatM
P
G
summary values across worksheets within the same workbook
  • Gordon
Replies
2
Views
579
Ormond
O
C
Count Multiple Text Entries
  • Craig
Replies
1
Views
426
ker_01
K
W
Drop list and redirect
  • WT
Replies
1
Views
390
L. Howard Kittle
L
O
Sharing workbook
  • Olivier
Replies
3
Views
970
Gord Dibben
G
A
YES or NO formulas
  • Alyssa
Replies
3
Views
613
FSt1
F
W
Sumif Function
  • worduser
Replies
1
Views
511
Lars-Åke Aspelin
L
J
determine a range using a formula
  • Jonathon Shull
Replies
2
Views
537
Jonathon Shull
J
P
Need some help with auto-fill
  • Per Carlsson
Replies
1
Views
384
Pete_UK
P
A
VBA to autofill from relative location
  • AlexJarvis
Replies
2
Views
973
AlexJarvis
A
G
Finding most recent date for each customer - XL 2007
  • Geoff B
Replies
2
Views
554
Herbert Seidenberg
H
E
SAMPLE EXCEL DATA
  • EricB
Replies
2
Views
446
Jacob Skaria
J
R
negative value
  • Radhakant Panigrahi
Replies
6
Views
564
JLatham
J
W
Multiple AND OR functions
  • Woodi2
Replies
5
Views
452
Steve Dunn
S
H
Pick List + Alphabetical Skip To or Auto Complete
  • Hark2k
Replies
2
Views
668
Steve Dunn
S
M
IF formula help
  • Mark D
Replies
2
Views
369
Ms-Exl-Learner
M
M
VLOOKUP help (possible format issue)
  • Mark D
Replies
6
Views
489
Mark D
M
S
counting unique text values in an array of data
  • selltrue
Replies
1
Views
484
Steve Dunn
S
D
search excel for overpopulated cells
  • darrick
Replies
1
Views
426
Steve Dunn
S
C
Help with lookup
  • CW
Replies
3
Views
408
Eduardo
E
R
Dynamic sheet reference in Name formula
  • Raj
Replies
1
Views
577
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
938
Steve Dunn
S
S
protection error
  • Selen
Replies
2
Views
329
Jacob Skaria
J
C
adding time in a work schedule
  • Chris
Replies
5
Views
656
Jacob Skaria
J
M
Vlookup return 2nd match
  • MarkinArk
Replies
2
Views
760
T. Valko
T
S
Average IF Function
  • SandiVaughn
Replies
3
Views
637
T. Valko
T
N
Adding fill to cells only when value is "No" in another cell
  • Noel
Replies
1
Views
545
Fred Smith
F
J
Counting Results of Formulas
  • jgupte
Replies
1
Views
552
T. Valko
T
M
need formula to add two different criteria in a range
  • Meenie
Replies
6
Views
531
Dave Peterson
D
J
Keeping the format but update the data
  • JoeM
Replies
2
Views
411
JoeM
J
S
Deleting/Clearing duplicate range of cells
  • Steve
Replies
4
Views
654
Steve
S
C
Count Text to get a Percentage
  • Craig
Replies
4
Views
426
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
455
JLatham
J
Back
Top