Microsoft Excel Worksheet Functions

Post thread
K
Countif Function Using "AND"
  • Kika
Replies
3
Views
882
Tyro
T
G
need help with lookup formula
  • Gil
Replies
5
Views
464
carlo
C
J
is blank AND is error
  • jane
Replies
7
Views
479
Dave Peterson
D
S
Search for value in a range
  • Student
Replies
6
Views
322
Ron Coderre
R
S
Importing from Access
  • sfleck
Replies
2
Views
225
sfleck
S
G
how to tighten up unwieldy formula
  • Green Fox
Replies
3
Views
444
Herbert Seidenberg
H
B
SUMIF question
  • Billy B
Replies
4
Views
372
Don Guillett
D
B
Linkage problem between spreadsheets
  • Bernie R.
Replies
4
Views
450
Bernie R.
B
J
SUMPRODUCT problem
  • juliejg1
Replies
4
Views
398
Bernard Liengme
B
P
Formula to point to another cell if an option is chosen.
  • Peggy
Replies
2
Views
577
Gord Dibben
G
A
Run time error '1004'
  • aeddave
Replies
1
Views
451
Dave Peterson
D
B
Lookup function
  • BAS
Replies
3
Views
305
BAS
B
T
VLOOKUP WITH 2 CRITERIAS...
  • TRYIN
Replies
1
Views
349
Dave Peterson
D
L
chart from drop down list of ranges
  • LDP Analyst
Replies
1
Views
221
Gord Dibben
G
P
Convert minutes into hours
  • Paul
Replies
3
Views
525
Dave Peterson
D
O
Am trying to autofill a formula and it will not increment down?
  • Opsmgr
Replies
1
Views
620
ryguy7272
R
A
Can we create a viewport in Excel like Autocad?
  • Alireza Nejad
Replies
1
Views
8K
Gord Dibben
G
M
STEP MULTIPLY FUNCTION
  • Mitch Desai
Replies
5
Views
433
Gord Dibben
G
S
Condl formtng of range of cells based on one value
  • Sue in AZ
Replies
1
Views
241
Sue in AZ
S
G
using a vlookup, can i use isblank to show an empty cell
  • Guest
Replies
7
Views
8K
T. Valko
T
B
Function to populate cells??
  • BAS
Replies
3
Views
381
BAS
B
D
multiple vlookups in one statement
  • Dave
Replies
3
Views
656
CLR
C
S
Multiple Scenario Condition Formula
  • ssmbob
Replies
2
Views
407
ssmbob
S
N
Updating columns in worksheet based on values from another worksh.
  • NBROWN
Replies
1
Views
444
Teethless mama
T
S
Looking for certain months and summing the totals
  • sherobot
Replies
10
Views
686
Don Guillett
D
Z
Assigning macro to toolbar - only works sometimes!
  • Zak
Replies
4
Views
525
Zak
Z
I
VBA Function
  • IPerlovsky
Replies
7
Views
417
Don Guillett
D
P
Data Validation error message
  • Peggy
Replies
1
Views
367
Peggy
P
N
Count of a time range
  • Nycole
Replies
13
Views
666
Pete_UK
P
K
Before Save code
  • Kelly
Replies
4
Views
364
Dave Peterson
D
E
Adding workdays
  • Excel-learner
Replies
1
Views
671
Teethless mama
T
A
IF Function to enter background colour and border to a cell
  • Amanda
Replies
1
Views
287
Teethless mama
T
R
The right formula is?
  • Ray
Replies
2
Views
272
Ray
R
L
Crazy If
  • LiveUser
Replies
1
Views
390
Max
M
G
Linking cells in different spreadsheets
  • Guest
Replies
6
Views
404
Bernie
B
P
Formula to record the date
  • Peggy
Replies
12
Views
503
Peggy
P
E
avoid embedded if statements
  • ellebelle
Replies
3
Views
475
Pete_UK
P
C
copy data of two cells from Sheet 2 into one cell in Sheet 1
  • cahabbinga
Replies
6
Views
806
Pete_UK
P
L
choose table_array in VLOOKUP from list of multiple worksheets?
  • LDP Analyst
Replies
5
Views
4K
[email protected]
D
S
interpolation
  • serching table
Replies
3
Views
489
Bernd P
B
C
Summing user defined ranges from other tabs within the same workbook
  • Colin Brodie
Replies
0
Views
584
Colin Brodie
C
D
is TEXT function appropriate?
  • DaveMoore
Replies
2
Views
383
David Biddulph
D
J
LARGE 1, LARGE 2, LARGE 3, LARGE 4
  • jeel
Replies
2
Views
1K
Greg Wilson
G
H
default format for remarks
  • HJ Liang
Replies
1
Views
282
Conan Kelly
C
O
Please help on array search & result
  • ORLANDO V
Replies
3
Views
363
T. Valko
T
F
Record entry by date
  • Francis
Replies
3
Views
336
Max
M
F
when autofiltering a spreadsheet need to know number of records
  • Fouzia
Replies
2
Views
358
Dave Peterson
D
J
Sumif range?
  • JHL
Replies
2
Views
526
JHL
J
O
lookup one value in list and return multiple results
  • ORLANDO V
Replies
2
Views
641
RagDyer
R
A
Different comparison criteria in sumproduct
  • adimar
Replies
5
Views
826
Conan Kelly
C
Back
Top