Microsoft Excel Worksheet Functions

Sort by: Replies Descending

G

Guest
Nov 8, 2004

2

Replies: 22

Views: 836

Nov 9, 2004

Guest

G

S

1st Monday of a month in date range??

scwilly
Apr 24, 2006

2

Replies: 22

Views: 912

Apr 26, 2006

scwilly

S

R

Using COUNTIF on multiple fields

robotman
Sep 19, 2006

2

Replies: 22

Views: 751

Sep 28, 2006

Don Guillett

D

C

how to count if cell "contains" a word

cjlatta
Jul 11, 2008

2

Replies: 22

Views: 2K

Jul 15, 2008

Rick Rothstein \(MVP - VB\)

R

R

VLOOKUP with 2 Criterias

Roni
Apr 23, 2005

2

Replies: 22

Views: 1K

Apr 26, 2005

Aladin Akyurek

A

S

Return Unique Consecutive Duplicate Values across Single Row

Sam via OfficeKB.com
Feb 4, 2007

2

Replies: 22

Views: 1K

Feb 6, 2007

Sam via OfficeKB.com

S

G

Can Excel automatically insert current date in a cell?

Guest
May 4, 2005

2

Replies: 22

Views: 21K

Mar 12, 2014

[email protected]

R

T

Help a teacher??

Tim K.
Aug 21, 2004

2

Replies: 22

Views: 924

Aug 23, 2004

Tim K.

T

S

Formula to rid of DIV/o!

Sean
Apr 29, 2004

2

Replies: 22

Views: 1K

Aug 19, 2004

Frank Kabel

F

B

Auto Populate from a Mater List into Sub Sheets

Banker
Jan 11, 2008

2

Replies: 22

Views: 2K

Feb 28, 2012

Cimjet

C

L

luckyt22
Jun 14, 2005

2

Replies: 22

Views: 683

Jun 16, 2005

luckyt22

L

D

SUMIF(AND) FUNCTION

Dave Gremaud
May 26, 2004

2

Replies: 22

Views: 904

Oct 28, 2004

Govind

G

G

Adding Random Numbers

Gary''s Student
Jun 13, 2008

2

Replies: 22

Views: 1K

Jun 17, 2008

joeu2004

J

G

How can I find the greatest possible sum within 12 months? A newbie...

Guest
Sep 8, 2006

2

Replies: 22

Views: 877

Oct 1, 2006

[email protected]

S

B

Bob Vance
Jan 17, 2004

2

Replies: 22

Views: 702

Jan 19, 2004

Bob Vance

B

L

LEB
Mar 5, 2004

2

Replies: 22

Views: 802

Mar 6, 2004

Dave Peterson

D

G

formula for a pension

Guest
Dec 7, 2005

2

Replies: 22

Views: 1K

Dec 10, 2005

Guest

G

A

countifs - what is instead in excel 2000???

amir2000
May 19, 2008

2

Replies: 22

Views: 3K

Jun 13, 2008

Harlan Grove

H

B

alpha numeric data validation for excel

brdoel
Nov 28, 2008

2

Replies: 22

Views: 6K

Nov 30, 2008

T. Valko

T

G

Points Ranking Formulas

Guest
Oct 18, 2005

2

Replies: 22

Views: 835

Nov 3, 2005

Max

M

G

lock cell based on a condition

Guest
Jun 19, 2007

2

Replies: 22

Views: 1K

Jun 25, 2007

Guest

G

D

Excel, two text fields equal the number 1 per occurance

Don McLean
May 13, 2009

2

Replies: 22

Views: 797

May 14, 2009

Harlan Grove

H

R

Excel 2003: RAND and RANDBETWEEN functions

Rita Nikas [MSFT]
Dec 20, 2003

2

Replies: 22

Views: 2K

Feb 14, 2004

Norman Harker

N

G

count unique with mulitple criteria

Guest
Oct 6, 2006

2

Replies: 22

Views: 1K

Oct 13, 2006

Don Guillett

D

A

Formulas in 2007 not working in 2003

Andrew
Jan 24, 2008

