Microsoft Excel Worksheet Functions

Filters

L

To view different sheets using a drop down list

Laila
Nov 16, 2004

Replies: 2

Views: 143K

Nov 17, 2004

Micke

M

Z

change operating cells dynamically according to the value of a fixed cell

Zuohong
Nov 16, 2004

Replies: 2

Views: 300K

Nov 17, 2004

Zuohong

Z

R

Problem with LOOKUP & VLOOKUP

ramsdesk
Nov 17, 2004

Replies: 1

Views: 250K

Nov 17, 2004

Guest

G

G

How can I combine IF, COLUMN, and LARGE formulas in a single cell?

Guest
Nov 17, 2004

Replies: 1

Views: 85K

Nov 17, 2004

Guest

G

G

How do I extract the last name in Excel, from a list of names lik.

Guest
Nov 17, 2004

Replies: 4

Views: 223K

Nov 17, 2004

Guest

G

G

Template / date question

Guest
Nov 16, 2004

Replies: 1

Views: 20K

Nov 17, 2004

Guest

G

G

Replace a sheetname with a cell reference to link to another work.

Guest
Nov 16, 2004

Replies: 1

Views: 108K

Nov 17, 2004

Guest

G

G

How do I create an "IF" statement with more than 7 levels?

Guest
Nov 17, 2004

Replies: 1

Views: 152K

Nov 17, 2004

Guest

G

G

Linking dates with a calendar...

Guest
Nov 16, 2004

Replies: 2

Views: 84K

Nov 17, 2004

Guest

G

G

How to change text in multiple cells from Uppercase to proper cas.

Guest
Nov 17, 2004

Replies: 1

Views: 238K

Nov 17, 2004

R.VENKATARAMAN

R

G

How can I sort an entire spreadsheet from a list

Guest
Nov 17, 2004

Replies: 4

Views: 263K

Nov 17, 2004

Myrna Larson

M

G

Count and then average

Guest
Nov 17, 2004

Replies: 4

Views: 102K

Nov 17, 2004

Guest

G

G

I need help with a formula!

Guest
Nov 17, 2004

Replies: 2

Views: 52K

Nov 17, 2004

Myrna Larson

M

G

Why do my links break when I burn multiple Excel files to a CD?

Guest
Nov 17, 2004

Replies: 1

Views: 206K

Nov 17, 2004

Guest

G

G

how do you group and ungroup rows or columns in new Excel?

Guest
Nov 15, 2004

Replies: 2

Views: 237K

Nov 17, 2004

RagDyer

R

G

SUMIF with multi-column sum_range

Guest
Nov 17, 2004

Replies: 2

Views: 296K

Nov 17, 2004

Guest

G

L

Page break macro

lehigh46
Nov 17, 2004

Replies: 2

Views: 53K

Nov 17, 2004

lehigh46

L

G

How use group and ungroup functions while worksheet is protected

Guest
Nov 16, 2004

Replies: 1

Views: 259K

Nov 17, 2004

Guest

G

G

How do I make a formula for precentages?

Guest
Nov 16, 2004

Replies: 4

Views: 155K

Nov 17, 2004

Gord Dibben

G

D

Is it possible to specify multiple condition with SUMIF?

Daniel
Nov 17, 2004

Replies: 1

Views: 274K

Nov 17, 2004

Guest

G

G

how do I open an excel document

Guest
Nov 16, 2004

Replies: 1

Views: 43K

Nov 17, 2004

Myrna Larson

M

G

Can I expand a drop down list?

Guest
Nov 16, 2004

Replies: 5

Views: 266K

Nov 17, 2004

Debra Dalgleish

D

G

How do I round time?

Guest
Nov 16, 2004

Replies: 3

Views: 71K

Nov 17, 2004

Ron Rosenfeld

R

S

If I have X,Y data how do I sum the Y values using a set of bins based on x values

ScottBerger
Nov 16, 2004

Replies: 1

Views: 217K

Nov 16, 2004

