Microsoft Excel Worksheet Functions

Filters

J

How to return the text data of the first col after getting the max value from the 2nd col

Joyce
Nov 23, 2005

Replies: 1

Views: 124K

Nov 23, 2005

Guest

G

Y

Last Number to Average

yirawan
Nov 23, 2005

Replies: 3

Views: 154K

Nov 23, 2005

yirawan

Y

G

Vlookup in large named range

Guest
Nov 23, 2005

Replies: 3

Views: 116K

Nov 23, 2005

Niek Otten

N

G

Can a conditional formatting result affect another cell or cells

Guest
Nov 23, 2005

Replies: 1

Views: 80K

Nov 23, 2005

Guest

G

G

Filter one column for all "Pending"

Guest
Nov 23, 2005

Replies: 1

Views: 21K

Nov 23, 2005

Dave Peterson

D

G

Pivot Table Subtotals - Difference

Guest
Nov 22, 2005

Replies: 2

Views: 276K

Nov 23, 2005

Guest

G

G

Return of blank cell if lookup fails

Guest
Nov 23, 2005

Replies: 4

Views: 366K

Nov 23, 2005

Phillycheese5

P

G

How do i compute the average value of 100 iterations?

Guest
Nov 22, 2005

Replies: 4

Views: 222K

Nov 23, 2005

Guest

G

G

Guest
Aug 29, 2005

Replies: 5

Views: 270K

Nov 23, 2005

Bob Phillips

B

G

Regular Time and Over Time

Guest
Nov 23, 2005

Replies: 2

Views: 51K

Nov 23, 2005

widemonk

W

G

Dates - Months & Years

Guest
Nov 23, 2005

Replies: 5

Views: 216K

Nov 23, 2005

Roger Govier

R

G

color fill cells based on IF function or formula

Guest
Nov 23, 2005

Replies: 1

Views: 199K

Nov 23, 2005

Peo Sjoblom

P

K

k.roberts
Nov 23, 2005

Replies: 4

Views: 164K

Nov 23, 2005

Peo Sjoblom

P

G

Guest
Nov 23, 2005

Replies: 3

Views: 454K

Nov 23, 2005

Guest

G

L

Number Formatting Question

Lee Harris
Nov 23, 2005

Replies: 2

Views: 111K

Nov 23, 2005

Lee Harris

L

G

Finding the Max of a related Value Lookup

Guest
Nov 23, 2005

Replies: 4

Views: 451K

Nov 23, 2005

Guest

G

G

How do I select form a drop down box by typing the first part?

Guest
Nov 22, 2005

Replies: 2

Views: 107K

Nov 23, 2005

Guest

G

G

SUM Days (to 30), Months (to 12) and Years

Guest
Nov 23, 2005

Replies: 5

Views: 128K

Nov 23, 2005

Guest

G

G

find cells that contain specific characters

Guest
Nov 19, 2005

Replies: 8

Views: 719K

Nov 23, 2005

Guest

G

S

Problem with TRUNC

Steven_Archer
Nov 23, 2005

Replies: 5

Views: 449K

Nov 23, 2005

Jerry W. Lewis

J

G

Too few arguments

Guest
Nov 23, 2005

Replies: 3

Views: 653K

Nov 23, 2005

Guest

G

C

cjjoo
Nov 23, 2005

Replies: 5

Views: 182K

Nov 23, 2005

Bob Phillips

B

G

How do I count in a range of dates?

Guest
Nov 23, 2005

Replies: 2

Views: 59K

Nov 23, 2005

Bob Phillips

B

G

Guest
Nov 23, 2005

Replies: 1

Views: 50K

Nov 23, 2005

Richard Buttrey

R

G

How to save the current worksheet as JPEG, TIFF or DICOM?

Guest
Nov 23, 2005

Replies: 2

Views: 265K

Nov 23, 2005

Guest

G

G

-ve no with -1; positive with sign+ and 0 no sign? Tks.

