Excel Worksheets

Filters

Y

Click button to automatically add row

yirawan
Nov 24, 2005

Replies: 1

Views: 337

Nov 24, 2005

Ron de Bruin

R

J

Excel - need a function to compare lists

JerryMatson
Nov 24, 2005

Replies: 1

Views: 166

Nov 24, 2005

Niek Otten

N

U

VLOOKUP Problem

uplink600
Nov 24, 2005

Replies: 2

Views: 136

Nov 24, 2005

Roger Govier

R

A

how to fetch a row and post the row into another sheelt

ananthmca2004
Nov 24, 2005

Replies: 1

Views: 174

Nov 24, 2005

Roland

R

S

I would like the worksheet auto name itself with a formula

SJA
Nov 23, 2005

Replies: 1

Views: 212

Nov 24, 2005

Barb Reinhardt

B

A

Active cell counting in particular print page (one sheet having different print area)

ananthmca2004
Nov 24, 2005

Replies: 1

Views: 449

Nov 24, 2005

antoka05

A

I

Part of text as criteria

irresistible007
Nov 24, 2005

Replies: 2

Views: 187

Nov 24, 2005

Bruno Campanini

B

R

Help with SUMPRODUCT

Robo
Nov 24, 2005

Replies: 4

Views: 125

Nov 24, 2005

Robo

R

J

lock tab in sheet 2 until cell in sheet one is completed

john tempest
Nov 19, 2005

Replies: 7

Views: 166

Nov 24, 2005

john tempest

J

P

populating empty cell with value from above

PY & Associates
Nov 23, 2005

Replies: 4

Views: 240

Nov 24, 2005

PY & Associates

P

S

How to tackle Division by zero for DAVERAGE function

Sharma
Nov 24, 2005

Replies: 1

Views: 363

Nov 24, 2005

Biff

B

T

formula looking up multiple information.

Tamara
Nov 23, 2005

Replies: 4

Views: 160

Nov 24, 2005

Biff

B

J

select based on word CDS being in description field

Joe D
Nov 22, 2005

Replies: 2

Views: 132

Nov 24, 2005

Joe D

J

C

GETPIVOTDATA question regarding adding "rows"

CamiK
Nov 23, 2005

Replies: 1

Views: 155

Nov 24, 2005

Debra Dalgleish

D

R

How to create a prefix containing text and zero?

Roger Govier
Nov 23, 2005

Replies: 9

Views: 238

Nov 24, 2005

GeneWan

G

T

match values in two different columns

thomasNg
Nov 24, 2005

Replies: 2

Views: 301

Nov 24, 2005

Max

M

M

Have 2 items in dropdown, want warning if one selected

movermike
Nov 23, 2005

Replies: 1

Views: 132

Nov 24, 2005

L. Howard Kittle

L

S

Match Last Occurrence of Numeric Value and Count BACK to Previous

Sam via OfficeKB.com
Nov 23, 2005

Replies: 4

Views: 432

Nov 24, 2005

Sam via OfficeKB.com

S

R

Formula/Array question with dates

Renee
Nov 23, 2005

Replies: 1

Views: 151

Nov 24, 2005

DOR

D

E

DROP DOWN LISTS

eternal_cat via OfficeKB.com
Nov 23, 2005

Replies: 4

Views: 141

Nov 24, 2005

Gord Dibben

G

S

Column labels

SN
Nov 23, 2005

Replies: 3

Views: 158

Nov 24, 2005

SN

S

K

Referencing a different Workbook

Ken
Nov 22, 2005

Replies: 8

Views: 250

Nov 24, 2005

Max

M

H

vb code - Automatic transfer of data from one sheet to another

herr_bench
Nov 23, 2005

Replies: 1

Views: 228

Nov 24, 2005

Gord Dibben

G

D

Printing Certain Columns

DonDon
Nov 23, 2005

Replies: 1

Views: 155

Nov 24, 2005

Dave Peterson

D

T

Nested IF with OR Function

