Microsoft Excel Worksheet Functions

Post thread
D
Test 2 numbers
  • Dave
Replies
18
Views
590
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
379
Gord Dibben
G
M
count with multiple critirea
  • MANYHEADACHES
Replies
4
Views
378
Shane Devenshire
S
H
Countif(and
  • Help with Countif(and
Replies
7
Views
632
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
441
xlmate
X
W
userform date issue
  • Woodi2
Replies
4
Views
396
Woodi2
W
M
The If function
  • Matt
Replies
4
Views
555
Pete_UK
P
D
Using SUMPRODUCT, 3 variables, 2 types of data in 1 column
  • Dana M
Replies
3
Views
548
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
582
Lynz1976
L
R
Referenced cell change when row is blank
  • Read
Replies
1
Views
381
muddan madhu
M
N
Error message
  • Noepie
Replies
7
Views
389
Noepie
N
A
Formula - assign a cell to show the next
  • ash3154
Replies
6
Views
380
ash3154
A
S
SUMIF FUNCTION works in all cells but those related to one account
  • Skyhawk
Replies
4
Views
451
T. Valko
T
R
Count Unique Numbers if Names Match
  • ryguy7272
Replies
4
Views
449
Ashish Mathur
A
K
SUMIF function
  • Kathryn
Replies
7
Views
427
Elkar
E
K
Question on which function to use
  • kurchian
Replies
2
Views
369
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
508
Ashish Mathur
A
C
Formula Help
  • Curtis
Replies
1
Views
267
Paul
P
M
Compare and then copy cell to separate worksheet
  • Matt
Replies
1
Views
454
Pete_UK
P
T
Double (triple?) Index Lookup
  • thedr9wningman
Replies
6
Views
967
Max
M
I
Using lookup functions with conditions and constantly changing dat
  • (-) Ions
Replies
10
Views
652
Max
M
K
finding multiple code dates for multiple item number
  • kmc
Replies
2
Views
442
Glenn
G
T
How do I use countif like sumif ie (range,criteria,count_range)
  • tmarie
Replies
1
Views
626
T. Valko
T
A
sum function
  • angie
Replies
3
Views
280
Marcelo
M
C
VB Code
  • chrisnsmith
Replies
6
Views
602
Don Guillett
D
T
dividng numbers using the sumif function
  • tiare1021
Replies
2
Views
427
Mike H
M
C
My current formulas in documents have quit working
  • Clark
Replies
1
Views
375
Mike H
M
P
Option Buttons, Forms Control, Excel 2007 - 3 options
  • Paula
Replies
6
Views
548
Paula
P
W
Getting rid of VLOOKUP N/A
  • WA
Replies
3
Views
485
WA
W
E
Function to find truncated entries?
  • EllenM
Replies
3
Views
347
EllenM
E
Y
calculated celles according to more then 1 condition
  • -yuval
Replies
5
Views
365
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
417
Shane Devenshire
S
S
Date functions and #value!
  • SafetyIntern
Replies
3
Views
349
SelfTaughExcelJunkie
S
M
EXcel problem
  • MicrosoftBob
Replies
2
Views
384
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
602
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
305
Roger Govier
R
L
newbie
  • lena
Replies
5
Views
359
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
408
Pete_UK
P
Back
Top