Microsoft Excel Worksheet Functions

Filters

G

Average Non-Contiguous numbers

Guest
Jan 20, 2005

Replies: 1

Views: 62K

Jan 20, 2005

Jason Morin

J

G

Need help with cell formatting

Guest
Nov 8, 2004

Replies: 4

Views: 109K

Jan 20, 2005

Guest

G

G

How do I use vlookup to point to an external file that changes nam

Guest
Jan 20, 2005

Replies: 3

Views: 113K

Jan 20, 2005

Harlan Grove

H

G

Is there a way to display when a document was last saved in a foot

Guest
Jan 20, 2005

Replies: 1

Views: 53K

Jan 20, 2005

Jason Morin

J

G

How do I convert dollars and cents to text, and prefill the cell .

Guest
Jan 20, 2005

Replies: 1

Views: 514K

Jan 20, 2005

Tim C

T

G

Multiple Data Validation Criterias

Guest
Jan 19, 2005

Replies: 4

Views: 138K

Jan 20, 2005

Guest

G

R

Change workbook sheet reference using cell A1 to change a vairable

Reed
Jan 20, 2005

Replies: 4

Views: 220K

Jan 20, 2005

Reed

R

G

Exctracting Data

Guest
Jan 20, 2005

Replies: 1

Views: 42K

Jan 20, 2005

Gord Dibben

G

G

Pasting formulas to different rows

Guest
Jan 20, 2005

Replies: 1

Views: 140K

Jan 20, 2005

Michael Malinsky

M

G

How do I change the colour of/remove the Freeze Panes line in Exce

Guest
Jan 20, 2005

Replies: 1

Views: 230K

Jan 20, 2005

Guest

G

G

limit a value using discounts

Guest
Jan 20, 2005

Replies: 4

Views: 357K

Jan 20, 2005

Guest

G

G

Conditional Formatting and ISBLANK

Guest
Jan 20, 2005

Replies: 3

Views: 125K

Jan 20, 2005

Max

M

G

Need conditional formatting formula to highlight top ten values i.

Guest
Jan 19, 2005

Replies: 11

Views: 1M

Jan 20, 2005

Bob Phillips

B

G

Guest
Jan 20, 2005

Replies: 6

Views: 652K

Jan 20, 2005

Guest

G

B

nesting sum if and

BMSpell
Jan 20, 2005

Replies: 2

Views: 172K

Jan 20, 2005

Jason Mori

J

G

Data isn't being recognized.

Guest
Jan 20, 2005

Replies: 1

Views: 77K

Jan 20, 2005

JE McGimpsey

J

G

If function display

Guest
Jan 20, 2005

Replies: 1

Views: 121K

Jan 20, 2005

JE McGimpsey

J

G

Can one still create a graph using data in the worksheet?

Guest
Jan 20, 2005

Replies: 1

Views: 135K

Jan 20, 2005

JE McGimpsey

J

G

save excel spreadsheet as a csv file

Guest
Jan 20, 2005

Replies: 1

Views: 70K

Jan 20, 2005

JE McGimpsey

J

T

Convert entire columns of text email addresses to hyperlinks

TSA
Jan 20, 2005

Replies: 2

Views: 164K

Jan 20, 2005

TSA

T

G

password for worksheets cont...

Guest
Jan 20, 2005

Replies: 1

Views: 85K

Jan 20, 2005

JE McGimpsey

J

G

Help with array formula

Guest
Jan 20, 2005

Replies: 2

Views: 141K

Jan 20, 2005

Guest

G

G

Is there a way to make a drop down list in Excel that lets you se.

Guest
Jan 20, 2005

Replies: 1

Views: 180K

Jan 20, 2005

Guest

G

G

Conditional Formatting Cell and Row

Guest
Jan 20, 2005

Replies: 1

Views: 128K

Jan 20, 2005

JulieD

J

G

if function display

Guest
Jan 20, 2005

Replies: 1

Views: 103K

Jan 20, 2005

JulieD

J

I

Incrementing rows (or columns) to a reference in another worksheet

