Microsoft Excel Worksheet Functions

Filters

B

Help Please-Counting Filtered Rows

baz
Dec 16, 2005

Replies: 2

Views: 19K

Dec 16, 2005

baz

B

G

Separate records from Vertical to Horizontal

Guest
Dec 16, 2005

Replies: 3

Views: 176K

Dec 16, 2005

Gord Dibben

G

O

Depriciation Matrix

Octavee Uhl
Dec 16, 2005

Replies: 1

Views: 81K

Dec 16, 2005

Guest

G

G

Calcualted Fields in Pivot Tables

Guest
Dec 16, 2005

Replies: 1

Views: 158K

Dec 16, 2005

Guest

G

M

Nett Date Calculation

Midas NDT Sales
Dec 16, 2005

Replies: 4

Views: 90K

Dec 16, 2005

Midas NDT Sales

M

G

how to cover the formula

Guest
Dec 16, 2005

Replies: 7

Views: 98K

Dec 16, 2005

Gord Dibben

G

G

TOTAL NUMBER OF ENTRIES

Guest
Dec 16, 2005

Replies: 5

Views: 324K

Dec 16, 2005

Gord Dibben

G

G

How to lock a row in a spreadsheet based on the value in a cell

Guest
Dec 15, 2005

Replies: 3

Views: 77K

Dec 16, 2005

Debra Dalgleish

D

G

Guest
Dec 16, 2005

Replies: 2

Views: 174K

Dec 16, 2005

Dave Peterson

D

G

how to sort date in excel

Guest
Dec 16, 2005

Replies: 2

Views: 59K

Dec 16, 2005

Guest

G

G

Use networkdays INCLUDE weekends, Exclude holidays

Guest
Dec 16, 2005

Replies: 4

Views: 488K

Dec 16, 2005

Guest

G

P

Graphing error using Time as X axis.

pete3589
Dec 16, 2005

Replies: 2

Views: 262K

Dec 16, 2005

pete3589

P

G

Guest
Dec 15, 2005

Replies: 5

Views: 135K

Dec 16, 2005

Peo Sjoblom

P

G

Pivot table displays data differently, Excel 2003

Guest
Oct 24, 2005

Replies: 1

Views: 127K

Dec 16, 2005

Guest

G

G

What is the formula for blinking a cell with a value in Excel

Guest
Dec 16, 2005

Replies: 2

Views: 114K

Dec 16, 2005

Guest

G

G

How do I change the font color based on results of an IF stateme

Guest
Dec 16, 2005

Replies: 2

Views: 311K

Dec 16, 2005

Guest

G

G

How to auto activate macro when file open ?

Guest
Dec 16, 2005

Replies: 1

Views: 153K

Dec 16, 2005

Ken Johnson

K

G

Formula Needed...

Guest
Nov 16, 2005

Replies: 15

Views: 661K

Dec 16, 2005

[email protected]

B

P

lookup

pgc
Dec 5, 2005

Replies: 2

Views: 56K

Dec 16, 2005

pgc

P

G

conditional data validation

Guest
Dec 15, 2005

Replies: 6

Views: 370K

Dec 16, 2005

Guest

G

G

How do I convert Meters to Feet and Inches?

Guest
Aug 16, 2005

Replies: 7

Views: 983K

Dec 16, 2005

Niek Otten

N

S

Look for values on another sheet.

Spanky77
Dec 16, 2005

Replies: 1

Views: 114K

Dec 16, 2005

Norman Jones

N

G

Excel Formula - Reg

Guest
Dec 16, 2005

Replies: 1

Views: 57K

Dec 16, 2005

Max

M

G

Guest
Dec 15, 2005

Replies: 7

Views: 238K

Dec 16, 2005

Guest

G

G

Formula for determing average based on weighting

Guest
Dec 16, 2005

Replies: 2

Views: 54K

Dec 16, 2005

Guest

G

G

If Statement and two metrics

Guest
Dec 12, 2005

Replies: 5

