Microsoft Excel Worksheet Functions

Sort by: Replies Descending

S

Convert variable #'s in a gen. format to a # that can be used w/ma

Steve
Feb 4, 2010

2

Replies: 29

Views: 1K

Feb 9, 2010

T. Valko

T

G

Searching for a value in an Array

Guest
Aug 20, 2006

2

Replies: 29

Views: 900

Aug 25, 2006

Guest

G

G

How do I caluclate an Annual Percentage Rate in Excel?

Guest
Feb 8, 2005

2

Replies: 29

Views: 2K

Jul 27, 2007

joeu2004

J

H

Color Cells Summing

HANYANA
Dec 30, 2006

2

Replies: 29

Views: 805

Jan 10, 2007

Max

M

S

Cell validation

Sai Krishna
May 22, 2008

2

Replies: 29

Views: 1K

Jan 7, 2012

isabelle

I

G

Using Countif across multiple sheets

Guy Hoffman
Jan 9, 2004

2

Replies: 29

Views: 6K

Jan 26, 2004

Harlan Grove

H

A

Insert Cell Name of a value that matches a MAX function

Al Rios
May 31, 2004

2

Replies: 29

Views: 825

May 31, 2004

Al Rios

A

G

Counting odd & even #s

Guest
Sep 6, 2007

2

Replies: 29

Views: 1K

Sep 7, 2007

Ron Rosenfeld

R

J

MYSTERY: NESTED INDEX AND MATCH FUNCTIONS

JingleRock
Mar 11, 2009

2

Replies: 29

Views: 1K

Mar 14, 2009

T. Valko

T

N

natei6
Mar 15, 2004

2

Replies: 29

Views: 744

Mar 18, 2004

natei6

N

T

Significance of =+ in formulas

tro34
Mar 24, 2004

2

Replies: 29

Views: 928

Mar 26, 2004

Bob Phillips

B

G

NETWORKDAYS calc with 3 columns of dates

Guest
Aug 10, 2006

2

Replies: 28

Views: 891

Aug 18, 2006

Bob Phillips

B

B

Count Unique Values in 1 Column based on Date Range in another Column

Brian
May 16, 2009

2

Replies: 28

Views: 4K

May 17, 2009

Brian

B

G

Guest
Jun 23, 2006

2

Replies: 28

Views: 716

Jul 15, 2006

CLR

C

G

extracting numbers

Guest
Feb 5, 2006

2

Replies: 28

Views: 881

Feb 9, 2006

Ron Rosenfeld

R

V

vidguru
Aug 9, 2008

2

Replies: 27

Views: 760

Aug 12, 2008

Rick Rothstein \(MVP - VB\)

R

G

Return Unquie Values

Guest
Aug 3, 2007

2

Replies: 27

Views: 824

Aug 10, 2007

Harlan Grove

H

D

multiple worksheet help

darkbearpooh1
Feb 10, 2006

2

Replies: 27

Views: 850

Feb 17, 2006

darkbearpooh1

D

G

Is it possible?

Guest
Dec 9, 2005

2

Replies: 27

Views: 781

Sep 18, 2006

Gord Dibben

G

R

Counting Unique Values

RJL0323
Feb 16, 2006

2

Replies: 27

Views: 1K

Feb 19, 2006

Aladin Akyurek

A

H

#VALUE about function Find

hui
Sep 11, 2006

2

Replies: 27

Views: 731

Sep 12, 2006

hui

H

G

Array index, match problem

Guest
Aug 15, 2005

2

Replies: 27

Views: 1K

Aug 21, 2005

Alan Beban

A

G

assigning a unique value

Guest
May 4, 2005

2

Replies: 27

Views: 1K

May 7, 2005

Harlan Grove

H

G

where text wraps in a cell, how can the row height be auto set?

Guest
May 3, 2006

2

Replies: 27

Views: 1K

Jun 5, 2010

Gord Dibben

G

S

MATCH Multiple Criteria & Return Previous / Penultimate Match

Sam via OfficeKB.com
Sep 25, 2007

2

Replies: 27

Views: 2K

