Microsoft Excel Worksheet Functions

Filters

G

subtraction in a list of numbers that resets with a label.

gtslabs
Oct 26, 2005

Replies: 5

Views: 422K

Oct 27, 2005

Bruno Campanini

B

K

text as an argument of SUM function

katarina07
Oct 27, 2005

Replies: 2

Views: 163K

Oct 27, 2005

Guest

G

G

Conditional formating using formulas

Guest
Oct 27, 2005

Replies: 4

Views: 179K

Oct 27, 2005

Guest

G

G

Across a worksheet, which cells I have formatted as locked?

Guest
Oct 27, 2005

Replies: 3

Views: 185K

Oct 27, 2005

Ian

I

G

Difference between Cells

Guest
Oct 27, 2005

Replies: 2

Views: 99K

Oct 27, 2005

hideki

H

R

Capturing a date field once only

Rob Svilts
Oct 26, 2005

Replies: 2

Views: 50K

Oct 27, 2005

Rob Svilts

R

G

zeros generated by a calculated item in pivot table

Guest
Oct 27, 2005

Replies: 3

Views: 156K

Oct 27, 2005

Ian

I

G

how do you split a cell within the same column?

Guest
Oct 27, 2005

Replies: 2

Views: 286K

Oct 27, 2005

arno

A

G

now()

Guest
Oct 26, 2005

Replies: 5

Views: 129K

Oct 27, 2005

topola

T

G

How do I show the contents of a dropdown without showing the box?

Guest
Oct 25, 2005

Replies: 1

Views: 129K

Oct 27, 2005

arno

A

G

i want to find a value in a refference array

Guest
Oct 27, 2005

Replies: 1

Views: 281K

Oct 27, 2005

Biff

B

G

how can I get analysis toolpack for anova calculations

Guest
Oct 26, 2005

Replies: 3

Views: 148K

Oct 27, 2005

Mike Middleton

M

G

how to hide the formula

Guest
Oct 27, 2005

Replies: 1

Views: 55K

Oct 27, 2005

Arvi Laanemets

A

C

auto cut and paste...

cjjoo
Oct 27, 2005

Replies: 1

Views: 107K

Oct 27, 2005

Anne Troy

A

G

Pivot Table Fields

Guest
Oct 26, 2005

Replies: 2

Views: 69K

Oct 27, 2005

Guest

G

J

Create a summary list without using PivotTables?

Jaye
Oct 25, 2005

Replies: 8

Views: 440K

Oct 27, 2005

Jaye Cavallo

J

G

Deleting Duplicates

Guest
Oct 26, 2005

Replies: 5

Views: 195K

Oct 27, 2005

Guest

G

L

Converging two lookups? (would save me AEONS of time!)

Lee Harris
Oct 27, 2005

Replies: 1

Views: 123K

Oct 27, 2005

Lee Harris

L

G

find an average from a range, utilizing all data > 0

Guest
Oct 26, 2005

Replies: 4

Views: 93K

Oct 27, 2005

Guest

G

G

What formula/fn would I use to count multiple condition records?

Guest
Oct 26, 2005

Replies: 3

Views: 235K

Oct 27, 2005

Guest

G

G

Need crosstab function in excel

Guest
Oct 27, 2005

Replies: 2

Views: 165K

Oct 27, 2005

Mladen_Dj

M

G

Can you copy multiple tabs from formulas to values w/o paste spec?

Guest
Oct 26, 2005

Replies: 2

Views: 145K

Oct 27, 2005

Guest

G

G

shorten formula

Guest
Oct 26, 2005

Replies: 8

Views: 174K

Oct 27, 2005

Roger Govier

R

G

Guest
Oct 25, 2005

Replies: 3

Views: 162K

Oct 26, 2005

Guest

G

G

Formula using IF, AND and OR Arguements

Guest
Oct 26, 2005

Replies: 2

Views: 105K

Oct 26, 2005

Guest

G

G

