Microsoft Excel Worksheet Functions

Post thread
D
Test 2 numbers
  • Dave
Replies
18
Views
612
Shane Devenshire
S
C
How to auto sum cells if letters are in cells?
  • christinelday
Replies
2
Views
1K
Shane Devenshire
S
K
convert day of year to numeric value format year+day in 4 digits
  • Kaaren
Replies
3
Views
2K
Shane Devenshire
S
S
Can i make text in cells c60@n60 bold & black if sum of C59 is gre
  • Spartan C10
Replies
7
Views
494
Fred Smith
F
G
Locking cells
  • Graham
Replies
3
Views
396
Gord Dibben
G
M
count with multiple critirea
  • MANYHEADACHES
Replies
4
Views
394
Shane Devenshire
S
H
Countif(and
  • Help with Countif(and
Replies
7
Views
651
T. Valko
T
T
Excel 2007 vs 2003 menus.
  • Ted Stilwell
Replies
2
Views
355
Shane Devenshire
S
C
How do I place a picture instead of words in a hidden comment box
  • Christy81267
Replies
2
Views
458
xlmate
X
W
userform date issue
  • Woodi2
Replies
4
Views
426
Woodi2
W
M
The If function
  • Matt
Replies
4
Views
615
Pete_UK
P
D
Using SUMPRODUCT, 3 variables, 2 types of data in 1 column
  • Dana M
Replies
3
Views
585
Pete_UK
P
G
conditional formating - dragging a cond. format over an entire col
  • Guest
Replies
3
Views
2K
Artem
A
L
how do i get a cell to fill red/blue as the outcome of a formula?
  • Lynz1976
Replies
13
Views
614
Lynz1976
L
R
Referenced cell change when row is blank
  • Read
Replies
1
Views
397
muddan madhu
M
N
Error message
  • Noepie
Replies
7
Views
408
Noepie
N
A
Formula - assign a cell to show the next
  • ash3154
Replies
6
Views
417
ash3154
A
S
SUMIF FUNCTION works in all cells but those related to one account
  • Skyhawk
Replies
4
Views
502
T. Valko
T
R
Count Unique Numbers if Names Match
  • ryguy7272
Replies
4
Views
481
Ashish Mathur
A
K
SUMIF function
  • Kathryn
Replies
7
Views
458
Elkar
E
K
Question on which function to use
  • kurchian
Replies
2
Views
420
Ashish Mathur
A
D
aging category calculation for open purchase order report in Excel
  • Dan gibbs
Replies
3
Views
3K
Ashish Mathur
A
N
DIV/0 error
  • Nicky
Replies
5
Views
553
Ashish Mathur
A
C
Formula Help
  • Curtis
Replies
1
Views
285
Paul
P
M
Compare and then copy cell to separate worksheet
  • Matt
Replies
1
Views
474
Pete_UK
P
T
Double (triple?) Index Lookup
  • thedr9wningman
Replies
6
Views
1K
Max
M
I
Using lookup functions with conditions and constantly changing dat
  • (-) Ions
Replies
10
Views
734
Max
M
K
finding multiple code dates for multiple item number
  • kmc
Replies
2
Views
453
Glenn
G
T
How do I use countif like sumif ie (range,criteria,count_range)
  • tmarie
Replies
1
Views
638
T. Valko
T
A
sum function
  • angie
Replies
3
Views
283
Marcelo
M
C
VB Code
  • chrisnsmith
Replies
6
Views
636
Don Guillett
D
T
dividng numbers using the sumif function
  • tiare1021
Replies
2
Views
454
Mike H
M
C
My current formulas in documents have quit working
  • Clark
Replies
1
Views
380
Mike H
M
P
Option Buttons, Forms Control, Excel 2007 - 3 options
  • Paula
Replies
6
Views
568
Paula
P
W
Getting rid of VLOOKUP N/A
  • WA
Replies
3
Views
567
WA
W
E
Function to find truncated entries?
  • EllenM
Replies
3
Views
403
EllenM
E
Y
calculated celles according to more then 1 condition
  • -yuval
Replies
5
Views
387
xlmate
X
J
"go to" "blanks" after using a formula
  • jhnnyboy247
Replies
2
Views
354
T. Valko
T
M
Fill down without formatting macro
  • Mike
Replies
7
Views
7K
Bernie Deitrick
B
R
getting excel to recognise copied data as mm:ss not hh:mm
  • Ravi B
Replies
2
Views
434
Shane Devenshire
S
S
Date functions and #value!
  • SafetyIntern
Replies
3
Views
367
SelfTaughExcelJunkie
S
M
EXcel problem
  • MicrosoftBob
Replies
2
Views
395
Shane Devenshire
S
S
how do i compare two text columns
  • sflanegin
Replies
1
Views
785
Shane Devenshire
S
N
Pivot Table Chart Drop Down Box
  • Newbie
Replies
6
Views
652
Newbie
N
D
Calculating ratios: Is there a formula that can do this?
  • dshadrock
Replies
2
Views
485
Shane Devenshire
S
M
Find and replace dilemma
  • mismose
Replies
3
Views
305
mismose
M
P
Formula please
  • Peta
Replies
6
Views
354
Roger Govier
R
L
newbie
  • lena
Replies
5
Views
374
joeu2004
J
G
vlookup for same name, multiple instances...
  • Guest
Replies
18
Views
2K
Pete_UK
P
M
Conditionl format for 3 cells Skipping the center cell
  • Mark
Replies
3
Views
435
Pete_UK
P
Back
Top