Guest
Nov 23, 2005

Replies: 1

Views: 177K

Nov 23, 2005

Rowan Drummond

R

C

Lookup same word "value" across multiple cells

chazmac
Nov 21, 2005

Replies: 3

Views: 53K

Nov 23, 2005

chazmac

C

G

Delete Cell Function

Guest
Nov 23, 2005

Replies: 7

Views: 262K

Nov 23, 2005

Max

M

J

Do I Need to Use an IF Statement?

jgp_2
Nov 22, 2005

Replies: 3

Views: 161K

Nov 23, 2005

jgp_2

J

G

How to create a menue bar of numbers in a cell?

Guest
Nov 23, 2005

Replies: 1

Views: 30K

Nov 23, 2005

Rowan Drummond

R

G

Calculating slope, intercept, LOGEST with empty cells in data

Guest
Nov 22, 2005

Replies: 1

Views: 375K

Nov 23, 2005

Jerry W. Lewis

J

G

Logarithmic curve formulas in charts and LOGEST fx values?

Guest
Nov 21, 2005

Replies: 4

Views: 630K

Nov 23, 2005

Jerry W. Lewis

J

G

Guest
Nov 23, 2005

Replies: 1

Views: 59K

Nov 23, 2005

Lotus123

L

G

Concatentate Join Identifier

Guest
Nov 22, 2005

Replies: 2

Views: 93K

Nov 23, 2005

DOR

D

G

How can I get this to function please.

Guest
Nov 22, 2005

Replies: 2

Views: 361K

Nov 23, 2005

Guest

G

G

Formula for growth chart?

Guest
Nov 22, 2005

Replies: 5

Views: 516K

Nov 23, 2005

Max

M

G

Tab Key

Guest
Nov 23, 2005

Replies: 1

Views: 42K

Nov 23, 2005

Gord Dibben

G

B

Index Match function for multiple linked variables

Bob
Nov 22, 2005

Replies: 13

Views: 361K

Nov 23, 2005

Bob

B

S

Excel formula help needed

SteveFox
Nov 22, 2005

Replies: 2

Views: 346K

Nov 23, 2005

SteveFox

S

G

How do I create numbers for a Chinese Auction?

Guest
Nov 22, 2005

Replies: 4

Views: 85K

Nov 23, 2005

Gord Dibben

G

S

Difficult Excel Problem

SpikeUK
Nov 22, 2005

Replies: 3

Views: 291K

Nov 22, 2005

SpikeUK

S

B

Calculate duration in Excel 2000

Babette
Nov 22, 2005

Replies: 1

Views: 141K

Nov 22, 2005

Sandy Mann

S

G

Finding values based on color

Guest
Nov 22, 2005

Replies: 2

Views: 125K

Nov 22, 2005

Guest

G

G

deleting macros that are not really in my workbook?

Guest
Nov 22, 2005

Replies: 1

Views: 58K

Nov 22, 2005

Gord Dibben

G

R

VB Protection problem

Rmagic
Nov 22, 2005

Replies: 1

Views: 204K

Nov 22, 2005

Dave Peterson

D

L

F5 function for zeroes?

Lee Harris
Nov 22, 2005

Replies: 3

Views: 135K

Nov 22, 2005

Dave Peterson

D

G

Formula questions

Guest
Nov 22, 2005

Replies: 1

Views: 279K

Nov 22, 2005

Roger Govier

R

G

Showing #VALUE!

Guest
Nov 20, 2005

Replies: 6

Views: 89K

Nov 22, 2005

Guest

G

G

Now()

Guest
Nov 22, 2005

Replies: 6

Views: 169K

Nov 22, 2005

Nick Hodge

N

G

I get 0:00 when I format cells 4 time no matter what # I enter

Guest
Nov 18, 2005

Replies: 5

Views: 74K

Nov 22, 2005

Gord Dibben

G

You must log in or register to post here.

Top