Excel Functions

Sort by: Replies Descending

Filters

D

Spreadsheet Corruption?

dennis
Feb 10, 2009

Replies: 4

Views: 2K

Feb 14, 2009

dennis

D

T

Need a simple formula for conditional average

Terry B.
Jan 10, 2004

Replies: 4

Views: 406

Jan 14, 2004

A.W.J. Ales

A

N

index lookup and array constant

Nicawette
Aug 2, 2006

Replies: 4

Views: 791

Aug 3, 2006

Max

M

Z

Average of Numbers

Zach
Jul 21, 2007

Replies: 4

Views: 714

Jul 23, 2007

Dave Thomas

D

G

reading sheetnumber?

Guurt
Jun 29, 2005

Replies: 4

Views: 217

Jun 30, 2005

Roman

R

B

Weekly Calendar

Ben
Dec 16, 2006

Replies: 4

Views: 484

Dec 26, 2006

Ben

B

B

SUMIF Criteria

bbrd
Mar 5, 2007

Replies: 4

Views: 800

Mar 6, 2007

Harlan Grove

H

M

Can sumif detect text strings or detect if a dollar sign $ is in a cell?

MollyDavis
Apr 17, 2004

Replies: 4

Views: 900

Apr 17, 2004

Ken Wright

K

J

Add Header/Footer to excel report from ASP..

jmalvika
Aug 2, 2006

Replies: 4

Views: 535

Aug 2, 2006

[email protected]

J

S

Using sumproduct while skipping cells in the array

shanen
Jan 30, 2007

Replies: 4

Views: 848

Jan 30, 2007

Roger Govier

R

G

offset formula to sum column from entered date downward

Gerry
Apr 30, 2007

Replies: 3

Views: 637

May 1, 2007

Pete_UK

P

K

Excluding in Excel

Kuba
Feb 21, 2006

Replies: 3

Views: 421

Feb 23, 2006

Max

M

G

create list from non-blank quantity

gailana
Mar 30, 2007

Replies: 3

Views: 664

Apr 19, 2007

Pete_UK

P

P

IF THEN do an AVERAGE

pika.white
Feb 13, 2006

Replies: 3

Views: 293

Feb 14, 2006

Harlan Grove

H

J

SUMIF or SUMIFS

Jeff
Jan 29, 2008

Replies: 3

Views: 2K

Jan 31, 2008

ilia

I

G

row numbers jump ?

Guest
Nov 11, 2004

Replies: 3

Views: 204

Nov 12, 2004

Nospam

N

J

Comparing Two Large Data Lists

justinfoote
Mar 30, 2006

Replies: 3

Views: 413

Apr 4, 2006

Max

M

M

Un-merge cells

Mark
Aug 25, 2004

Replies: 3

Views: 210

Aug 30, 2004

Jerry W. Lewis

J

R

TESTING A RANGE OF CELLS

Richard
Apr 1, 2007

Replies: 3

Views: 647

Apr 1, 2007

Don Guillett

D

A

Problem with Factorials

Adam Cunningham
Jul 31, 2003

Replies: 3

Views: 540

Aug 12, 2003

Robert McCurdy

R

E

IF function syntax question - please help. Thanks!

EV
Aug 12, 2004

Replies: 3

Views: 346

Aug 15, 2004

Jerry W. Lewis

J

J

vlookup function addressing

jacky.newsgroup
Apr 20, 2006

Replies: 3

Views: 253

Apr 20, 2006

Max

M

W

Lookup functions

Warwick Cunningham
Aug 14, 2003

Replies: 3

Views: 415

Aug 19, 2003

Warwick Cunningham

W

R

Protect a group of cells

Raymond
Jul 21, 2004

Replies: 3

Views: 171

Jul 21, 2004

Jon Peltier

J

B

Day Function (incorrect day)

bnilic
May 1, 2006

Replies: 3

Views: 311

Jun 9, 2006

Mini Me

M

D

Data Tables

Dean
Mar 23, 2006

Replies: 3

