Microsoft Excel Worksheet Functions

Filters

G

understanding dash dash in a excel formula

Guest
Oct 31, 2005

Replies: 2

Views: 180K

Oct 31, 2005

Guest

G

S

Return Numerical Label for LAST value Subtracted to reach Sum Target Value

Sam via OfficeKB.com
Oct 28, 2005

Replies: 17

Views: 1M

Oct 31, 2005

Ron Rosenfeld

R

G

different tables

Guest
Oct 31, 2005

Replies: 1

Views: 31K

Oct 31, 2005

Domenic

D

G

Referencing Corresponding Values

Guest
Oct 25, 2005

Replies: 8

Views: 100K

Oct 31, 2005

Domenic

D

R

Generate random numberes using reference to the other cell.

ramana
Oct 26, 2005

Replies: 7

Views: 777K

Oct 31, 2005

ramana

R

J

Cell reference problem

Jim Olsen
Oct 27, 2005

Replies: 4

Views: 155K

Oct 31, 2005

Jim Olsen

J

G

Need help with this function

Guest
Oct 28, 2005

Replies: 3

Views: 143K

Oct 31, 2005

Max

M

G

How to merge one cell from many workbooks to one cell on one work

Guest
Oct 30, 2005

Replies: 2

Views: 118K

Oct 31, 2005

Tom Jung

T

G

Separating names

Guest
Oct 30, 2005

Replies: 5

Views: 161K

Oct 31, 2005

Guest

G

G

How do I set a rule to add a number, but only if it is positive?

Guest
Oct 30, 2005

Replies: 6

Views: 151K

Oct 31, 2005

Guest

G

G

valid formula doesn't work in 2003 version

Guest
Oct 30, 2005

Replies: 1

Views: 44K

Oct 30, 2005

Peo Sjoblom

P

G

How do I show number of resources by hour in excel?

Guest
Oct 30, 2005

Replies: 4

Views: 216K

Oct 30, 2005

Bob Phillips

B

G

Guest
Oct 30, 2005

Replies: 1

Views: 66K

Oct 30, 2005

Ian

I

R

How to get a row consecutive from a sheet to another

rodante
Oct 28, 2005

Replies: 4

Views: 319K

Oct 30, 2005

rodante

R

G

calculating data

Guest
Oct 29, 2005

Replies: 6

Views: 221K

Oct 30, 2005

Niek Otten

N

N

Extracting specific data from a cell

Neil Bowen
Oct 30, 2005

Replies: 5

Views: 551K

Oct 30, 2005

Neil Bowen

N

G

Guest
Oct 30, 2005

Replies: 1

Views: 90K

Oct 30, 2005

Don Guillett

D

G

sorting master sheet messes up cells in other sheets linked to it

Guest
Oct 30, 2005

Replies: 1

Views: 131K

Oct 30, 2005

Max

M

G

link between sheets get messed when master sheet is sorted

Guest
Oct 30, 2005

Replies: 1

Views: 71K

Oct 30, 2005

Max

M

G

how do I prevent a RAND number from changing

Guest
Oct 30, 2005

Replies: 1

Views: 431K

Oct 30, 2005

Max

M

G

list generating

Guest
Oct 29, 2005

Replies: 1

Views: 48K

Oct 30, 2005

Max

M

G

how would you do A40-20 = aA20, the value 20 is in another cell

Guest
Oct 30, 2005

Replies: 1

Views: 116K

Oct 30, 2005

Niek Otten

N

L

3D Count in all worksheets

Louis.kk.lam
Oct 27, 2005

Replies: 2

Views: 92K

Oct 30, 2005

[email protected]

L

G

Need know what are valid SUMPRODUCTS arguments and functions

Guest
Oct 28, 2005

Replies: 2

Views: 29K

Oct 30, 2005

Aladin Akyurek

A

R

Display row number of the last value in a column

ramana
Oct 29, 2005

Replies: 4

Views: 540K

Oct 30, 2005