Ignobilitor
Jan 20, 2005

Replies: 2

Views: 103K

Jan 20, 2005

Ignobilitor

I

G

Worksheet reference (i.e placing worksheet name in a cell)

Guest
Jan 20, 2005

Replies: 1

Views: 35K

Jan 20, 2005

Bob Phillips

B

G

How do I use a pivot table value to reference a worksheet

Guest
Jan 19, 2005

Replies: 10

Views: 368K

Jan 20, 2005

JulieD

J

R

IF statement based on data type

Reed
Jan 20, 2005

Replies: 1

Views: 148K

Jan 20, 2005

Jason Morin

J

G

The Help on the Excel Edate worksheet function contains an error:.

Guest
Jan 20, 2005

Replies: 1

Views: 98K

Jan 20, 2005

Ron de Bruin

R

G

Converting months to years

Guest
Jan 20, 2005

Replies: 1

Views: 121K

Jan 20, 2005

JE McGimpsey

J

G

if isna and vlookup together

Guest
Jan 20, 2005

Replies: 2

Views: 204K

Jan 20, 2005

Jason Morin

J

G

Time calculation.

Guest
Jan 17, 2005

Replies: 2

Views: 83K

Jan 20, 2005

Guest

G

G

Problem with wrap text format

Guest
Jan 20, 2005

Replies: 1

Views: 64K

Jan 20, 2005

Rob van Gelder

R

G

Extracting just the color words

Guest
Jan 18, 2005

Replies: 5

Views: 98K

Jan 20, 2005

Guest

G

G

Counting Data From A Query

Guest
Jan 19, 2005

Replies: 1

Views: 123K

Jan 20, 2005

Rob van Gelder

R

G

Option Buttons move after placing on sheet

Guest
Jan 19, 2005

Replies: 2

Views: 27K

Jan 20, 2005

Guest

G

G

how to disregard the DIV in a range

Guest
Jan 19, 2005

Replies: 5

Views: 119K

Jan 20, 2005

JulieD

J

G

Add more lines and more columns in Excel

Guest
Jan 19, 2005

Replies: 3

Views: 194K

Jan 20, 2005

Harlan Grove

H

G

Inserting Columns

Guest
Jan 20, 2005

Replies: 1

Views: 305K

Jan 20, 2005

Debra Dalgleish

D

G

Having a due date flag in a different colour 30 days from current.

Guest
Jan 19, 2005

Replies: 1

Views: 81K

Jan 20, 2005

Debra Dalgleish

D

G

COUNTIF text where there is more than one word in a cell

Guest
Jan 20, 2005

Replies: 2

Views: 342K

Jan 20, 2005

Biff

B

G

how do I sort a column with several categories (ie red and blue)

Guest
Jan 17, 2005

Replies: 1

Views: 39K

Jan 20, 2005

Debra Dalgleish

D

G

Formula won't reflect new cell data

Guest
Jan 20, 2005

Replies: 1

Views: 95K

Jan 20, 2005

Peo Sjoblom

P

L

Luke Dallman
Jan 19, 2005

Replies: 10

Views: 752K

Jan 20, 2005

Luke Dallman

L

G

Calculation Method for Quartiles

Guest
Jan 19, 2005

Replies: 2

Views: 159K

Jan 20, 2005

Michael R Middleton

M

R

Is there a formula that will place the sheet name in a cell?

Reed
Jan 19, 2005

Replies: 7

Views: 169K

Jan 20, 2005

Gord Dibben

G

G

Show a time from one calculated cell as a decimal in another cell.

Guest
Jan 20, 2005

Replies: 1

Views: 97K

Jan 20, 2005

Bob Phillips

B

J

Sorting with underlying formulas.

Jay Fincannon
Jan 18, 2005

Replies: 8

Views: 296K

Jan 20, 2005

Max

M

G

? on "date last saved" in cell

Guest
Jan 19, 2005

Replies: 2

Views: 223K

Jan 20, 2005

Guest

G

You must log in or register to post here.

Top