Microsoft Excel Worksheet Functions

Filters

G

formula to populate while skipping blank fields

Guest
Jul 12, 2005

Replies: 1

Views: 29K

Jul 12, 2005

Bob Phillips

B

G

sort dates by day then month, not by year.

Guest
Jul 12, 2005

Replies: 5

Views: 440K

Jul 12, 2005

Bob Phillips

B

G

Macro's

Guest
Jul 12, 2005

Replies: 1

Views: 70K

Jul 12, 2005

Bob Phillips

B

G

In a protected worksheet allow users to delete rows

Guest
Jul 12, 2005

Replies: 1

Views: 69K

Jul 12, 2005

Ian

I

G

how to convert Lotus 123 to Excel directly and can running normal

Guest
Jul 12, 2005

Replies: 1

Views: 183K

Jul 12, 2005

moi

M

G

How do i change the date 6302000 to 6/30/2000 ?

Guest
Jul 12, 2005

Replies: 3

Views: 66K

Jul 12, 2005

Aladin Akyurek

A

M

Same data box on two pages?

mattflow
Jul 11, 2005

Replies: 1

Views: 38K

Jul 12, 2005

Guest

G

R

Function for more than 1 criteria

rhani111
Jul 12, 2005

Replies: 2

Views: 184K

Jul 12, 2005

Biff

B

G

sumproduct bombs out

Guest
Jul 6, 2005

Replies: 15

Views: 198K

Jul 11, 2005

Sandy Mann

S

G

Duplicate P/N and sums

Guest
Jul 11, 2005

Replies: 4

Views: 149K

Jul 11, 2005

Guest

G

G

countif

Guest
Jul 11, 2005

Replies: 4

Views: 373K

Jul 11, 2005

Guest

G

G

Guest
Jul 11, 2005

Replies: 1

Views: 383K

Jul 11, 2005

JE McGimpsey

J

G

renaming copied worksheets deleting .xls]

Guest
Jul 11, 2005

Replies: 2

Views: 70K

Jul 11, 2005

Gordon

G

A

Something similar to sum() but ignoring error value arguments!

agarwaldvk
Jul 5, 2005

Replies: 10

Views: 32K

Jul 11, 2005

agarwaldvk

A

G

Sub SaveNClose()

Guest
Jul 11, 2005

Replies: 2

Views: 56K

Jul 11, 2005

Guest

G

G

how do i solve 'file not found' error when linking notebooks?

Guest
Jul 11, 2005

Replies: 1

Views: 277K

Jul 11, 2005

Dave Peterson

D

B

Using sheet name in formula

Brisbane Rob
Jul 11, 2005

Replies: 4

Views: 141K

Jul 11, 2005

Dave Peterson

D

G

Counting months

Guest
Jul 11, 2005

Replies: 5

Views: 207K

Jul 11, 2005

Guest

G

G

how can i assign i set of numbers (1-16) without repeating them?

Guest
Jul 11, 2005

Replies: 2

Views: 16K

Jul 11, 2005

JE McGimpsey

J

G

How to create formula to convert?

Guest
Jul 9, 2005

Replies: 9

Views: 391K

Jul 11, 2005

JE McGimpsey

J

G

Can I find and replace "white space" in a cell in Excel?

Guest
Jul 11, 2005

Replies: 7

Views: 67K

Jul 11, 2005

JE McGimpsey

J

G

What function(s) to use?

Guest
Jul 11, 2005

Replies: 4

Views: 108K

Jul 11, 2005

Guest

G

B

Ingoring text in a formula

Brad N
Jul 11, 2005

Replies: 2

Views: 63K

Jul 11, 2005

JE McGimpsey

J

G

difficult calculation

Guest
Jul 11, 2005

Replies: 2

Views: 60K

Jul 11, 2005

Roger Govier

R

G

Text To Columns Function

Guest
Jul 11, 2005

Replies: 2

Views: 151K

Jul 11, 2005

RagDyeR

R

T

TheLeafs
Jul 11, 2005

