Microsoft Excel Worksheet Functions

Filters

G

How do I calculate IRR using monthly cash flows, not annual?

Guest
Oct 26, 2005

Replies: 2

Views: 458K

Oct 26, 2005

Ron Rosenfeld

R

G

Getting data from another worksheet

Guest
Oct 26, 2005

Replies: 1

Views: 85K

Oct 26, 2005

Bruno Campanini

B

J

jgregor
Oct 26, 2005

Replies: 1

Views: 240K

Oct 26, 2005

swatsp0p

S

G

ISNUMBER and VLOOKUP Help Needed

Guest
Oct 26, 2005

Replies: 1

Views: 236K

Oct 26, 2005

Bob Phillips

B

G

Excel Won't Calc?

Guest
Oct 25, 2005

Replies: 7

Views: 114K

Oct 26, 2005

Guest

G

G

Help! How can I get data from one sheet to another

Guest
Oct 25, 2005

Replies: 2

Views: 137K

Oct 26, 2005

Guest

G

G

Link To Drop Down Menu

Guest
Oct 25, 2005

Replies: 5

Views: 213K

Oct 26, 2005

Roger Govier

R

T

DATEDIF Simple request

TAS-LGS
Oct 26, 2005

Replies: 1

Views: 72K

Oct 26, 2005

Ron Rosenfeld

R

G

How do I put in more than 7 validations in IF FORMALA in EXCEL

Guest
Oct 26, 2005

Replies: 3

Views: 295K

Oct 26, 2005

Bruno Campanini

B

G

Guest
Oct 26, 2005

Replies: 4

Views: 374K

Oct 26, 2005

Arvi Laanemets

A

G

data validation using vlookup

Guest
Oct 24, 2005

Replies: 5

Views: 305K

Oct 26, 2005

Bob Phillips

B

T

Page Number of a cell

transferxxx
Oct 26, 2005

Replies: 2

Views: 76K

Oct 26, 2005

[email protected]

T

G

ranking

Guest
Oct 25, 2005

Replies: 4

Views: 194K

Oct 26, 2005

Domenic

D

G

Excel-comments entered by users disappear in a shared excel-sheet

Guest
Sep 29, 2005

Replies: 1

Views: 45K

Oct 26, 2005

Guest

G

S

Use of pre-defined lists

Sandor
Oct 25, 2005

Replies: 3

Views: 230K

Oct 26, 2005

Sandor

S

W

Formatting Columns

wg100
Oct 25, 2005

Replies: 3

Views: 104K

Oct 26, 2005

wg100

W

C

offset? match index? sumif? 2way look-up?

cjjoo
Oct 26, 2005

Replies: 2

Views: 93K

Oct 26, 2005

cjjoo

C

G

Move between worksheets

Guest
Jul 15, 2005

Replies: 3

Views: 160K

Oct 26, 2005

Guest

G

G

List Box Selections

Guest
Oct 25, 2005

Replies: 1

Views: 48K

Oct 26, 2005

Bob Phillips

B

R

HOW TO EXTEND A NAMED RANGE

ramana
Oct 26, 2005

Replies: 5

Views: 338K

Oct 26, 2005

ramana

R

C

conditional formating??

cjjoo
Oct 26, 2005

Replies: 3

Views: 105K

Oct 26, 2005

Guest

G

G

average numbers in sequence

Guest
Oct 21, 2005

Replies: 11

Views: 767K

Oct 26, 2005

Guest

G

G

REPLACE Function

Guest
Oct 25, 2005

Replies: 4

Views: 445K

Oct 26, 2005

Arvi Laanemets

A

A

cell address of occurence of a vlookup formula

albertnhc
Oct 25, 2005

Replies: 6

Views: 173K

Oct 26, 2005

[email protected]

T

S

rounding off month

simha
Oct 25, 2005

Replies: 5

Views: 36K

Oct 26, 2005

simha

S

G

Which lookup should I use?

Guest
Oct 26, 2005

