Microsoft Excel Worksheet Functions

Sort by: Replies Descending

G

How do I alphabetize a column but also have the corresponding cells move with the sort?

Guest
Feb 15, 2004

2

Replies: 24

Views: 3K

Feb 15, 2004

Gord Dibben

G

T

tomek gomek
Jul 25, 2007

2

Replies: 24

Views: 691

Jul 28, 2007

Stan Brown

S

M

Lookup and highlight matched cell with colours

Mindee
Mar 5, 2004

2

Replies: 24

Views: 1K

Mar 17, 2004

Bob Phillips

B

D

Conitional copying of a serie of rows from one spreadsheet to another

david
Jul 1, 2006

2

Replies: 24

Views: 925

Jul 6, 2006

Guest

G

J

How do I sum up random cells

Josh W
Apr 25, 2008

2

Replies: 24

Views: 7K

Feb 28, 2010

Ashish Mathur

A

G

how do I email amacro?

Guest
Aug 7, 2006

2

Replies: 24

Views: 737

Aug 9, 2006

Guest

G

V

eliminating matched records!

via135 via OfficeKB.com
Nov 12, 2006

2

Replies: 24

Views: 875

Nov 19, 2006

Roger Govier

R

G

How to define and select the last (bottom) number in a column?

Guest
Nov 2, 2007

2

Replies: 24

Views: 721

Nov 5, 2007

T. Valko

T

G

Extracting a numbers from a text string

Guest
Feb 26, 2007

2

Replies: 24

Views: 1K

Feb 27, 2007

Guest

G

L

Macro to apply parsing rules for strings and list the substrings

Luciano Paulino da Silva
Apr 15, 2009

2

Replies: 24

Views: 1K

May 3, 2009

Ron Rosenfeld

R

G

Countif funtion

Guest
Jan 13, 2007

2

Replies: 24

Views: 752

Nov 16, 2008

T. Valko

T

G

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

Guest
Dec 7, 2003

2

Replies: 24

Views: 2K

Dec 11, 2003

Harlan Grove

H

B

Bob
Feb 5, 2004

2

Replies: 24

Views: 789

Feb 6, 2004

Harlan Grove

H

C

Connie Martin
Jun 22, 2009

2

Replies: 24

Views: 882

Jun 26, 2009

Don Guillett

D

G

Extracting part of Text from one cell to another

Guest
Aug 20, 2006

2

Replies: 24

Views: 1K

Aug 21, 2006

Ron Rosenfeld

R

P

VBA range selection question

Pete
Apr 28, 2011

2

Replies: 24

Views: 2K

May 10, 2011

joeu2004

J

D

Average If (Value between 1 and 100)

DAI
Nov 25, 2006

2

Replies: 24

Views: 3K

Nov 28, 2006

Guest

G

G

cannot enable redo-undo function

Guest
May 30, 2007

2

Replies: 24

Views: 1K

Aug 10, 2007

Dave Peterson

D

S

SUMPRODUCT - 2 Criteria

Sam via OfficeKB.com
Feb 9, 2007

2

Replies: 23

Views: 1K

Feb 10, 2007

Sam via OfficeKB.com

S

G

Determine if a number is prime

Guest
Apr 21, 2004

2

Replies: 23

Views: 1K

Apr 22, 2004

Vasant Nanavati

V

S

Return SEARCHED Column Number of Numeric Label and Value

Sam via OfficeKB.com
Jan 12, 2006

2

Replies: 23

Views: 1K

Jan 30, 2006

Sam via OfficeKB.com

S

E

Help with IF function please 03.08.08

Essjay
Mar 8, 2008

2

Replies: 23

Views: 769

Mar 12, 2008

Essjay

E

G

Help please, IF statement/SUMIF statement

Guest
Jan 7, 2005

2

Replies: 23

Views: 1K

Jan 11, 2005

JulieD

J

G

How can I print a worksheet excluding blank rows?

Guest
Aug 22, 2006