Replies: 1

Views: 108K

Jul 11, 2005

Don Guillett

D

P

How can I use the random function?

petevang
Jul 11, 2005

Replies: 1

Views: 23K

Jul 11, 2005

JE McGimpsey

J

C

Counting question

ckiraly
Jul 8, 2005

Replies: 6

Views: 12K

Jul 11, 2005

ckiraly

C

G

How to get number of rows which match criteria

Guest
Jul 11, 2005

Replies: 6

Views: 203K

Jul 11, 2005

Roger Govier

R

G

How do I copy formulas from one wkb to another w/out linkng them?

Guest
Jul 7, 2005

Replies: 7

Views: 229K

Jul 11, 2005

Guest

G

G

Using VLookup and typing in values to be "looked up"

Guest
Jul 11, 2005

Replies: 2

Views: 307K

Jul 11, 2005

Anne Troy

A

R

Help with a Function

rhani111
Jul 11, 2005

Replies: 6

Views: 92K

Jul 11, 2005

Aladin Akyurek

A

S

How to combine text from multiple cells?

sierra
Jul 11, 2005

Replies: 3

Views: 541K

Jul 11, 2005

Dave Peterson

D

G

What happened to "Tab Color" for worksheets?

Guest
Jul 8, 2005

Replies: 5

Views: 210K

Jul 11, 2005

Dave Peterson

D

G

Select rows of data in a worksheet on one criteria in multiple co

Guest
Jul 8, 2005

Replies: 5

Views: 149K

Jul 11, 2005

Guest

G

G

can excel convert number into words (like 10 to ten)?

Guest
Jul 11, 2005

Replies: 2

Views: 160K

Jul 11, 2005

Roger Govier

R

F

Need formula that reads value and then displays value from same row, different column

flywhiz
Jul 11, 2005

Replies: 2

Views: 152K

Jul 11, 2005

flywhiz

F

G

Formula is missing

Guest
Jul 11, 2005

Replies: 1

Views: 21K

Jul 11, 2005

Ron de Bruin

R

G

How do I produce a centroid fit to excel data?

Guest
Jul 11, 2005

Replies: 0

Views: 89K

Jul 11, 2005

Guest

G

G

Adding text in formulas

Guest
Jul 11, 2005

Replies: 2

Views: 106K

Jul 11, 2005

Guest

G

A

aries0070
Jul 10, 2005

Replies: 6

Views: 69K

Jul 11, 2005

Max

M

G

Un - Concatenate?

Guest
Jul 11, 2005

Replies: 2

Views: 40K

Jul 11, 2005

Alex Delamain

A

M

Part Number Lookup

Marshall2
Jul 11, 2005

Replies: 2

Views: 18K

Jul 11, 2005

Bob Phillips

B

G

Can I set more than three criteria for conditional formatting?

Guest
Jul 11, 2005

Replies: 2

Views: 102K

Jul 11, 2005

Bob Phillips

B

G

histogram for time values

Guest
Jul 11, 2005

Replies: 3

Views: 286K

Jul 11, 2005

Bob Phillips

B

G

How Do I reverse axis in a spreadsheet

Guest
Jul 10, 2005

Replies: 3

Views: 146K

Jul 11, 2005

Max

M

S

link from one workbook to another workbook using a dropdown?

sunflower
Jul 11, 2005

Replies: 2

Views: 159K

Jul 11, 2005

Biff

B

N

random number without repeating?

nonoi via OfficeKB.com
Jul 11, 2005

Replies: 2

Views: 87K

Jul 11, 2005

JE McGimpsey

J

G

USING INDEX AND RECIEVING #VALUE ERROR MESSAGE

gordo
Jul 10, 2005

Replies: 1

Views: 91K

Jul 11, 2005

Biff

B

M

how to overwrite a value without loosing the formula?

Mark Dvorkin
Jul 10, 2005

Replies: 10

Views: 593K

Jul 11, 2005

Mark Dvorkin

M

You must log in or register to post here.

Top