Biff

B

R

Count multiple data by date

Racorfrank
Oct 26, 2005

Replies: 3

Views: 215K

Oct 30, 2005

Biff

B

G

how to calulate time in hours cbetween two different dates?

Guest
Oct 29, 2005

Replies: 3

Views: 228K

Oct 30, 2005

Mladen_Dj

M

C

Need No Blanks List based on two conditions

Chaturanga
Oct 28, 2005

Replies: 9

Views: 91K

Oct 30, 2005

Stefano Condotta

S

G

Multiple IF functions

Guest
Oct 30, 2005

Replies: 2

Views: 165K

Oct 30, 2005

Guest

G

P

PV of uneven stream of cash flows

PJF
Oct 29, 2005

Replies: 8

Views: 608K

Oct 30, 2005

Bruno Campanini

B

P

Help with PV calculations

PJF
Oct 29, 2005

Replies: 2

Views: 167K

Oct 30, 2005

PJF

P

G

Formulas and/or formating

Guest
Oct 29, 2005

Replies: 4

Views: 140K

Oct 29, 2005

Guest

G

G

Chart Help Needed

Guest
Oct 29, 2005

Replies: 1

Views: 131K

Oct 29, 2005

Don Guillett

D

G

COUNT.IF, how to include single cells

Guest
Oct 29, 2005

Replies: 8

Views: 105K

Oct 29, 2005

Guest

G

G

How do I write a formula in excel that calculates payroll?

Guest
Oct 29, 2005

Replies: 3

Views: 303K

Oct 29, 2005

Guest

G

M

How to LOOKUP the last value in a column on another worksheet?

Mark Dvorkin
Oct 29, 2005

Replies: 5

Views: 282K

Oct 29, 2005

Mark Dvorkin

M

P

A simple listing desire...

Push Latency
Oct 26, 2005

Replies: 5

Views: 92K

Oct 29, 2005

Push Latency

P

G

if function constains date

Guest
Oct 29, 2005

Replies: 3

Views: 82K

Oct 29, 2005

Guest

G

G

Calculating the number of cells containing dates within the last m

Guest
Oct 29, 2005

Replies: 5

Views: 124K

Oct 29, 2005

Guest

G

G

IF(<criterion across sheets>,1,0)?

Guest
Oct 28, 2005

Replies: 5

Views: 108K

Oct 29, 2005

Aladin Akyurek

A

T

tcpteacher
Oct 29, 2005

Replies: 2

Views: 202K

Oct 29, 2005

Don Guillett

D

B

Strip text before character

bell23
Oct 28, 2005

Replies: 3

Views: 205K

Oct 29, 2005

Bob Phillips

B

H

#REF!

Helen
Oct 25, 2005

Replies: 3

Views: 124K

Oct 29, 2005

Robert McCurdy

R

G

Last cell used in SUM IF formula

Guest
Oct 26, 2005

Replies: 4

Views: 381K

Oct 29, 2005

Aladin Akyurek

A

R

How to Specify a range using another cell vale instead of row number

ramana
Oct 29, 2005

Replies: 1

Views: 246K

Oct 29, 2005

Aladin Akyurek

A

G

How do I multiply a unit measurement?

Guest
Oct 26, 2005

Replies: 3

Views: 62K

Oct 29, 2005

Guest

G

J

Project Management Schedule

JPriest
Oct 28, 2005

Replies: 1

Views: 76K

Oct 29, 2005

goober

G

G

Is there an Excel function to shade cells?

Guest
Oct 29, 2005

Replies: 2

Views: 109K

Oct 29, 2005

David McRitchie

D

G

rows 1-2 missing from excel worksheet

Guest
Oct 28, 2005

Replies: 1

Views: 119K

Oct 29, 2005

Guest

G

G

Formula help for complex formatting.

Guest
Oct 28, 2005

Replies: 6

Views: 121K

Oct 29, 2005

Max

M

You must log in or register to post here.

Top