Myrna Larson

M

G

Insert Leading Zeros

Guest
Nov 16, 2004

Replies: 7

Views: 67K

Nov 16, 2004

Myrna Larson

M

G

How do I count my data that are between specific values?

Guest
Nov 16, 2004

Replies: 3

Views: 158K

Nov 16, 2004

Myrna Larson

M

G

Is it possible to do a conditional subtotal in Excel?

Guest
Nov 15, 2004

Replies: 6

Views: 409K

Nov 16, 2004

Guest

G

D

Totals based on dates

DJ Dusty
Nov 16, 2004

Replies: 1

Views: 156K

Nov 16, 2004

Domenic

D

L

need help using count if

Lionheartilly
Nov 16, 2004

Replies: 1

Views: 57K

Nov 16, 2004

Frank Kabel

F

G

Excel

Guest
Nov 16, 2004

Replies: 3

Views: 78K

Nov 16, 2004

Frank Kabel

F

G

Auto-fill won't work

Guest
Nov 16, 2004

Replies: 1

Views: 82K

Nov 16, 2004

Frank Kabel

F

G

matching data formula?

Guest
Nov 16, 2004

Replies: 1

Views: 194K

Nov 16, 2004

Guest

G

G

How to resize a comment box, by embedding code into a function?

Guest
Nov 15, 2004

Replies: 13

Views: 1M

Nov 16, 2004

Debra Dalgleish

D

S

Steved
Nov 16, 2004

Replies: 5

Views: 86K

Nov 16, 2004

Steved

S

G

please help with timekeeping in excel

Guest
Oct 15, 2004

Replies: 3

Views: 56K

Nov 16, 2004

Guest

G

T

tricksydixie
Nov 16, 2004

Replies: 2

Views: 51K

Nov 16, 2004

Gord Dibben

G

G

Formula and Conditionl Formatting Help

Guest
Nov 16, 2004

Replies: 3

Views: 157K

Nov 16, 2004

Frank Kabel

F

I

Column #'s instead of letters

in_detroit
Nov 16, 2004

Replies: 2

Views: 157K

Nov 16, 2004

Don Guillett

D

G

Guest
Nov 16, 2004

Replies: 3

Views: 40K

Nov 16, 2004

Alan Beban

A

G

edit the buttons in right click menu

Guest
Nov 16, 2004

Replies: 1

Views: 51K

Nov 16, 2004

Frank Kabel

F

G

How can I get a total across multiple spreadsheets?

Guest
Nov 16, 2004

Replies: 1

Views: 103K

Nov 16, 2004

Frank Kabel

F

G

Referencing Variables

Guest
Nov 16, 2004

Replies: 1

Views: 84K

Nov 16, 2004

Frank Kabel

F

G

Guest
Nov 15, 2004

Replies: 1

Views: 120K

Nov 16, 2004

Frank Kabel

F

G

How do I create a .csv file?

Guest
Nov 16, 2004

Replies: 1

Views: 248K

Nov 16, 2004

Frank Kabel

F

L

need help using count if

Lionheartilly
Nov 16, 2004

Replies: 2

Views: 52K

Nov 16, 2004

Frank Kabel

F

G

Help! Getting different results for the same formula.

Guest
Nov 16, 2004

Replies: 1

Views: 312K

Nov 16, 2004

Frank Kabel

F

G

Not

Guest
Nov 16, 2004

Replies: 3

Views: 60K

Nov 16, 2004

Guest

G

G

How do I match two cells and input a value in a different cell?

Guest
Nov 16, 2004

Replies: 2

Views: 90K

Nov 16, 2004

Frank Kabel

F

G

IF or Vlookup or.... Which is best for this example:

Guest
Nov 15, 2004

Replies: 10

Views: 750K

Nov 16, 2004

chadt74

C

G

Macro to sort by cell colour

Guest
Nov 16, 2004

Replies: 1

Views: 45K

Nov 16, 2004

Frank Kabel

F

You must log in or register to post here.

Top