Microsoft Excel Worksheet Functions

Post thread
D
Test 2 numbers
  • Dave
Replies
18
Views
594
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
388
Gord Dibben
G
M
count with multiple critirea
  • MANYHEADACHES
Replies
4
Views
380
Shane Devenshire
S
H
Countif(and
  • Help with Countif(and
Replies
7
Views
648
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
446
xlmate
X
W
userform date issue
  • Woodi2
Replies
4
Views
416
Woodi2
W
M
The If function
  • Matt
Replies
4
Views
591
Pete_UK
P
D
Using SUMPRODUCT, 3 variables, 2 types of data in 1 column
  • Dana M
Replies
3
Views
569
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
596
Lynz1976
L
R
Referenced cell change when row is blank
  • Read
Replies
1
Views
389
muddan madhu
M
N
Error message
  • Noepie
Replies
7
Views
398
Noepie
N
A
Formula - assign a cell to show the next
  • ash3154
Replies
6
Views
395
ash3154
A
S
SUMIF FUNCTION works in all cells but those related to one account
  • Skyhawk
Replies
4
Views
470
T. Valko
T
R
Count Unique Numbers if Names Match
  • ryguy7272
Replies
4
Views
466
Ashish Mathur
A
K
SUMIF function
  • Kathryn
Replies
7
Views
439
Elkar
E
K
Question on which function to use
  • kurchian
Replies
2
Views
383
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
537
Ashish Mathur
A
C
Formula Help
  • Curtis
Replies
1
Views
275
Paul
P
M
Compare and then copy cell to separate worksheet
  • Matt
Replies
1
Views
463
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
698
Max
M
K
finding multiple code dates for multiple item number
  • kmc
Replies
2
Views
447
Glenn
G
T
How do I use countif like sumif ie (range,criteria,count_range)
  • tmarie
Replies
1
Views
632
T. Valko
T
A
sum function
  • angie
Replies
3
Views
282
Marcelo
M
C
VB Code
  • chrisnsmith
Replies
6
Views
618
Don Guillett
D
T
dividng numbers using the sumif function
  • tiare1021
Replies
2
Views
443
Mike H
M
C
My current formulas in documents have quit working
  • Clark
Replies
1
Views
376
Mike H
M
P
Option Buttons, Forms Control, Excel 2007 - 3 options
  • Paula
Replies
6
Views
553
Paula
P
W
Getting rid of VLOOKUP N/A
  • WA
Replies
3
Views
489
WA
W
E
Function to find truncated entries?
  • EllenM
Replies
3
Views
356
EllenM
E
Y
calculated celles according to more then 1 condition
  • -yuval
Replies
5
Views
375
xlmate
X
J
"go to" "blanks" after using a formula
  • jhnnyboy247
Replies
2
Views
350
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
425
Shane Devenshire
S
S
Date functions and #value!
  • SafetyIntern
Replies
3
Views
352
SelfTaughExcelJunkie
S
M
EXcel problem
  • MicrosoftBob
Replies
2
Views
385
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
634
Newbie
N
D
Calculating ratios: Is there a formula that can do this?
  • dshadrock
Replies
2
Views
476
Shane Devenshire
S
M
Find and replace dilemma
  • mismose
Replies
3
Views
305
mismose
M
P
Formula please
  • Peta
Replies
6
Views
321
Roger Govier
R
L
newbie
  • lena
Replies
5
Views
366
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
414
Pete_UK
P
Back
Top