Microsoft Excel Worksheet Functions

G
need help with lookup formula
  • Gil
Replies
5
Views
283K
carlo
C
J
is blank AND is error
  • jane
Replies
7
Views
154K
Dave Peterson
D
S
Search for value in a range
  • Student
Replies
6
Views
435K
Ron Coderre
R
S
Importing from Access
  • sfleck
Replies
2
Views
90K
sfleck
S
G
how to tighten up unwieldy formula
  • Green Fox
Replies
3
Views
347K
Herbert Seidenberg
H
B
SUMIF question
  • Billy B
Replies
4
Views
53K
Don Guillett
D
B
Linkage problem between spreadsheets
  • Bernie R.
Replies
4
Views
259K
Bernie R.
B
J
SUMPRODUCT problem
  • juliejg1
Replies
4
Views
565K
Bernard Liengme
B
P
Formula to point to another cell if an option is chosen.
  • Peggy
Replies
2
Views
40K
Gord Dibben
G
A
Run time error '1004'
  • aeddave
Replies
1
Views
360K
Dave Peterson
D
B
Lookup function
  • BAS
Replies
3
Views
192K
BAS
B
T
VLOOKUP WITH 2 CRITERIAS...
  • TRYIN
Replies
1
Views
96K
Dave Peterson
D
L
chart from drop down list of ranges
  • LDP Analyst
Replies
1
Views
30K
Gord Dibben
G
P
Convert minutes into hours
  • Paul
Replies
3
Views
512K
Dave Peterson
D
O
Am trying to autofill a formula and it will not increment down?
  • Opsmgr
Replies
1
Views
125K
ryguy7272
R
A
Can we create a viewport in Excel like Autocad?
  • Alireza Nejad
Replies
1
Views
372K
Gord Dibben
G
M
STEP MULTIPLY FUNCTION
  • Mitch Desai
Replies
5
Views
624K
Gord Dibben
G
S
Condl formtng of range of cells based on one value
  • Sue in AZ
Replies
1
Views
74K
Sue in AZ
S
G
using a vlookup, can i use isblank to show an empty cell
  • Guest
Replies
7
Views
354K
T. Valko
T
B
Function to populate cells??
  • BAS
Replies
3
Views
236K
BAS
B
D
multiple vlookups in one statement
  • Dave
Replies
3
Views
314K
CLR
C
S
Multiple Scenario Condition Formula
  • ssmbob
Replies
2
Views
192K
ssmbob
S
N
Updating columns in worksheet based on values from another worksh.
  • NBROWN
Replies
1
Views
154K
Teethless mama
T
S
Looking for certain months and summing the totals
  • sherobot
Replies
10
Views
481K
Don Guillett
D
Z
Assigning macro to toolbar - only works sometimes!
  • Zak
Replies
4
Views
430K
Zak
Z
I
VBA Function
  • IPerlovsky
Replies
7
Views
630K
Don Guillett
D
P
Data Validation error message
  • Peggy
Replies
1
Views
40K
Peggy
P
N
Count of a time range
  • Nycole
Replies
13
Views
1M
Pete_UK
P
K
Before Save code
  • Kelly
Replies
4
Views
238K
Dave Peterson
D
E
Adding workdays
  • Excel-learner
Replies
1
Views
219K
Teethless mama
T
A
IF Function to enter background colour and border to a cell
  • Amanda
Replies
1
Views
99K
Teethless mama
T
R
The right formula is?
  • Ray
Replies
2
Views
272K
Ray
R
L
Crazy If
  • LiveUser
Replies
1
Views
413K
Max
M
G
Linking cells in different spreadsheets
  • Guest
Replies
6
Views
96K
Bernie
B
P
Formula to record the date
  • Peggy
Replies
12
Views
280K
Peggy
P
E
avoid embedded if statements
  • ellebelle
Replies
3
Views
165K
Pete_UK
P
C
copy data of two cells from Sheet 2 into one cell in Sheet 1
  • cahabbinga
Replies
6
Views
562K
Pete_UK
P
L
choose table_array in VLOOKUP from list of multiple worksheets?
  • LDP Analyst
Replies
5
Views
226K
[email protected]
D
S
interpolation
  • serching table
Replies
3
Views
282K
Bernd P
B
C
Summing user defined ranges from other tabs within the same workbook
  • Colin Brodie
Replies
0
Views
188K
Colin Brodie
C
D
is TEXT function appropriate?
  • DaveMoore
Replies
2
Views
260K
David Biddulph
D
J
LARGE 1, LARGE 2, LARGE 3, LARGE 4
  • jeel
Replies
2
Views
45K
Greg Wilson
G
H
default format for remarks
  • HJ Liang
Replies
1
Views
55K
Conan Kelly
C
O
Please help on array search & result
  • ORLANDO V
Replies
3
Views
365K
T. Valko
T
F
Record entry by date
  • Francis
Replies
3
Views
240K
Max
M
F
when autofiltering a spreadsheet need to know number of records
  • Fouzia
Replies
2
Views
269K
Dave Peterson
D
J
Sumif range?
  • JHL
Replies
2
Views
315K
JHL
J
O
lookup one value in list and return multiple results
  • ORLANDO V
Replies
2
Views
262K
RagDyer
R
A
Different comparison criteria in sumproduct
  • adimar
Replies
5
Views
25K
Conan Kelly
C
C
comparing one to one cell within range
  • caroline
Replies
3
Views
370K
Ron Coderre
R
You must log in or register to post here.
Back
Top