Microsoft Excel Worksheet Functions

Filters

G

Unique Value without using FILTER

Guest
Oct 11, 2005

Replies: 3

Views: 25K

Oct 11, 2005

Ron Rosenfeld

R

G

Calculating the maximum value in a range of cells in a closed work

Guest
Oct 11, 2005

Replies: 1

Views: 52K

Oct 11, 2005

Guest

G

G

Mulitplie workbooks - known duplicate records - need to consolidat

Guest
Oct 10, 2005

Replies: 2

Views: 88K

Oct 11, 2005

Guest

G

G

Multiple protections

GuyB
Oct 11, 2005

Replies: 2

Views: 58K

Oct 11, 2005

GuyB

G

C

cjjoo
Oct 10, 2005

Replies: 9

Views: 77K

Oct 11, 2005

Sandy Mann

S

G

Date entry gone haywire in Excel!

Guest
Oct 11, 2005

Replies: 3

Views: 19K

Oct 11, 2005

Paul B

P

G

return a range of cells from a vertical lookup

Guest
Oct 11, 2005

Replies: 2

Views: 31K

Oct 11, 2005

Guest

G

G

Defined Named cells lined to a Function Procedure

Guest
Oct 11, 2005

Replies: 4

Views: 22K

Oct 11, 2005

Guest

G

G

Countif function for instances of text string contained

Guest
Oct 10, 2005

Replies: 1

Views: 133K

Oct 11, 2005

Paul Sheppard

P

M

Calculate difference (mins) between 2 Times

Max
Oct 11, 2005

Replies: 6

Views: 327K

Oct 11, 2005

Max

M

G

.csv file - excel 2003

Guest
Oct 10, 2005

Replies: 2

Views: 84K

Oct 11, 2005

Guest

G

G

Guest
Oct 10, 2005

Replies: 6

Views: 248K

Oct 11, 2005

Guest

G

C

sumproduct , array or countif?

cjjoo
Oct 10, 2005

Replies: 5

Views: 105K

Oct 11, 2005

duane

D

G

Wroking with rounded or trunc calculation

Guest
Oct 11, 2005

Replies: 3

Views: 21K

Oct 11, 2005

Guest

G

C

another sumproduct question

cjjoo
Oct 11, 2005

Replies: 1

Views: 164K

Oct 11, 2005

duane

D

R

Return a cell value based on specific combinations of cells in an array

rmcnam05
Oct 10, 2005

Replies: 2

Views: 147K

Oct 11, 2005

Guest

G

G

Excel should be able to map which cells reference each other.

Guest
Oct 11, 2005

Replies: 1

Views: 39K

Oct 11, 2005

Peo Sjoblom

P

G

How do I keep the zeros in front of numbers when i split a cell

Guest
Oct 10, 2005

Replies: 3

Views: 106K

Oct 11, 2005

Guest

G

G

Drop down to diplay info from another sheet

Guest
Oct 10, 2005

Replies: 4

Views: 150K

Oct 11, 2005

Guest

G

H

Countif a small or capital letter

hodkd
Oct 11, 2005

Replies: 5

Views: 94K

Oct 11, 2005

RagDyer

R

C

chrisabberton
Oct 10, 2005

Replies: 8

Views: 171K

Oct 11, 2005

Domenic

D

G

Excel 2003 links are not updating between workbooks

Guest
Sep 22, 2005

Replies: 3

Views: 70K

Oct 11, 2005

Max

M

G

LOOKUP question

Guest
Oct 11, 2005

Replies: 5

Views: 141K

Oct 11, 2005

Guest

G

B

Index/Match question Need help!

Brian H
Oct 11, 2005

Replies: 5

Views: 160K

Oct 11, 2005

Brian H

B

J

Help, how to find a range of data?

jub366
Oct 10, 2005

Replies: 3

Views: 125K

Oct 11, 2005

RagDyer

R

W

Scrolling Cells

William Kim
Oct 10, 2005

Replies: 1

Views: 67K

Oct 11, 2005

Guest

G

G

Conditional formula - language needed

gamebird
Oct 10, 2005

Replies: 7

Views: 642K

Oct 10, 2005

Aladin Akyurek

A

G

Average Grades and drop the lowest score

Guest
Oct 15, 2004

Replies: 5

Views: 337K

Oct 10, 2005

Kahlan

K

G

Equal to or less than formula

Guest
Oct 10, 2005

Replies: 3

Views: 119K

Oct 10, 2005

Bob Phillips

B

G

What is the syntax for the IF formula in Excel?

Guest
Oct 5, 2005

Replies: 5

Views: 163K

Oct 10, 2005

Richard Buttrey

R

G

How do I use a range of numbers in an if statement?

Guest
Oct 10, 2005

Replies: 2

Views: 174K

Oct 10, 2005

Richard Buttrey

R

G

How do I "show pages" in pivot tables in Excel 2002

Guest
Oct 10, 2005

Replies: 1

Views: 19K

Oct 10, 2005

Debra Dalgleish

D

G

calculate using rolling calendar

Guest
Oct 10, 2005

Replies: 1

Views: 148K

Oct 10, 2005

Bob Phillips

B

G

How do I share data in different worksheets?

Guest
Oct 7, 2005

Replies: 4

Views: 37K

Oct 10, 2005

Guest

G

M

morrison
Oct 10, 2005

Replies: 1

Views: 66K

Oct 10, 2005

Guest

G

G

Distributing values from rows to columns for Access import

Guest
Oct 10, 2005

Replies: 2

Views: 61K

Oct 10, 2005

Guest

G

A

If statement w/ rounding but not all numbers

AMarie
Oct 10, 2005

Replies: 5

Views: 269K

Oct 10, 2005

Ron Rosenfeld

R

G

Guest
Oct 10, 2005

Replies: 2

Views: 231K

Oct 10, 2005

JE McGimpsey

J

G

outline & groups

Guest
Oct 10, 2005

Replies: 1

Views: 37K

Oct 10, 2005

Guest

G

B

Using scientific notation in TEXT() function

boopathi
Oct 10, 2005

Replies: 1

Views: 273K

Oct 10, 2005

Harlan Grove

H

G

Sorting columns

Guest
Oct 10, 2005

Replies: 2

Views: 69K

Oct 10, 2005

Guest

G

G

populating multiple cells

Guest
Oct 10, 2005

Replies: 1

Views: 405K

Oct 10, 2005

Guest

G

G

how can I make a form number change everytime the form is opened

Guest
Oct 10, 2005

Replies: 1

Views: 80K

Oct 10, 2005

Paul B

P

G

Change formula to Indirect

Guest
Oct 10, 2005

Replies: 3

Views: 84K

Oct 10, 2005

Ian

I

G

How do I convert a row of cells into a two-dimensional array?

Guest
Oct 5, 2005

Replies: 7

Views: 138K

Oct 10, 2005

Alan Beban

A

G

need a roster that 3 kids can work to day by day?

Guest
Oct 10, 2005

Replies: 2

Views: 164K

Oct 10, 2005

GeorgeF

G

G

Is there a function to consolidate multiple records into one recor

Guest
Oct 10, 2005

Replies: 4

Views: 115K

Oct 10, 2005

Guest

G

G

Guest
Oct 10, 2005

Replies: 1

Views: 130K

Oct 10, 2005

Bob Phillips

B

N

Conditional Formatting - Formula based

Nick Danger
Oct 3, 2005

Replies: 4

Views: 219K

Oct 10, 2005

Nick Dangr

N

G

compare two groups of data

Guest
Oct 10, 2005

Replies: 4

Views: 77K

Oct 10, 2005

BenjieLop

B

You must log in or register to post here.

Top