Views: 193K

Dec 16, 2005

Guest

G

R

Help with Formula,reulsts show in Function, not in Spreadsheet?

Rowan Drummond
Dec 16, 2005

Replies: 1

Views: 77K

Dec 16, 2005

Deb Pingel

D

G

How to use distribution functions?

gpktm
Dec 16, 2005

Replies: 3

Views: 58K

Dec 16, 2005

gpktm

G

C

Carl Hilton
Dec 15, 2005

Replies: 3

Views: 71K

Dec 16, 2005

Max

M

G

how to write function to find max deviation from specific number .

Guest
Dec 16, 2005

Replies: 2

Views: 234K

Dec 16, 2005

Jerry W. Lewis

J

G

Guest
Dec 15, 2005

Replies: 5

Views: 78K

Dec 16, 2005

wjohnson

W

G

Statistical smoothing a range of numbers - match average more clos

Guest
Dec 15, 2005

Replies: 1

Views: 45K

Dec 16, 2005

Mike Middleton

M

B

vlookup:same lookup_value, different returns

Biff
Dec 15, 2005

Replies: 2

Views: 118K

Dec 16, 2005

javino

J

G

Look for match on two worksheets

Guest
Dec 15, 2005

Replies: 2

Views: 72K

Dec 16, 2005

Guest

G

G

vlookup does not work between 71% to 79% refernceing roundup numb

Guest
Dec 15, 2005

Replies: 4

Views: 77K

Dec 15, 2005

Guest

G

G

Guest
Dec 15, 2005

Replies: 3

Views: 93K

Dec 15, 2005

Dave Peterson

D

G

need to count/average if...

Guest
Dec 15, 2005

Replies: 6

Views: 148K

Dec 15, 2005

Guest

G

G

How to run a macro as soon a a workbook (.xls) is opened?

Guest
Dec 15, 2005

Replies: 1

Views: 64K

Dec 15, 2005

Rowan Drummond

R

G

Macro to open workbook and copy and paste values in to orig workbo

Guest
Dec 15, 2005

Replies: 1

Views: 214K

Dec 15, 2005

Rowan Drummond

R

G

Data in cell to reference a worksheet page

Guest
Dec 15, 2005

Replies: 2

Views: 74K

Dec 15, 2005

eklarsen

E

B

Using Index(A:A,.........)

Biff
Dec 15, 2005

Replies: 2

Views: 95K

Dec 15, 2005

Biff

B

G

How do I change one repeated word in the spreadsheet to another?

Guest
Dec 15, 2005

Replies: 5

Views: 195K

Dec 15, 2005

wjohnson

W

G

Creating lookup formulas for material cost spreadsheet

Guest
Dec 15, 2005

Replies: 5

Views: 163K

Dec 15, 2005

Gord Dibben

G

G

sumproduct with 0/blank cells

Guest
Dec 15, 2005

Replies: 4

Views: 407K

Dec 15, 2005

Biff

B

G

"Cumulative" column based on a pivot table sum column?

Guest
Dec 15, 2005

Replies: 2

Views: 139K

Dec 15, 2005

Guest

G

G

Auto-Filter Intermittently Disables

Guest
Dec 15, 2005

Replies: 1

Views: 49K

Dec 15, 2005

Pete

P

G

How do I keep border permenant in a worksheet template?

Guest
Dec 15, 2005

Replies: 3

Views: 48K

Dec 15, 2005

Gord Dibben

G

G

How do I protect hidden rows from being unhidden?

Guest
Dec 15, 2005

Replies: 5

Views: 226K

Dec 15, 2005

Gord Dibben

G

G

TAN different to a calculator? Please help would be appreciated lo

Guest
Dec 15, 2005

Replies: 5

Views: 416K

Dec 15, 2005

MrShorty

M

G

Excel formula-cell reference not working

Guest
Dec 14, 2005

Replies: 3

Views: 134K

Dec 15, 2005

Guest

G

You must log in or register to post here.

Top