Microsoft Excel Worksheet Functions

Filters

G

How to add in an array formula if iisna index match

Guest
Mar 14, 2005

Replies: 4

Views: 510K

Mar 15, 2005

Guest

G

G

Guest
Mar 14, 2005

Replies: 2

Views: 95K

Mar 15, 2005

Guest

G

G

VLOOKUP function

Guest
Mar 14, 2005

Replies: 6

Views: 164K

Mar 15, 2005

RagDyeR

R

G

if function, multiple characters from right

Guest
Mar 14, 2005

Replies: 4

Views: 146K

Mar 15, 2005

Guest

G

G

Guest
Mar 14, 2005

Replies: 2

Views: 134K

Mar 15, 2005

easy

E

G

Numbers after decimal point excel to word mail merge

Guest
Mar 15, 2005

Replies: 1

Views: 313K

Mar 15, 2005

Ron Rosenfeld

R

G

How do I make formula in Excel from other worksheet?

Guest
Mar 15, 2005

Replies: 1

Views: 85K

Mar 15, 2005

Arvi Laanemets

A

G

Guest
Mar 13, 2005

Replies: 5

Views: 67K

Mar 15, 2005

Arvi Laanemets

A

G

External link using calculated cell value

Guest
Mar 15, 2005

Replies: 1

Views: 271K

Mar 15, 2005

Biff

B

G

can i get a letter to be calculated in a worksheet

Guest
Feb 23, 2005

Replies: 3

Views: 64K

Mar 15, 2005

Guest

G

J

Formula for calculating interest payments?

Jack Shearer
Mar 14, 2005

Replies: 3

Views: 207K

Mar 15, 2005

Jack Shearer

J

G

Excel

Guest
Mar 15, 2005

Replies: 1

Views: 61K

Mar 15, 2005

Guest

G

G

External Data Source updating on open, how to turn back on prompt.

Guest
Mar 14, 2005

Replies: 1

Views: 40K

Mar 15, 2005

Debra Dalgleish

D

G

Linking between worksheets- then sorting data

Guest
Mar 14, 2005

Replies: 1

Views: 52K

Mar 15, 2005

Debra Dalgleish

D

G

Open two worksheets at the same time

Guest
Mar 13, 2005

Replies: 2

Views: 259K

Mar 15, 2005

Earl Kiosterud

E

G

Guest
Mar 14, 2005

Replies: 3

Views: 79K

Mar 15, 2005

Dave Peterson

D

D

Strange Format changes

Dan Wilson
Mar 14, 2005

Replies: 5

Views: 171K

Mar 15, 2005

RagDyer

R

G

FILTER ONE MULTIPLE SHEETS

Guest
Mar 14, 2005

Replies: 1

Views: 62K

Mar 15, 2005

Max

M

G

how to convert GETPIVOTDATA from excel 2000 to excel 2002...

Guest
Mar 14, 2005

Replies: 1

Views: 185K

Mar 15, 2005

Debra Dalgleish

D

G

Transpose-relative cell references would be useful.

Guest
Mar 14, 2005

Replies: 7

Views: 354K

Mar 15, 2005

[email protected]

C

G

Screen Updating

Guest
Mar 14, 2005

Replies: 3

Views: 119K

Mar 14, 2005

Guest

G

B

Worksheet references another tab in formula

Bonita
Mar 14, 2005

Replies: 2

Views: 215K

Mar 14, 2005

Bonita

B

G

DOS Data in Excel Format with Date and Military Time in same cell

Guest
Mar 14, 2005

Replies: 1

Views: 49K

Mar 14, 2005

Ron Rosenfeld

R

J

Indexing an Array with VLOOKUP

Joe Blow
Mar 14, 2005

Replies: 1

Views: 111K

Mar 14, 2005

Jason Morin

J

G

