Microsoft Excel Worksheet Functions

Filters

G

lookup on Table including blanks -

Guest
Oct 30, 2006

Replies: 7

Views: 167K

Oct 31, 2006

Lori

L

S

Show input box with cell value

sunilkes
Oct 31, 2006

Replies: 4

Views: 256K

Oct 31, 2006

Sandy

S

G

Splitting cells - please help!

Guest
Oct 31, 2006

Replies: 11

Views: 1M

Oct 31, 2006

Ron Rosenfeld

R

J

Tie a Calendar week to a Scoped Projected Week

jodi.sage
Oct 26, 2006

Replies: 3

Views: 432K

Oct 31, 2006

Guest

G

G

Conditional formats using more than 3 conditions

Guest
Oct 31, 2006

Replies: 2

Views: 132K

Oct 31, 2006

Guest

G

P

princy_varghese
Oct 31, 2006

Replies: 4

Views: 118K

Oct 31, 2006

Lori

L

G

Drop Down List choice selecting another drop down list

Guest
Oct 30, 2006

Replies: 3

Views: 95K

Oct 31, 2006

Guest

G

G

How do i calculate the saved amount ?

Guest
Oct 31, 2006

Replies: 1

Views: 83K

Oct 31, 2006

Niek Otten

N

M

Date Interval Predictions

michaeloj.simpkins
Oct 31, 2006

Replies: 1

Views: 22K

Oct 31, 2006

Roger Govier

R

G

Maximum length of a number

Guest
Oct 31, 2006

Replies: 1

Views: 210K

Oct 31, 2006

Ron Rosenfeld

R

G

Formula Too Long

Guest
Oct 30, 2006

Replies: 15

Views: 682K

Oct 31, 2006

Lori

L

G

Group & sort rows that have a specific value in column C

Guest
May 27, 2006

Replies: 3

Views: 55K

Oct 31, 2006

Guest

G

H

Heine
Oct 30, 2006

Replies: 9

Views: 1M

Oct 31, 2006

Bob Phillips

B

L

LR
Oct 30, 2006

Replies: 8

Views: 265K

Oct 31, 2006

Roger Govier

R

G

How do I selectand copy only subtotals in a sheet

Guest
Oct 31, 2006

Replies: 1

Views: 214K

Oct 31, 2006

Guest

G

V

Text to rows...at wits end

VL
Oct 31, 2006

Replies: 3

Views: 296K

Oct 31, 2006

PY & Associates

P

G

cannot paste link using equal sign

Guest
Oct 31, 2006

Replies: 1

Views: 112K

Oct 31, 2006

David Biddulph

D

G

How on Earth do I use the GHK Function?

Guest
Oct 30, 2006

Replies: 3

Views: 114K

Oct 31, 2006

Guest

G

A

How to concatenate an array of four stings using formulae (not UDF)

Alan
Oct 31, 2006

Replies: 9

Views: 294K

Oct 31, 2006

Alan

A

G

convert time functions to numbers

Guest
Oct 31, 2006

Replies: 1

Views: 187K

Oct 31, 2006

Guest

G

G

FV Calculation problem

Guest
Oct 31, 2006

Replies: 1

Views: 58K

Oct 31, 2006

Guest

G

G

Guest
Oct 29, 2006

Replies: 10

Views: 292K

Oct 31, 2006

RagDyer

R

G

conditional formatting error message

Guest
Oct 30, 2006

Replies: 3

Views: 483K

Oct 31, 2006

Biff

B

G

Help with SUM and IF

Guest
Oct 30, 2006

Replies: 3

Views: 94K

Oct 31, 2006

Biff

B

G

How to change cell reference within formulas

Guest
Oct 27, 2006

Replies: 4

Views: 245K

Oct 31, 2006

RagDyer

R

G

Copy Paste issue

Guest
Oct 27, 2006

Replies: 3

Views: 200K

Oct 31, 2006

RagDyer

R

G

look up sequential cells

Guest
Oct 30, 2006

Replies: 1

Views: 461K

Oct 31, 2006

Otto Moehrbach

O

G

text box

Guest
Oct 30, 2006

Replies: 1

Views: 47K

Oct 30, 2006

Debra Dalgleish

D

G

refresh option of pivot table not working

Guest
Oct 30, 2006

Replies: 1

Views: 46K

Oct 30, 2006

Debra Dalgleish

D

I

How can I concatenate a number and preserve the formatting?

imothers
Oct 30, 2006

Replies: 1

Views: 475K

Oct 30, 2006

Max

M

G

Trunc/Pmt Different Results same formula same sheet

Guest
Oct 27, 2006

Replies: 4

Views: 216K

Oct 30, 2006

Guest

G

G

copy formula every x rows

Guest
Oct 30, 2006

Replies: 5

Views: 110K

Oct 30, 2006

Ken Wright

K

G

Merge/Combine address lists

Guest
Oct 25, 2006

Replies: 2

Views: 134K

Oct 30, 2006

Guest

G

G

Guest
Oct 30, 2006

Replies: 1

Views: 84K

Oct 30, 2006

Paul B

P

G

"Magic" Formula

Guest
Oct 30, 2006

Replies: 13

Views: 238K

Oct 30, 2006

PCLIVE

P

G

Formula works but formula shows in cell???

Guest
Oct 30, 2006

Replies: 2

Views: 219K

Oct 30, 2006

Gord Dibben

G

G

go to last filled cell in a column shortcut

Guest
Oct 30, 2006

Replies: 2

Views: 105K

Oct 30, 2006

Gord Dibben

G

G

formula that sums cells yet does not round the number up or down.

Guest
Oct 30, 2006

Replies: 4

Views: 74K

Oct 30, 2006

Guest

G

G

GETPIVOTDATA used with a central pivot table - values vanish

Guest
Oct 26, 2006

Replies: 2

Views: 148K

Oct 30, 2006

Guest

G

K

Is there a Way to Find the Cell Row and Column From my UDF

kylancal
Oct 30, 2006

Replies: 1

Views: 52K

Oct 30, 2006

Bob Phillips

B

V

Last entry in a column/row function?

Victor Delta
Oct 30, 2006

Replies: 2

Views: 316K

Oct 30, 2006

Victor Delta

V

G

entering same formula in multiple sheets

Guest
Oct 30, 2006

Replies: 1

Views: 69K

Oct 30, 2006

Paul B

P

A

"Replace" problems

Adetola Obembe
Oct 30, 2006

Replies: 2

Views: 133K

Oct 30, 2006

Adetola Obembe

A

G

Tracking Check Boxes

Guest
Oct 30, 2006

Replies: 1

Views: 145K

Oct 30, 2006

Biff

B

D

Warning message if one column contains any text and another column is blank

Dileep Chandran
Oct 24, 2006

Replies: 12

Views: 196K

Oct 30, 2006

Ian

I

G

How do I make JUST the header row always visible in Excel?

Guest
Oct 30, 2006

Replies: 2

Views: 427K

Oct 30, 2006

Gord Dibben

G

G

How do I get items from sheet 3 to show up on sheet 1 and 2?

Guest
Oct 30, 2006

Replies: 1

Views: 225K

Oct 30, 2006

Guest

G

E

Summing cell totals across columns

excelguy
Oct 29, 2006

Replies: 2

Views: 94K

Oct 30, 2006

goodoldude

G

G

Excel math formula

Guest
Oct 30, 2006

Replies: 4

Views: 141K

Oct 30, 2006

Gord Dibben

G

P

Use custom format to add text to a text entry.

Pierre
Oct 30, 2006

Replies: 4

Views: 426K

Oct 30, 2006

Pierre

P

You must log in or register to post here.

Top