Oct 6, 2007

Sam via OfficeKB.com

S

B

Rule of 75 Retirement Calculation

BAD
Oct 17, 2008

2

Replies: 27

Views: 8K

Oct 21, 2008

~L

L

B

Deleting by date automatically

Bryan De-Lara
Oct 24, 2008

2

Replies: 27

Views: 927

Jan 23, 2009

Bryan De-Lara

B

G

VBA Code; need linked cells to change color if condition met

Guest
Aug 31, 2007

2

Replies: 26

Views: 1K

Sep 13, 2007

Dave Peterson

D

A

Find amount in row.

art
May 10, 2009

2

Replies: 26

Views: 855

May 11, 2009

T. Valko

T

G

Find value in array

Guest
Sep 28, 2006

2

Replies: 26

Views: 870

Jan 30, 2007

Harlan Grove

H

D

if formula #value

dan dungan
Nov 14, 2008

2

Replies: 26

Views: 719

Nov 19, 2008

Harlan Grove

H

G

Excel 2003 SP2 computes the power of a negative number wrong.

Guest
Oct 22, 2006

2

Replies: 26

Views: 961

Oct 27, 2006

Roger Govier

R

C

How to time-limit an Excel file installation

Colin Hayes
Nov 30, 2007

2

Replies: 26

Views: 6K

Jan 6, 2008

Harlan Grove

H

G

ALTERNATIVE TO SUMPRODUCT NEEDED

Guest
Aug 1, 2007

2

Replies: 26

Views: 987

Aug 2, 2007

Guest

G

J

INT defect: Please try this on 2007 for me

JoeU2004
Oct 10, 2009

2

Replies: 26

Views: 1K

Oct 16, 2009

Charles Williams

C

G

Average of top 3 numbers.

Guest
Nov 27, 2005

2

Replies: 26

Views: 697

Nov 28, 2005

Guest

G

E

Esradekan
Aug 28, 2008

2

Replies: 26

Views: 1K

Aug 31, 2008

Don Guillett

D

G

How do I link cells from one excel worksheet to another?

Guest
Oct 5, 2005

2

Replies: 26

Views: 4K

Mar 1, 2010

Buckeroo

B

G

REPORTING unique values

Guest
Nov 5, 2007

2

Replies: 26

Views: 800

Jan 25, 2008

Blue Max

B

C

Wat formula shuld i use to find the details in the cell?

Cloud Strife
Jul 6, 2009

2

Replies: 25

Views: 730

Jul 8, 2009

Glenn

G

B

Determining the Sunday date of the third "full" weekend of a month

Bob
Sep 8, 2009

2

Replies: 25

Views: 1K

Sep 13, 2009

Bernd P

B

A

Formula than understands midnight?

Auric__
Apr 24, 2014

2

Replies: 25

Views: 2K

Apr 26, 2014

Auric__

A

G

How can I change the tab but keep the row and column constant when

Guest
Jun 19, 2007

2

Replies: 25

Views: 1K

Jun 20, 2007

Bernie Deitrick

B

A

Andreas
Jul 8, 2006

2

Replies: 25

Views: 1K

Jul 25, 2006

Guest

G

G

Excel function for tables

Guest
Feb 3, 2004

2

Replies: 25

Views: 2K

Feb 20, 2004

Guest

G

W

Name - relative reference doesn't calculate

Werner Rohrmoser
Jan 28, 2008

2

Replies: 25

Views: 1K

Jan 29, 2008

Lori

L

G

Sumproduct issues

Guest
Nov 17, 2006

2

Replies: 25

Views: 763

Jun 3, 2009

RagDyeR

R

C

Connie Martin
Jun 22, 2009

2

Replies: 24

Views: 820

Jun 26, 2009

Don Guillett

D

G

FIND LAST CELL WITH DATA

Guest
Sep 7, 2006

2

Replies: 24

Views: 803

Sep 17, 2009

T. Valko

T

G

Replace =RAND() with =ABS(RAND())

Guest
Dec 7, 2003

2

Replies: 24

Views: 2K

Dec 11, 2003

Harlan Grove

H