Microsoft Excel Worksheet Functions

Filters

C

SUMIF or SUMPRODUCT or something else?

|| cypher ||
Nov 8, 2004

Replies: 7

Views: 226K

Nov 9, 2004

|| cypher ||

C

G

How to verify that 3 cells are equal

Guest
Nov 9, 2004

Replies: 1

Views: 130K

Nov 9, 2004

JE McGimpsey

J

G

formulas for transferring data validation information in excel 200

Guest
Nov 9, 2004

Replies: 1

Views: 107K

Nov 9, 2004

Frank Kabel

F

F

Impossible Formula!

Filmmaker
Nov 9, 2004

Replies: 1

Views: 64K

Nov 9, 2004

Frank Kabel

F

G

Guest
Nov 9, 2004

Replies: 2

Views: 52K

Nov 9, 2004

JE McGimpsey

J

G

Rounding to the next highest 1000 after a resulting formula

Guest
Nov 9, 2004

Replies: 6

Views: 377K

Nov 9, 2004

Bob Phillips

B

G

Excat Forumla HELP

Guest
Nov 9, 2004

Replies: 2

Views: 298K

Nov 9, 2004

Guest

G

G

average without 0 value

Guest
Nov 9, 2004

Replies: 5

Views: 32K

Nov 9, 2004

anilsolipuram

A

G

EZ Q 4 U: How do I change a number to text, based on the number

Guest
Nov 9, 2004

Replies: 2

Views: 213K

Nov 9, 2004

Guest

G

G

Convert week number into calendar month?

Guest
Nov 9, 2004

Replies: 2

Views: 188K

Nov 9, 2004

Daniel.M

D

K

K
Nov 9, 2004

Replies: 1

Views: 53K

Nov 9, 2004

Frank Kabel

F

G

calc constant date from variable date & return with ability to rn.

Guest
Nov 9, 2004

Replies: 1

Views: 97K

Nov 9, 2004

Frank Kabel

F

G

How do I see detail of summed cells

Guest
Nov 9, 2004

Replies: 1

Views: 62K

Nov 9, 2004

RagDyer

R

G

How do i Match all COLUMNS?

Guest
Nov 9, 2004

Replies: 1

Views: 237K

Nov 9, 2004

Biff

B

J

SUM until blank cell

JasonUT
Nov 9, 2004

Replies: 1

Views: 252K

Nov 9, 2004

Aladin Akyurek

A

S

formula to determine the first column containing any data

sd
Nov 9, 2004

Replies: 5

Views: 190K

Nov 9, 2004

Aladin Akyurek

A

F

Impossible Formula!

Filmmaker
Nov 9, 2004

Replies: 5

Views: 612K

Nov 9, 2004

Aladin Akyurek

A

G

Merging Cells but have each cell counted in the range of merged c.

Guest
Nov 9, 2004

Replies: 2

Views: 183K

Nov 9, 2004

Bernie Deitrick

B

F

Impossible Formula!

Filmmaker
Nov 9, 2004

Replies: 1

Views: 172K

Nov 9, 2004

Frank Kabel

F

G

selecting and listing data

Guest
Nov 6, 2004

Replies: 9

Views: 246K

Nov 9, 2004

Guest

G

G

Entering Path Name in Footer

Guest
Oct 15, 2004

Replies: 4

Views: 110K

Nov 9, 2004

Guest

G

G

Unknown IF function parameter on amortization schedule

Guest
Nov 9, 2004

Replies: 1

Views: 138K

Nov 9, 2004

JE McGimpsey

J

M

Inserting Blank Rows Macro?

Michael Saffer
Nov 9, 2004

Replies: 2

Views: 64K

Nov 9, 2004

Michael Saffer

M

I

String function

Irina
Nov 9, 2004

Replies: 1

Views: 57K

Nov 9, 2004

Frank Kabel

F

G

Guest
Nov 9, 2004

Replies: 2