2

Replies: 23

Views: 937

Aug 23, 2006

Don Guillett

D

C

Augmenting an integer in a column to reflect duplicates in another

Colin Hayes
Jun 9, 2014

2

Replies: 23

Views: 2K

Jun 12, 2014

Colin Hayes

C

I

next to impossible

IF function incompetent
Feb 27, 2008

2

Replies: 23

Views: 808

Feb 27, 2008

IF function incompetent

I

C

Difficult Average Function

Connie Martin
Oct 5, 2008

2

Replies: 23

Views: 704

Oct 5, 2008

T. Valko

T

E

Epinn
Oct 10, 2006

2

Replies: 23

Views: 711

Oct 16, 2006

Epinn

E

G

Excel Date Format

Guest
Oct 21, 2006

2

Replies: 23

Views: 788

Oct 26, 2006

Bob Phillips

B

G

Vlookup "Value Not Available" (#N/A) Error

Guest
Apr 24, 2006

2

Replies: 23

Views: 2K

Mar 16, 2007

KL

K

N

DATE() Month in Letter NOT Number

Neon520
Jan 14, 2008

2

Replies: 23

Views: 788

Jan 15, 2008

T. Valko

T

G

find top 25 codes

Guest
Oct 29, 2004

2

Replies: 23

Views: 942

Nov 1, 2004

Guest

G

G

Find data in one table from another.

Guest
Jan 20, 2006

2

Replies: 23

Views: 792

Jan 22, 2006

Guest

G

R

Function to find the address of a cell

Ron Rosenfeld
Dec 8, 2005

2

Replies: 23

Views: 689

Dec 11, 2005

Mike H

M

A

Calculating age of death

Annie
Feb 21, 2008

2

Replies: 23

Views: 2K

Mar 4, 2011

Konczér, Tamás

K

S

Formula Function

SM_NCSW
Oct 24, 2008

2

Replies: 23

Views: 903

Oct 28, 2008

Ron Rosenfeld

R

S

Urgent help needed!

skarbanan
Dec 26, 2005

2

Replies: 23

Views: 743

Dec 30, 2005

Biff

B

L

Removing non Work Hours from Excel calculation

lindaho98
Mar 9, 2006

2

Replies: 23

Views: 829

Mar 11, 2006

daddylonglegs

D

M

Moving Info from onw sheet to another

Mike
Jan 9, 2008

2

Replies: 23

Views: 764

Jan 10, 2008

Mike

M

T

data in X:XX format

telefono
Sep 1, 2003

2

Replies: 23

Views: 1K

Sep 5, 2003

telefono

T

G

How to calculate "number of months" between two given date?

Guest
Apr 12, 2006

2

Replies: 23

Views: 1K

Apr 17, 2006

John James

J

T

Trev
Oct 10, 2009

2

Replies: 23

Views: 864

Oct 12, 2009

Jacob Skaria

J

L

unions, intersections or array constants

Loadmaster
May 4, 2009

2

Replies: 23

Views: 2K

May 6, 2009

Harlan Grove

H

F

FeDude
Oct 4, 2003

2

Replies: 23

Views: 1K

Oct 20, 2003

Kevin Stecyk

K

G

Date issue to automate calendar

Guest
Jul 17, 2007

2

Replies: 23

Views: 852

Jul 17, 2007

Guest

G

D

Excel, two text fields equal the number 1 per occurance

Don McLean
May 13, 2009

2

Replies: 22

Views: 813

May 14, 2009

Harlan Grove

H

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

G

Points Ranking Formulas

Guest
Oct 18, 2005

2

Replies: 22

Views: 866

Nov 3, 2005

Max

M

G

formula for a pension

Guest
Dec 7, 2005

2

Replies: 22

Views: 1K

Dec 10, 2005

Guest

G

D

SUMIF(AND) FUNCTION

Dave Gremaud
May 26, 2004

2

Replies: 22

Views: 915

Oct 28, 2004

Govind

G