Microsoft Excel Worksheet Functions

P
Sorting by last digit
  • pjamorton
Replies
5
Views
229K
[email protected]
P
G
Not sure if this is possible...
  • Guest
Replies
2
Views
144K
Gord Dibben
G
G
SUMIF help
  • Guest
Replies
6
Views
357K
T. Valko
T
S
Return Matched Numeric Values across Rows
  • Sam via OfficeKB.com
Replies
2
Views
615K
Sam via OfficeKB.com
S
M
Office 2007 Macros
  • Mr BT
Replies
1
Views
20K
Bob Phillips
B
X
Finding a value based on contents of two cells
  • xjetjockey
Replies
3
Views
586K
T. Valko
T
K
Vlookup Help!!
  • kasidickson
Replies
2
Views
109K
[email protected]
K
C
CountIf --- for colours
  • Cowtoon
Replies
3
Views
300K
Bernard Liengme
B
G
Can autofill, as in months or dates, go to the end of the spreads
  • Guest
Replies
4
Views
63K
Gord Dibben
G
S
Return Numeric Labels that have Values >=4 across Single Row
  • Sam via OfficeKB.com
Replies
3
Views
381K
T. Valko
T
G
Auto updating worksheet
  • Guest
Replies
3
Views
78K
Helen Holubowicz
H
D
Getting around 'IF"
  • Dr Traffic
Replies
16
Views
674K
Don Guillett
D
G
Adding and subtracting many columns numbers
  • Guest
Replies
1
Views
74K
Roger Govier
R
R
Reference a cell from a another sheet that is always 24 rows away
  • rhhince
Replies
5
Views
144K
Chip Pearson
C
G
how do i reference a cell with url for web query import?
  • Guest
Replies
1
Views
221K
Guest
G
G
Adding up multiple worksheets by name and totals
  • Guest
Replies
5
Views
899K
Guest
G
G
refresh auto filter
  • Guest
Replies
5
Views
158K
Roger Govier
R
M
Help with a function might be an if
  • mcgrath383
Replies
2
Views
93K
mcgrath383
M
G
Convert dates
  • Guest
Replies
3
Views
327K
Max
M
G
vlookup false gives "#N/A" - can it say something else?
  • Guest
Replies
5
Views
163K
Dave Peterson
D
T
Need Help!! Want to search through 3 columns for a list of keywords
  • The Moose
Replies
7
Views
516K
PY & Associates
P
G
If result of formula is "" (Blank) why is this considered > a num.
  • Guest
Replies
8
Views
156K
Harlan Grove
H
G
Cumulative sum with a ceiling
  • Guest
Replies
6
Views
369K
Chip Pearson
C
A
The =IF key function
  • Ant
Replies
2
Views
27K
Ant
A
G
Finding the first and last entry in a column
  • Guest
Replies
2
Views
172K
T. Valko
T
G
Average minutes per mile
  • Guest
Replies
7
Views
706K
Gord Dibben
G
E
Compare 2 pivot tables and report differences
  • E
Replies
2
Views
237K
E
E
C
Apostrophe Mayhew
  • czarkalashnikov
Replies
1
Views
205K
Debra Dalgleish
D
G
CREATE SERIES OF PERCENTAGE OPTIONS 4 A VALUE. IN A DROP DOWN BOX
  • Guest
Replies
2
Views
84K
Gord Dibben
G
G
File-search results in worksheet
  • Guest
Replies
4
Views
61K
Guest
G
G
how to Stop =TODAY() date function changing byitself
  • Guest
Replies
7
Views
234K
Arvi Laanemets
A
G
Formula not populating from dropdown box.Works when entered manua
  • Guest
Replies
2
Views
284K
Debra Dalgleish
D
G
using SUMPRODUCT() for commissions
  • Guest
Replies
7
Views
372K
JE McGimpsey
J
G
Winners & Losers
  • gotta know
Replies
1
Views
244K
Sandy Mann
S
G
how do i use square root on excel - what is the formula
  • Guest
Replies
4
Views
446K
Guest
G
G
how to count easily
  • Guest
2
Replies
21
Views
489K
Guest
G
D
OR(EXACT(Cell; Range)) does not work properly
  • Dave Peterson
Replies
4
Views
309K
TOM
T
G
CREATE MULTIPLE WORK SHEETS IN A WORKBOOK
  • Guest
Replies
1
Views
125K
Gord Dibben
G
G
consecutive
  • gotta know
Replies
1
Views
125K
Guest
G
W
Sumproduct help
  • Walter Mayes
Replies
11
Views
849K
Roger Govier
R
G
Testing a person's age to be within a range
  • Guest
Replies
10
Views
626K
Roger Govier
R
G
matching Check # for Bank Reconciliation through Excel
  • Guest
Replies
1
Views
173K
Guest
G
B
Free pdf creator which can render hyperlinks?
  • Bob Smith
Replies
2
Views
353K
Bob Smith
B
B
Conditional Formatting
  • Bob Smith
Replies
8
Views
126K
Bob Smith
B
G
Some kind of lookup needed?
  • Guest
Replies
5
Views
102K
Guest
G
G
basic formula for lookup
  • Guest
Replies
11
Views
169K
Guest
G
G
How to sort month dates
  • Guest
Replies
4
Views
151K
David Biddulph
D
G
Sum will not display
  • Guest
Replies
8
Views
205K
Bob Phillips
B
G
how to solve this by countif
  • Guest
Replies
4
Views
93K
Guest
G
G
Including a range of number in a IF (Logical Test) formula
  • Guest
Replies
5
Views
420K
Don Guillett
D
You must log in or register to post here.
Back
Top