2

Replies: 22

Views: 977

Jan 28, 2008

Ron Rosenfeld

R

G

Averages and Counts from different columns

Guest
May 5, 2005

2

Replies: 21

Views: 793

May 6, 2005

Guest

G

S

Average a list with high and low ignored

Shu of AZ
Feb 6, 2008

2

Replies: 21

Views: 2K

Feb 7, 2008

T. Valko

T

B

days of the week formulas

Bob
Mar 6, 2008

2

Replies: 21

Views: 839

Mar 7, 2008

Bob

B

A

Worksheet Naming

Andy Sandford
Feb 15, 2004

2

Replies: 21

Views: 752

Feb 15, 2004

Tom Ogilvy

T

G

Guest
Jun 7, 2005

2

Replies: 21

Views: 713

Jun 9, 2005

Guest

G

G

The 4th column D to be filler.

Guest
Aug 6, 2007

2

Replies: 21

Views: 787

Aug 8, 2007

Guest

G

S

Ignoring Blank value in a drop down list

shail
Jul 25, 2006

2

Replies: 21

Views: 801

Aug 28, 2006

shail

S

M

SumIf query ...

muchacho
Jun 26, 2006

2

Replies: 21

Views: 745

Jun 28, 2006

muchacho

M

G

Sum totals based on product name

Guest
Oct 17, 2006

2

Replies: 21

Views: 999

May 28, 2008

T. Valko

T

S

sumif and translate annual hours into weekly quarter hours

se7098
Oct 10, 2008

2

Replies: 21

Views: 1K

Oct 11, 2008

T. Valko

T

D

count colored cells?

DKY
Jan 10, 2006

2

Replies: 21

Views: 1K

Jan 19, 2006

[email protected]

S

W

Capture lines with entries?

Wind54Surfer
Oct 3, 2009

2

Replies: 21

Views: 1K

Oct 4, 2009

Wind54Surfer

W

G

Harlan Grove PULL Code Help Please

Guest
Mar 13, 2007

2

Replies: 21

Views: 5K

Dec 31, 2010

Pete_UK

P

C

Civette
Jul 9, 2008

2

Replies: 21

Views: 885

Jul 10, 2008

Pete_UK

P

S

COUNTIF problem with NOW()

Spreadsheet
Jun 23, 2006

2

Replies: 21

Views: 797

Jun 26, 2006

SteveG

S

G

Need Period After Initials

Guest
May 14, 2007

2

Replies: 21

Views: 2K

May 15, 2007

Guest

G

L

Excel 2003 - Help writing a formula to get time (w, d, h, m)

Lady_Aleena
Jul 17, 2009

2

Replies: 21

Views: 984

Jul 20, 2009

Glenn

G

G

Copy cell format to cell on another worksht and update automatical

Guest
May 6, 2005

2

Replies: 21

Views: 973

May 19, 2005

Guest

G

J

Jakobshavn Isbrae
Jun 22, 2008

2

Replies: 21

Views: 753

Jun 22, 2008

Harlan Grove

H

G

how to count easily

Guest
Dec 30, 2006

2

Replies: 21

Views: 910

Jan 1, 2007

Guest

G

B

Using VLOOKUP with a reference to a different file...

beeblemonster
Aug 13, 2008

2

Replies: 21

Views: 3K

Aug 14, 2008

Peo Sjoblom

P

M

mrbob16
Nov 21, 2008

2

Replies: 21

Views: 1K

Dec 22, 2008

Spiky

S

G

How can I extract the second half of addition ?

Gilbert DE CEULAER
Sep 28, 2008

2

Replies: 21

Views: 761

Sep 28, 2008

Bernd P

B

E

Bob P. and Roger G. --> IF(and(...IF(OR( vs. IF(Boolean

Epinn
Nov 16, 2006

2

Replies: 21

Views: 686

Nov 19, 2006

Epinn

E

O

Divide by the minimum non-zero number in a range of cells

Opus
Jun 13, 2009

2

Replies: 21

Views: 2K

Jun 14, 2009

JoeU2004

J