Microsoft Excel Worksheet Functions

Filters

G

Yes, No, N/A in formula

Guest
Dec 9, 2005

Replies: 2

Views: 390K

Dec 11, 2005

Guest

G

T

Conditional subtotals

tx12345
Dec 11, 2005

Replies: 10

Views: 264K

Dec 11, 2005

tx12345

T

G

add data to combo box in excel then invoke macro

Guest
Dec 11, 2005

Replies: 1

Views: 108K

Dec 11, 2005

Norman Jones

N

G

#VALUE!

Guest
Dec 11, 2005

Replies: 4

Views: 333K

Dec 11, 2005

Guest

G

P

PCOR
Dec 11, 2005

Replies: 3

Views: 135K

Dec 11, 2005

Sandy Mann

S

G

round up numbers to next highest "4"

Guest
Dec 11, 2005

Replies: 1

Views: 70K

Dec 11, 2005

Guest

G

0

Insert manual line break in formula

0-0 Wai Wai ^-^
Dec 11, 2005

Replies: 3

Views: 224K

Dec 11, 2005

Guest

G

0

Extract each item in the list

0-0 Wai Wai ^-^
Dec 11, 2005

Replies: 1

Views: 163K

Dec 11, 2005

Arvi Laanemets

A

G

Nesting or new column?

Guest
Dec 10, 2005

Replies: 3

Views: 288K

Dec 11, 2005

Guest

G

R

Function to find the address of a cell

Ron Rosenfeld
Dec 8, 2005

2

Replies: 23

Views: 593K

Dec 11, 2005

Mike H

M

G

Counting Starting Digits

Guest
Dec 11, 2005

Replies: 1

Views: 67K

Dec 11, 2005

Guest

G

G

how insert same text in empty cells in column (10000 rows)

Guest
Dec 11, 2005

Replies: 1

Views: 139K

Dec 11, 2005

Dave Peterson

D

G

Sum doesn't work automatically

Guest
Dec 11, 2005

Replies: 3

Views: 100K

Dec 11, 2005

Guest

G

G

filtering between spreadsheets

Guest
Dec 10, 2005

Replies: 2

Views: 68K

Dec 11, 2005

Aladin Akyurek

A

V

Question to Bob Phillips (or whoever...)

vezerid
Dec 8, 2005

Replies: 5

Views: 338K

Dec 11, 2005

Aladin Akyurek

A

G

Guest
Dec 11, 2005

Replies: 2

Views: 85K

Dec 11, 2005

Roger Govier

R

B

sumif only for unhidden rows

Bob Phillips
Dec 10, 2005

Replies: 5

Views: 344K

Dec 11, 2005

pwz

P

N

Concatenate shortcut?

nebb
Dec 10, 2005

Replies: 3

Views: 184K

Dec 11, 2005

Harlan Grove

H

G

another data calculation

Guest
Dec 10, 2005

Replies: 2

Views: 54K

Dec 11, 2005

Guest

G

G

Excel: How do I sum a row if one cell has #n/a in it?

Guest
Dec 11, 2005

Replies: 1

Views: 63K

Dec 11, 2005

Harlan Grove

H

G

Count OR Sum Or if

Guest
Jun 29, 2005

Replies: 4

Views: 126K

Dec 11, 2005

Biff

B

G

vlookup gives me a #N/A

Guest
Oct 13, 2005

Replies: 6

Views: 92K

Dec 11, 2005

Dave Peterson

D

S

Sum Count of Criteria Every 3rd Row

Sam via OfficeKB.com
Dec 9, 2005

Replies: 5

Views: 218K

Dec 11, 2005

Guest

G

G

Ruler in excel for draw

Guest
Dec 10, 2005

Replies: 1

Views: 190K

Dec 10, 2005

Gord Dibben

G

G

Sumif

Guest
Dec 9, 2005

Replies: 3

Views: 56K

Dec 10, 2005

Guest