Trudy
Nov 23, 2005

Replies: 5

Views: 134

Nov 23, 2005

Roger Govier

R

T

matching data from column b

tbax6
Nov 23, 2005

Replies: 1

Views: 163

Nov 23, 2005

bpeltzer

B

S

I need to Sum the value D2:G1000

Steved
Nov 23, 2005

Replies: 2

Views: 275

Nov 23, 2005

Steved

S

K

how many if statements can i use in a single cell ?

Kypreo
Nov 23, 2005

Replies: 5

Views: 203

Nov 23, 2005

Roger Govier

R

A

Can criteria in countif statement be a color?

aosbor
Nov 23, 2005

Replies: 1

Views: 157

Nov 23, 2005

Bob Phillips

B

M

Assign Date Formatting To Button

MDW
Nov 23, 2005

Replies: 0

Views: 160

Nov 23, 2005

MDW

M

D

Enable automatic refresh link

Deb Bagby
Nov 23, 2005

Replies: 0

Views: 185

Nov 23, 2005

Deb Bagby

D

M

How do I set up a conditional cell from a drop down list in Excel

Mon
Nov 23, 2005

Replies: 3

Views: 461

Nov 23, 2005

SteveG

S

N

Ignoring Time in a Date Time Calculation

nmp
Nov 23, 2005

Replies: 3

Views: 239

Nov 23, 2005

nmp

N

D

Enable automatic refresh

Deb Bagby
Nov 23, 2005

Replies: 0

Views: 172

Nov 23, 2005

Deb Bagby

D

B

Time and Business Hours

Brett
Nov 23, 2005

Replies: 1

Views: 141

Nov 23, 2005

Biff

B

E

What excel function to use?

Excel user
Nov 23, 2005

Replies: 1

Views: 121

Nov 23, 2005

Bob Phillips

B

D

Multiple Validations in for 1 cell

dmcnutt_ghg
Nov 23, 2005

Replies: 1

Views: 197

Nov 23, 2005

Bob Phillips

B

E

count and lookup

eoht
Nov 23, 2005

Replies: 1

Views: 116

Nov 23, 2005

Bob Phillips

B

L

Nested --- Subtotal IF function

Lisa Beach
Nov 23, 2005

Replies: 3

Views: 414

Nov 23, 2005

Bob Phillips

B

R

Trying to do something that may not be possible

RS-PLH
Nov 23, 2005

Replies: 0

Views: 219

Nov 23, 2005

RS-PLH

R

A

How to add a column of accumulated data in pivottable?

Angus
Nov 16, 2005

Replies: 1

Views: 201

Nov 23, 2005

cs02000

C

I

Refering cells between worksheets

In Need
Nov 22, 2005

Replies: 2

Views: 168

Nov 23, 2005

Lisa Beach

L

G

Calculate Hours and overtime by week

gregt812
Nov 23, 2005

Replies: 1

Views: 556

Nov 23, 2005

DOR

D

B

Can you make all sheets scroll when scrolling one sheet

billy boy
Nov 23, 2005

Replies: 1

Views: 181

Nov 23, 2005

Bernie Deitrick

B

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: 377

Nov 23, 2005

David Billigmeier

D

Y

Last Number to Average

yirawan
Nov 23, 2005

Replies: 3

Views: 168

Nov 23, 2005

yirawan

Y

K

Vlookup in large named range

KemS
Nov 23, 2005

Replies: 3

Views: 194

Nov 23, 2005

Niek Otten

N

M

Can a conditional formatting result affect another cell or cells

marseans
Nov 23, 2005

Replies: 1

Views: 213

Nov 23, 2005

Barb Reinhardt

B

C

Filter one column for all "Pending"

CaptDunsull
Nov 23, 2005

Replies: 1

Views: 192

Nov 23, 2005

Dave Peterson

D

K

Calculated fields-Pivot tables

Kim
Nov 5, 2004

Replies: 1

Views: 267

Nov 23, 2005

cs02000

C

Top