Microsoft Excel Worksheet Functions

Filters

B

IF (working with blank cells)

bonejn
Dec 2, 2003

Replies: 4

Views: 421

Dec 3, 2003

Harlan Grove

H

B

CountIf function

Bridget Stacy
Dec 3, 2003

Replies: 2

Views: 540

Dec 3, 2003

Don Guillett

D

?

Extracting hyperlinks

=?iso-8859-1?Q?Mattias_Palmest=E5l?=
Dec 3, 2003

Replies: 1

Views: 356

Dec 3, 2003

Someone

S

P

Months i decimal

Peter
Dec 3, 2003

Replies: 3

Views: 420

Dec 3, 2003

Daniel.M

D

C

Extracting matching words within cells

ciara
Nov 26, 2003

Replies: 4

Views: 497

Dec 3, 2003

ciara

C

N

#VALUE error message

Nick
Dec 3, 2003

Replies: 4

Views: 353

Dec 3, 2003

Nick

N

R

assigning cell values to variables

Ruune
Dec 2, 2003

Replies: 1

Views: 400

Dec 3, 2003

Ruune

R

F

Binary calculation

FL
Dec 3, 2003

Replies: 1

Views: 476

Dec 3, 2003

Harald Staff

H

M

Nth day of month of year

Michele
Dec 3, 2003

Replies: 3

Views: 1K

Dec 3, 2003

Daniel.M

D

G

incorrect values returned from simple calculations

Graeme
Dec 3, 2003

Replies: 5

Views: 384

Dec 3, 2003

Chip Pearson

C

M

Is it possible to automatically change cell background colours?

Mike
Dec 3, 2003

Replies: 2

Views: 371

Dec 3, 2003

Mike

M

M

Basic SUM not calculating

mercedes king
Dec 3, 2003

Replies: 1

Views: 322

Dec 3, 2003

Jerry W. Lewis

J

M

SUM using different Text

Michelle
Dec 3, 2003

Replies: 3

Views: 358

Dec 3, 2003

Peo Sjoblom

P

B

booby
Dec 3, 2003

Replies: 1

Views: 329

Dec 3, 2003

Harald Staff

H

J

Calculating sum

JM
Dec 3, 2003

Replies: 1

Views: 300

Dec 3, 2003

Guest

G

K

Using $ in Formulas

Kevin
Dec 3, 2003

Replies: 3

Views: 364

Dec 3, 2003

Arvi Laanemets

A

J

Excel cell backgrounds

John Seward
Dec 2, 2003

Replies: 2

Views: 385

Dec 3, 2003

Joe

J

G

SUMIF with multiple arguements

G
Dec 3, 2003

Replies: 2

Views: 417

Dec 3, 2003

Arvi Laanemets

A

J

joone
Dec 3, 2003

Replies: 1

Views: 264

Dec 3, 2003

Guest

G

J

Character spacing

Jon
Dec 3, 2003

Replies: 1

Views: 360

Dec 3, 2003

Stephen Bye

S

R

robertuva
Dec 3, 2003

Replies: 5

Views: 331

Dec 3, 2003

Graeme

G

S

Getting a list of file names from Windows Explorer into Excel

Steve M
Dec 3, 2003

Replies: 3

Views: 760

Dec 3, 2003

Steve

S

S

ZIP code to text?

Scott Schaus
Dec 3, 2003

Replies: 1

Views: 650

Dec 3, 2003

Steve

S

F

Return the column letter or row number

firebird96
Dec 2, 2003

Replies: 1

Views: 2K

Dec 3, 2003

Hoang Han

H

L

Multiple references in IF statement

L Crites
Dec 3, 2003

Replies: 4

Views: 285

Dec 3, 2003

L Crites

L

H

Insert active file name in the cell

Hoang Han
Dec 3, 2003

Replies: 3

Views: 323

Dec 3, 2003

Hoang Han

H

G

doing a cell reference in an "if condition"

Guest
Dec 3, 2003

Replies: 2

Views: 478

Dec 3, 2003

Guest

G

O

Oppie1
Dec 3, 2003

Replies: 6

Views: 270

Dec 3, 2003

Vasant Nanavati

V

L

Editing Numerous Formulas Quickly

Leslie
Dec 1, 2003

Replies: 4

Views: 462

Dec 3, 2003

Leslie

L

B

if (25¢ or 10¢)? formula help

_Bigred
Dec 1, 2003

Replies: 12

Views: 515

Dec 3, 2003

_Bigred

B

Q

Pie Chart Conditional Graphing

Quiz
Dec 3, 2003

Replies: 1

Views: 478

Dec 3, 2003

Steve

S

J

List using Data Validation

Jim Patton
Oct 29, 2003

Replies: 2

Views: 311

Dec 3, 2003

CLR

C

G

Averaging Times in Excel Across Dates

Guest
Dec 2, 2003

Replies: 1

Views: 597

Dec 2, 2003

Alan

A

B

Pivot Table References

Bufo
Dec 2, 2003

Replies: 2

Views: 260

Dec 2, 2003

Guest

G

B

Formula condition!!

Bob Vance
Dec 2, 2003

Replies: 3

Views: 282

Dec 2, 2003

Bob Vance

B

B

How to set tabular order?

biben
Dec 2, 2003

Replies: 2

Views: 598

Dec 2, 2003

Gord Dibben

G

I

Replace/Format?

Ivor Williams
Dec 2, 2003

Replies: 4

Views: 360

Dec 2, 2003

Gord Dibben

G

L

=countif function

LindsayPTMFUS
Dec 2, 2003

Replies: 1

Views: 286

Dec 2, 2003

Vasant Nanavati

V

F

Fredrik Jönsson
Dec 2, 2003

Replies: 4

Views: 234

Dec 2, 2003

Fredrik Jönsson

F

M

How to make sure a particular worksheet opens when I open my workbook?

Marvin Hlavac
Dec 1, 2003

Replies: 6

Views: 367

Dec 2, 2003

Marvin Hlavac

M

D

Indirect function with Named multiple ranges

Damian
Dec 2, 2003

Replies: 5

Views: 600

Dec 2, 2003

Jim

J

R

getting data from a set of closed files

rstolk
Nov 30, 2003

Replies: 3

Views: 383

Dec 2, 2003

rstolk

R

G

Subsequent Saturday

Guest
Dec 2, 2003

Replies: 4

Views: 375

Dec 2, 2003

Guest

G

G

Subsequent Saturday

Guest
Dec 2, 2003

Replies: 5

Views: 538

Dec 2, 2003

Guest

G

R

Combining Worksheets that have similar (not exact) matches

robertuva
Dec 2, 2003

Replies: 1

Views: 596

Dec 2, 2003

Kevin Stecyk

K

G

Project a date (from prediction calculation)

Gerry
Dec 2, 2003

Replies: 1

Views: 426

Dec 2, 2003

Guest

G

G

Using $ key on both sides of column to lock

Guest
Dec 2, 2003

Replies: 3

Views: 331

Dec 2, 2003

Gord Dibben

G

C

Picking out old dates

Connie
Dec 2, 2003

Replies: 3

Views: 378

Dec 2, 2003

Peo Sjoblom

P

G

Convert #N/A to number

Guest
Dec 2, 2003

Replies: 2

Views: 581

Dec 2, 2003

Guest

G

G

automatically insert date in adjacent cell?

Guest
Dec 2, 2003

Replies: 1

Views: 481

Dec 2, 2003

Dave R.

D

Top