Replies: 3

Views: 115K

Oct 26, 2005

Guest

G

G

Excel IRR calculation

Guest
Oct 25, 2005

Replies: 1

Views: 70K

Oct 26, 2005

Fred Smith

F

G

Auto Record Transfer (2)

Guest
Oct 25, 2005

Replies: 7

Views: 573K

Oct 26, 2005

Anne Troy

A

E

Problem occur in sum function while deleting the rows

Ellis Yu
Oct 25, 2005

Replies: 2

Views: 75K

Oct 26, 2005

Ellis Yu

E

M

Conditional Fromatting and Formulas

Mark C via OfficeKB.com
Oct 24, 2005

Replies: 5

Views: 637K

Oct 26, 2005

Biff

B

D

Calculate number based on percentage

dan.gates
Aug 10, 2005

Replies: 12

Views: 365K

Oct 26, 2005

excelking54

E

L

Newbie - Need help with zipcode format- no options for cell

lburg801
Oct 25, 2005

Replies: 6

Views: 178K

Oct 26, 2005

lburg801

L

G

subtract year and divide

Guest
Oct 24, 2005

Replies: 7

Views: 228K

Oct 26, 2005

Anne Troy

A

O

formula to transpose

oberon.black
Oct 25, 2005

Replies: 2

Views: 109K

Oct 26, 2005

RagDyer

R

G

Guest
Oct 25, 2005

Replies: 1

Views: 112K

Oct 26, 2005

Anne Troy

A

G

How do center headings across columns in excel

Guest
Oct 25, 2005

Replies: 1

Views: 144K

Oct 26, 2005

RagDyer

R

G

Guest
Oct 25, 2005

Replies: 1

Views: 70K

Oct 25, 2005

John Michl

J

G

compare info in 4 worksheets and highlight fields that are the sam

Guest
Oct 24, 2005

Replies: 3

Views: 76K

Oct 25, 2005

Guest

G

G

Split data from one cell to two separate cells

Guest
Oct 25, 2005

Replies: 2

Views: 70K

Oct 25, 2005

Graham Haughs

G

W

Sumproduct if column begins with text

webee33
Oct 25, 2005

Replies: 2

Views: 66K

Oct 25, 2005

Bob Phillips

B

G

How do I sequentially number every third page of my workbook?

Guest
Oct 25, 2005

Replies: 1

Views: 74K

Oct 25, 2005

Zack Barresse

Z

G

last four digits of a social security number

Guest
Oct 25, 2005

Replies: 2

Views: 482K

Oct 25, 2005

Zack Barresse

Z

X

Intervals as logical statements

xnadeau
Oct 25, 2005

Replies: 3

Views: 72K

Oct 25, 2005

Bob Phillips

B

G

Multiple Criteria using countif

Guest
Oct 25, 2005

Replies: 6

Views: 173K

Oct 25, 2005

Bob Phillips

B

G

Delete Row Macro - if cell > $5000

Guest
Oct 25, 2005

Replies: 1

Views: 26K

Oct 25, 2005

Chip Pearson

C

G

How do I specify more than one argument for the SUMIF function?

Guest
Aug 26, 2005

Replies: 3

Views: 248K

Oct 25, 2005

Guest

G

J

using =COUNTIF to count two text values

John in Surrey
Oct 25, 2005

Replies: 1

Views: 138K

Oct 25, 2005

Trevor Shuttleworth

T

G

formula in excel to skip cells having - number and add only +

Guest
Oct 25, 2005

Replies: 3

Views: 46K

Oct 25, 2005

Paul B

P

G

How can I sum every third cell in a row in Excel

Guest
Oct 25, 2005

Replies: 4

Views: 341K

Oct 25, 2005

Bruno Campanini

B

G

formula(excel) to skip cells having - number and add + one

Guest
Oct 25, 2005

Replies: 1

Views: 185K

Oct 25, 2005

Bruno Campanini

B

You must log in or register to post here.

Top