Views: 115K

Nov 9, 2004

BenjieLop

B

G

stop excel from shifting cells up when a query returns no data

Guest
Nov 9, 2004

Replies: 2

Views: 100K

Nov 9, 2004

Guest

G

G

How to filter by greatest of

Guest
Nov 9, 2004

Replies: 2

Views: 52K

Nov 9, 2004

Bart Snel

B

G

VLookup accesses half the text in a field?

Guest
Nov 9, 2004

Replies: 1

Views: 25K

Nov 9, 2004

Frank Kabel

F

M

Problems with functions

Manu Palao
Nov 9, 2004

Replies: 1

Views: 89K

Nov 9, 2004

Frank Kabel

F

G

Sorting data while the shading stays the same

Guest
Nov 9, 2004

Replies: 1

Views: 122K

Nov 9, 2004

Frank Kabel

F

W

Rounding a number to a multiple quantity that adds to a fixed total number

wjlo
Nov 9, 2004

Replies: 1

Views: 111K

Nov 9, 2004

JE McGimpsey

J

S

Req, Tricky column formula

stge
Nov 9, 2004

Replies: 1

Views: 47K

Nov 9, 2004

sulprobil

S

G

rounding

Guest
Nov 8, 2004

Replies: 4

Views: 102K

Nov 9, 2004

Guest

G

G

Guest
Nov 9, 2004

Replies: 1

Views: 74K

Nov 9, 2004

JE McGimpsey

J

G

Copy macros to new computer

Guest
Nov 9, 2004

Replies: 2

Views: 149K

Nov 9, 2004

Guest

G

J

Juan D
Nov 9, 2004

Replies: 0

Views: 92K

Nov 9, 2004

Juan D

J

N

Complex lookup task for a newbies

nhwong
Nov 9, 2004

Replies: 5

Views: 326K

Nov 9, 2004

JulieD

J

G

Isolate text following a period (".")

Guest
Nov 9, 2004

Replies: 2

Views: 157K

Nov 9, 2004

JE McGimpsey

J

I

Please Help Guys!

ivanov_nv
Nov 9, 2004

Replies: 2

Views: 88K

Nov 9, 2004

JE McGimpsey

J

G

Need to add the same cell from several workbooks

Guest
Nov 5, 2004

Replies: 1

Views: 151K

Nov 9, 2004

Guest

G

G

Generate random numbers 1-100 without any repeats?

Guest
Nov 9, 2004

Replies: 3

Views: 483K

Nov 9, 2004

JE McGimpsey

J

G

Guest
Nov 8, 2004

2

Replies: 22

Views: 592K

Nov 9, 2004

Guest

G

G

Guest
Nov 8, 2004

Replies: 2

Views: 68K

Nov 9, 2004

N Harkawat

N

R

Need help with a Macro

randy_tn
Nov 8, 2004

Replies: 3

Views: 45K

Nov 9, 2004

JulieD

J

P

Phyllis
Nov 8, 2004

Replies: 3

Views: 80K

Nov 9, 2004

JulieD

J

P

getting data from 2 different exc sheet

pinar
Nov 9, 2004

Replies: 1

Views: 216K

Nov 9, 2004

Bernie Deitrick

B

G

Sumproduct in Excel Spreadsheet to read Access db table

Guest
Nov 9, 2004

Replies: 1

Views: 6K

Nov 9, 2004

Guest

G

G

I need to randomize a column of alphanumeric employee ID's for a .

Guest
Nov 8, 2004

Replies: 9

Views: 161K

Nov 9, 2004

Tushar Mehta

T

G

How do I define the signum function sign(x) in Excel?

Guest
Nov 9, 2004

Replies: 4

Views: 85K

Nov 9, 2004

Bernd

B

A

tricky conditional formatting

albritton_99
Nov 9, 2004

Replies: 2

Views: 69K

Nov 9, 2004

Guest

G

You must log in or register to post here.

Top