G

J

Find percentage ???

JoAnne
Dec 10, 2005

Replies: 2

Views: 81K

Dec 10, 2005

Guest

G

G

delete column heading for print

Guest
Dec 10, 2005

Replies: 1

Views: 97K

Dec 10, 2005

Gord Dibben

G

G

how to add a drag-down list box in Excel

Guest
Dec 9, 2005

Replies: 1

Views: 56K

Dec 10, 2005

Guest

G

G

Creating a single vertical array from multiple column arrays

Guest
Dec 9, 2005

Replies: 2

Views: 286K

Dec 10, 2005

Guest

G

J

Sum a row of multiple vlookups

jtgostars
Dec 10, 2005

Replies: 1

Views: 537K

Dec 10, 2005

Domenic

D

G

Macro time out error

Guest
Dec 10, 2005

Replies: 1

Views: 33K

Dec 10, 2005

Guest

G

G

Guest
Dec 10, 2005

Replies: 4

Views: 102K

Dec 10, 2005

Ron Rosenfeld

R

G

Guest
Dec 9, 2005

Replies: 5

Views: 356K

Dec 10, 2005

Ron Rosenfeld

R

G

Update rows with new pricing

Guest
Dec 10, 2005

Replies: 1

Views: 210K

Dec 10, 2005

Guest

G

G

Count number of items in one column that have a value in another?

Guest
Dec 9, 2005

Replies: 5

Views: 121K

Dec 10, 2005

Guest

G

B

search box in excel 2003?

_Bigred
Dec 10, 2005

Replies: 1

Views: 46K

Dec 10, 2005

Dave Peterson

D

G

Entry into check box dependent on other check box.

Guest
Dec 8, 2005

Replies: 9

Views: 146K

Dec 10, 2005

Dave Peterson

D

K

Coloring rows in excel

Kjetil
Dec 5, 2005

Replies: 5

Views: 660K

Dec 10, 2005

David McRitchie

D

G

Complicated If Then / V Lookup / Match Statement...

Guest
Dec 6, 2005

Replies: 17

Views: 1M

Dec 10, 2005

Guest

G

G

Will Excell 2003 convert numbers to words?

Guest
Dec 10, 2005

Replies: 1

Views: 108K

Dec 10, 2005

Niek Otten

N

G

why does =GAMMAINV(0,5;389;1) return #NUM! ?

Guest
Dec 8, 2005

Replies: 3

Views: 131K

Dec 10, 2005

Jerry W. Lewis

J

G

formula for a pension

Guest
Dec 7, 2005

2

Replies: 22

Views: 2M

Dec 10, 2005

Guest

G

R

Still trying to figure it out

Robertgn
Dec 9, 2005

Replies: 1

Views: 161K

Dec 10, 2005

Robertgn

R

G

how do I keep column titles on subsequent pages of a pivot table

Guest
Dec 9, 2005

Replies: 1

Views: 67K

Dec 10, 2005

Roger Govier

R

G

excel - autonumber feature

Guest
Dec 10, 2005

Replies: 1

Views: 27K

Dec 10, 2005

Héctor Miguel

H

R

Sumproduct to ignore text and ""

Ricky Pang
Dec 6, 2005

Replies: 6

Views: 1M

Dec 10, 2005

Ricky Pang

R

G

How to Highlight the date if it is within 3 months from now

Guest
Dec 9, 2005

Replies: 2

Views: 238K

Dec 10, 2005

Guest

G

R

Robertgn
Dec 10, 2005

Replies: 3

Views: 324K

Dec 10, 2005

Robertgn

R

T

IF command, limit to number of entries?

timhiley
Dec 9, 2005

Replies: 2

Views: 448K

Dec 10, 2005

timhiley

T

G

Rank where lowest value is highest rank

Guest
Dec 9, 2005

Replies: 2

Views: 335K

Dec 9, 2005

Alan

A

You must log in or register to post here.

Top