My formula in Excel 2002 reads: =12.08*85.60 result 1034.048

Guest
Oct 26, 2005

Replies: 1

Views: 45K

Oct 26, 2005

Anne Troy

A

G

URGENT need help with if/then stmt.

Guest
Oct 25, 2005

Replies: 4

Views: 102K

Oct 26, 2005

Anne Troy

A

G

How can I sort by the value of my formula and not actual formula

Guest
Oct 26, 2005

Replies: 1

Views: 79K

Oct 26, 2005

Ron Rosenfeld

R

G

look up one value and return a corresponding value using lists

Guest
Oct 26, 2005

Replies: 3

Views: 285K

Oct 26, 2005

Guest

G

G

Auto sort a linked sheet

Guest
Oct 26, 2005

Replies: 1

Views: 44K

Oct 26, 2005

RagDyer

R

G

how to identify

Guest
Oct 26, 2005

Replies: 7

Views: 180K

Oct 26, 2005

Guest

G

G

Not sure if question is "if-then".....

Guest
Oct 26, 2005

Replies: 3

Views: 58K

Oct 26, 2005

Don Guillett

D

G

Guest
Oct 26, 2005

Replies: 3

Views: 55K

Oct 26, 2005

Anne Troy

A

G

Consolidating spreadsheets

Guest
Oct 26, 2005

Replies: 1

Views: 160K

Oct 26, 2005

Anne Troy

A

G

In Excel, can a function yield a drop-down list?

Guest
Oct 26, 2005

Replies: 3

Views: 139K

Oct 26, 2005

Guest

G

A

Counting unique records based on date range

aspAddict
Oct 25, 2005

Replies: 3

Views: 320K

Oct 26, 2005

Aladin Akyurek

A

G

Concatenation Problem / VBA ?

Guest
Oct 25, 2005

Replies: 5

Views: 416K

Oct 26, 2005

Harlan Grove

H

K

Need to indirectly reference columns >26 using A1 notation based on numeric column number- how to?

KR
Oct 26, 2005

Replies: 5

Views: 329K

Oct 26, 2005

Harlan Grove

H

G

filtering row data

Guest
Oct 25, 2005

Replies: 3

Views: 79K

Oct 26, 2005

Alan Beban

A

G

How to have a the liist items appear at the top, not bottom

Guest
Oct 26, 2005

Replies: 2

Views: 105K

Oct 26, 2005

DOR

D

G

Repeating data in a Pivot table

Guest
Oct 26, 2005

Replies: 1

Views: 101K

Oct 26, 2005

Debra Dalgleish

D

G

nonsequential cell references

Guest
Oct 24, 2005

Replies: 7

Views: 122K

Oct 26, 2005

Guest

G

C

Protected sheet to unprotected sheet

CaptainIrony
Oct 26, 2005

Replies: 2

Views: 104K

Oct 26, 2005

Guest

G

G

Data Validation and Blanks in List

GoneRural
Oct 26, 2005

Replies: 1

Views: 91K

Oct 26, 2005

Bob Phillips

B

T

COUNTA with IF trouble...

TEAM
Oct 26, 2005

Replies: 1

Views: 562K

Oct 26, 2005

Domenic

D

G

Macros/Formulas

Guest
Oct 26, 2005

Replies: 2

Views: 47K

Oct 26, 2005

Guest

G

G

How to print everything in a cell

Guest
Oct 25, 2005

Replies: 2

Views: 75K

Oct 26, 2005

Guest

G

G

pivot table created from another pivot table

Guest
Oct 15, 2005

Replies: 6

Views: 303K

Oct 26, 2005

Guest

G

G

Advanced Date Functions

Guest
Oct 26, 2005

Replies: 1

Views: 112K

Oct 26, 2005

Don Guillett

D

A

Sumproduct #N/A! error issue

A. Gallardo
Oct 26, 2005

Replies: 2

Views: 51K

Oct 26, 2005

A. Gallardo

A

You must log in or register to post here.

Top