Microsoft Excel Worksheet Functions

Filters

B

IF (working with blank cells)

bonejn
Dec 2, 2003

Replies: 4

Views: 422

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: 357

Dec 3, 2003

Someone

S

P

Months i decimal

Peter
Dec 3, 2003

Replies: 3

Views: 422

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: 354

Dec 3, 2003

Nick

N

R

assigning cell values to variables

Ruune
Dec 2, 2003

Replies: 1

Views: 403

Dec 3, 2003

Ruune

R

F

Binary calculation

FL
Dec 3, 2003

Replies: 1

Views: 479

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: 372

Dec 3, 2003

Mike

M

M

Basic SUM not calculating

mercedes king
Dec 3, 2003

Replies: 1

Views: 328

Dec 3, 2003

Jerry W. Lewis

J

M

SUM using different Text

Michelle
Dec 3, 2003

Replies: 3

Views: 361

Dec 3, 2003

Peo Sjoblom

P

B

booby
Dec 3, 2003

Replies: 1

Views: 332

Dec 3, 2003

Harald Staff

H

J

Calculating sum

JM
Dec 3, 2003

Replies: 1

Views: 303

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: 387

Dec 3, 2003

Joe

J

G

SUMIF with multiple arguements

G
Dec 3, 2003

Replies: 2

Views: 419

Dec 3, 2003

Arvi Laanemets

A

J

joone
Dec 3, 2003

Replies: 1

Views: 266

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: 334

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: 763

Dec 3, 2003

Steve

S

S

ZIP code to text?

Scott Schaus
Dec 3, 2003

Replies: 1

Views: 653

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: 288

Dec 3, 2003

L Crites

L

H

Insert active file name in the cell

Hoang Han
Dec 3, 2003

Replies: 3

Views: 327

Dec 3, 2003

Hoang Han

H

G

doing a cell reference in an "if condition"

Guest
Dec 3, 2003

Replies: 2

Views: 481

Dec 3, 2003

Guest

G

O

Oppie1
Dec 3, 2003

Replies: 6

Views: 278

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: 521

Dec 3, 2003

_Bigred

B

Q

Pie Chart Conditional Graphing

Quiz
Dec 3, 2003

Replies: 1

Views: 481

Dec 3, 2003

Steve

S

J

List using Data Validation

Jim Patton
Oct 29, 2003

Replies: 2

Views: 312

Dec 3, 2003

CLR

C

G

Averaging Times in Excel Across Dates

Guest
Dec 2, 2003

Replies: 1

Views: 602

Dec 2, 2003

Alan

A

B

Pivot Table References

Bufo
Dec 2, 2003

Replies: 2

Views: 261

Dec 2, 2003

Guest

G

B

Formula condition!!

Bob Vance
Dec 2, 2003

Replies: 3

Views: 283

Dec 2, 2003

Bob Vance

B

B

How to set tabular order?

biben
Dec 2, 2003

Replies: 2

Views: 601

Dec 2, 2003

Gord Dibben

G

I

Replace/Format?

Ivor Williams
Dec 2, 2003

Replies: 4

Views: 370

Dec 2, 2003

Gord Dibben

G

L

=countif function

LindsayPTMFUS
Dec 2, 2003

Replies: 1

Views: 287

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: 601

Dec 2, 2003

Jim

J

R

getting data from a set of closed files

rstolk
Nov 30, 2003

Replies: 3

Views: 384

Dec 2, 2003

rstolk

R

G

Subsequent Saturday

Guest
Dec 2, 2003

Replies: 4

Views: 385

Dec 2, 2003

Guest

G

G

Subsequent Saturday

Guest
Dec 2, 2003

Replies: 5

Views: 541

Dec 2, 2003

Guest

G

R

Combining Worksheets that have similar (not exact) matches

robertuva
Dec 2, 2003

Replies: 1

Views: 599

Dec 2, 2003

Kevin Stecyk

K

G

Project a date (from prediction calculation)

Gerry
Dec 2, 2003

Replies: 1

Views: 429

Dec 2, 2003

Guest

G

G

Using $ key on both sides of column to lock

Guest
Dec 2, 2003

Replies: 3

Views: 332

Dec 2, 2003

Gord Dibben

G

C

Picking out old dates

Connie
Dec 2, 2003

Replies: 3

Views: 380

Dec 2, 2003

Peo Sjoblom

P

G

Convert #N/A to number

Guest
Dec 2, 2003

Replies: 2

Views: 584

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