Microsoft Excel Worksheet Functions

Post thread
M
count spacing violations between values in column
  • Martin
Replies
1
Views
341
Shane Devenshire
S
J
Sorting the cells of a formula causes the formula to not work
  • Jake
Replies
3
Views
726
Ashish Mathur
A
S
sum of a named range with values based on vlookup results
  • Solutions Manager
2
Replies
20
Views
2K
T. Valko
T
W
IF Statement JER
  • Workbook
Replies
5
Views
380
T. Valko
T
A
Issue with VLOOKUP
  • armsiee
Replies
3
Views
428
xlmate
X
W
Subtracting Dates to Find the Difference in Hours
  • Workbook
Replies
6
Views
547
Workbook
W
S
Use of Check Boxes
  • stinger1
Replies
1
Views
357
MyVeryOwnSelf
M
A
DAVERAGE
  • Andrew
Replies
13
Views
790
Elkar
E
R
Linking Worksheet to Database?
  • RoadKill
Replies
4
Views
262
RoadKill
R
G
Deleting the text without deleting the formula
  • gems04
Replies
3
Views
701
Gord Dibben
G
T
Prompting users with a message box on certain cells
  • tommy
Replies
7
Views
416
Gord Dibben
G
D
sorting and adding totals
  • docbehr
Replies
2
Views
364
Bernd P
B
C
Referencing data next to a date
  • Carina
Replies
6
Views
344
Carina
C
T
tricky if statement
  • Tanya Berfield
Replies
7
Views
326
Pete_UK
P
J
retrieve data from two columns and sort
  • Joe
Replies
17
Views
622
Joe
J
O
Formula Needed
  • Oscar A. Brown
Replies
6
Views
352
Oscar A. Brown
O
A
Pivot Table Filters
  • Alex Mackenzie
Replies
2
Views
582
Shane Devenshire
S
P
Excel crashes when typing "false" in VLookup function
  • pcbins
Replies
17
Views
6K
Glenn
G
E
Excel- Conditional Formatting
  • erugg21
Replies
3
Views
473
John
J
A
Calciation
  • AH
Replies
1
Views
490
Shane Devenshire
S
C
Today() function
  • chrisnsmith
Replies
2
Views
339
Shane Devenshire
S
E
SUMIF result including values not specified in sum-range
  • evans.notch.cabin
Replies
2
Views
574
Shane Devenshire
S
G
writing a greater than/less than formula
  • Guest
Replies
7
Views
670
Go-go
G
S
correlation between two data sets
  • SK08
Replies
1
Views
538
Shane Devenshire
S
S
Excel worksheet first column - the row indicator column
  • sfurney
Replies
6
Views
1K
sfurney
S
G
#N/A in VLookup - Can I use another function that will return 0?
  • Guest
Replies
9
Views
755
Gills
G
A
Multiple Countif with wildcard criteria
  • Awrex
Replies
10
Views
4K
Glenn
G
Y
Top 5 of the series
  • yclhk
Replies
5
Views
337
yclhk
Y
D
Populating a form
  • Deborah
Replies
2
Views
392
Dave Peterson
D
C
need help with sum formula
  • chrisnsmith
Replies
3
Views
356
chrisnsmith
C
M
Problems with Ctrl-D
  • Mike
Replies
1
Views
371
Dave Peterson
D
S
First In First Out Function
  • Sarah0824
Replies
3
Views
373
Rene
R
E
need answer- copy between workbooks
  • elmer
Replies
1
Views
375
elmer
E
S
The difference = Question
  • Shmilu
Replies
3
Views
294
Shmilu
S
T
Finding available payment date
  • tara
Replies
5
Views
482
tara
T
A
Sorting a block of page number citations
  • alfred.cloutier
Replies
4
Views
352
[email protected]
A
N
Function error
  • nc
Replies
1
Views
381
Bob Phillips
B
M
Can I have a cell change to red/green if not equal to:
  • Mark
Replies
7
Views
1K
Bernie Deitrick
B
O
HOW DO I FORMAT A NUMBER PRECEDED BY TWO O'S?
  • OWL QUEEN
Replies
2
Views
427
Stefi
S
V
Whether VLOOKUP can find Text
  • vmohan1978
Replies
6
Views
464
Ashish Mathur
A
L
Problem - lookup formula
  • laurafv
Replies
2
Views
378
laurafv
L
P
Return a 3 digit number
  • Patrick C. Simonds
Replies
2
Views
358
T. Valko
T
B
Formula Question - please help
  • Belle
Replies
8
Views
496
xlmate
X
S
Possible to auto-fill in gaps between numbers on straight line bas
  • sticky
Replies
1
Views
1K
Shane Devenshire
S
G
Match Function
  • Grip
Replies
1
Views
422
Shane Devenshire
S
J
Table
  • John Savy
Replies
8
Views
373
John Savy
J
S
Copying row formulas to a column?
  • Skip
Replies
5
Views
447
Ashish Mathur
A
C
HELP! Using IF, AND, OR and COUNTIF in one formula
  • cydkil
Replies
11
Views
722
Ashish Mathur
A
D
Using Drop Down List or Combo Box
  • Dana M
Replies
9
Views
540
T. Valko
T
C
Can I use a 'calculated' array in a function?
  • CalculatedArray
Replies
3
Views
430
T. Valko
T
Back
Top