=SUMIF(Input!H2:H718,AZ19,Input!E2:E685)AND(IF

Guest
Mar 14, 2005

Replies: 2

Views: 30K

Mar 14, 2005

Guest

G

G

FORMATTING CELLS

Guest
Mar 14, 2005

Replies: 1

Views: 57K

Mar 14, 2005

Jason Morin

J

G

Data Validation using a Calendar

Guest
Mar 14, 2005

Replies: 3

Views: 23K

Mar 14, 2005

Bob Phillips

B

G

What does the ! stand for in formulas?

Guest
Mar 14, 2005

Replies: 1

Views: 51K

Mar 14, 2005

Fredrik Wahlgren

F

G

Percent increase

Guest
Mar 14, 2005

Replies: 3

Views: 112K

Mar 14, 2005

Guest

G

G

split a single column into 2 separate columns

Guest
Mar 14, 2005

Replies: 2

Views: 110K

Mar 14, 2005

Guest

G

G

Unique sumproduct with criteria!

Guest
Mar 14, 2005

Replies: 5

Views: 347K

Mar 14, 2005

Domenic

D

G

i cannot open excel file error Cannot access read-only document me

Guest
Mar 14, 2005

Replies: 1

Views: 227K

Mar 14, 2005

Gord Dibben

G

G

Date difference taking into account weekends.

Guest
Mar 14, 2005

Replies: 3

Views: 126K

Mar 14, 2005

Daniel.M

D

G

eliminate data entered to a worksheet that copies to another work.

Guest
Mar 14, 2005

Replies: 2

Views: 252K

Mar 14, 2005

Gord Dibben

G

G

calculate date differences in years and months

Guest
Mar 14, 2005

Replies: 1

Views: 140K

Mar 14, 2005

JulieD

J

G

help with excell to outlook for mail merge

Guest
Mar 14, 2005

Replies: 2

Views: 52K

Mar 14, 2005

Gord Dibben

G

G

Suggestions for creating Issues Log using Excel?

Guest
Mar 14, 2005

Replies: 1

Views: 72K

Mar 14, 2005

Bob Phillips

B

G

Excel - Addition Running

Guest
Mar 14, 2005

Replies: 1

Views: 73K

Mar 14, 2005

JulieD

J

G

Sum function when pasting

Guest
Mar 14, 2005

Replies: 2

Views: 136K

Mar 14, 2005

Max

M

G

Guest
Mar 14, 2005

Replies: 1

Views: 61K

Mar 14, 2005

Dave Peterson

D

G

Guest
Mar 14, 2005

Replies: 5

Views: 40K

Mar 14, 2005

Dave Peterson

D

G

Guest
Mar 11, 2005

Replies: 3

Views: 144K

Mar 14, 2005

JulieD

J

G

putting a number equal to writing commands

Guest
Mar 11, 2005

Replies: 7

Views: 98K

Mar 14, 2005

JulieD

J

B

Biff
Mar 12, 2005

Replies: 16

Views: 486K

Mar 14, 2005

Ron Rosenfeld

R

G

Guest
Mar 14, 2005

Replies: 1

Views: 24K

Mar 14, 2005

Jerry W. Lewis

J

K

Unlock a spinner or scrollbar on a protected sheet

kevin99
Mar 14, 2005

Replies: 1

Views: 215K

Mar 14, 2005

Guest

G

G

Count the occurances of a month in a range of date fields

Guest
Feb 5, 2005

Replies: 8

Views: 1M

Mar 14, 2005

Ron Rosenfeld

R

G

Function WEEKNUM does not show correct result for 15.2.2005

Guest
Mar 11, 2005

Replies: 10

Views: 17K

Mar 14, 2005

Ron Rosenfeld

R

G

Extracting Surname from within a text string

Guest
Mar 13, 2005

Replies: 6

Views: 516K

Mar 14, 2005

Bob Phillips

B

G

Excel and propogating data

Guest
Mar 10, 2005

Replies: 6

Views: 30K

Mar 14, 2005

Arvi Laanemets

A

You must log in or register to post here.

Top