Views: 294

Apr 1, 2006

flummi

F

W

Formula that uses column 7 row titles - DIFFICULT!!

WhytheQ
May 17, 2006

Replies: 3

Views: 349

May 18, 2006

Max

M

R

creating an array

Richard
Mar 15, 2007

Replies: 3

Views: 811

Mar 15, 2007

T. Valko

T

J

Need to set up formula to create mutliples of two numbers

Julie P.
Sep 26, 2004

Replies: 3

Views: 246

Sep 26, 2004

Ron Rosenfeld

R

D

search returns error when substring not found

David Schwartz
Nov 30, 2007

Replies: 3

Views: 994

Dec 1, 2007

Pete_UK

P

W

Entering a number

WSB
Aug 9, 2007

Replies: 3

Views: 593

Aug 9, 2007

Pete_UK

P

J

Inserting page numbers in an Excel workbook starting with a number other than 1

Jechole
Sep 22, 2005

Replies: 3

Views: 291

Oct 7, 2005

[email protected]

S

T

count text function 3 criteria

timh2ofall
Sep 16, 2003

Replies: 3

Views: 488

Sep 17, 2003

timh2ofall

T

G

Match cell value (Date) in a named Range with function

gm
Feb 10, 2006

Replies: 3

Views: 345

Feb 11, 2006

Max

M

C

Understanding the results using array arguments in a nested If() function

CJ
Jun 25, 2004

Replies: 3

Views: 394

Jul 4, 2004

Jerry W. Lewis

J

B

? How to pull system date then set it to previous sunday

_Bigred
Oct 25, 2007

Replies: 3

Views: 742

Oct 25, 2007

Pete_UK

P

B

Quarter of the hour formula

Bluzdog
Sep 13, 2003

Replies: 3

Views: 411

Oct 13, 2003

GB

G

F

countifs function

Felsa Satlow
Nov 16, 2007

Replies: 3

Views: 2K

Mar 2, 2008

ilia

I

C

How do you truncate 2.22 to just 0.22?

Crackles McFarly
Sep 4, 2007

Replies: 3

Views: 602

Sep 5, 2007

Crackles McFarly

C

A

Explain Circular References

Arcadian
Jun 4, 2007

Replies: 3

Views: 663

Jul 26, 2007

Harlan Grove

H

E

countif problem

elaine_chan2
Oct 8, 2007

Replies: 3

Views: 641

Oct 9, 2007

Pete_UK

P

S

Need Help Removing all Letters Leaving only Numbers

Sam
Dec 23, 2005

Replies: 3

Views: 357

Dec 30, 2005

Sox

S

W

getting data from a closed worksheet

www.butterflysystems.co.uk
Jan 19, 2006

Replies: 3

Views: 354

Jan 23, 2006

Harlan Grove

H

G

Dates Math

Gord
Sep 26, 2007

Replies: 3

Views: 779

Sep 27, 2007

Pete_UK

P

C

How to assign a letter code based on values in previous columns

chunt
Feb 1, 2007

Replies: 3

Views: 646

Feb 3, 2007

Pete_UK

P

C

Extremely complex problem: showing a value as an 'axis' on a circle

Chris.Holland16
Nov 15, 2005

Replies: 3

Views: 333

Nov 15, 2005

[email protected]

C

M

Problem with AVERAGE

Mike Hogan
Nov 17, 2005

Replies: 3

Views: 281

Nov 20, 2005

Jerry W. Lewis

J

C

How do you change the sign (e.g. +3 to -3 OR -3 to +3)

Chris.Holland16
Nov 15, 2005

Replies: 3

Views: 294

Nov 15, 2005

mbarron

M

M

How do I auto run my macro upon open of file....Workbook_Open() is NOT working?

meghantrus
Jun 1, 2007

Replies: 3

Views: 727

Sep 19, 2007

FrankSinatra

F

T

specifying named range with a lookup

TSW632
Aug 28, 2007

Replies: 3

Views: 613

Aug 29, 2007

TSW632

T

Top