Microsoft Excel Worksheet Functions

J
How do I Hi- lite the max of last 20 entries
  • Joe Goz
Replies
5
Views
208K
Rick Rothstein \(MVP - VB\)
R
A
Extracting data from hyperlinked spreadsheets
  • akfrumtarn
Replies
3
Views
285K
ryguy7272
R
C
Some text won't print from my worksheet
  • Carolyn
Replies
1
Views
96K
Richard O. Neville
R
S
Where are the add-ins
  • Sandy
Replies
2
Views
32K
Tyro
T
D
How do I change a file displayed in thousands to millions?
  • DW
Replies
3
Views
136K
CLR
C
C
Using INDEX and it Returns a #N/A
  • Crazyhorse
Replies
2
Views
277K
Pete_UK
P
S
Lock cell formats (conditional format)
  • Saintsman
Replies
1
Views
92K
ryguy7272
R
R
Pivot Table Source
  • ryguy7272
Replies
3
Views
353K
Ron Coderre
R
R
Percentage function
  • Rachel Bixby
Replies
6
Views
195K
Tyro
T
J
Excel 2007 Vlookup Using New Table Syntax
  • jhcoxx
Replies
2
Views
44K
[email protected]
J
H
First working day of the month
  • Hedgie
Replies
2
Views
492K
Ron Coderre
R
N
Macro to change time format....
  • neilcarden
Replies
1
Views
239K
Bernie Deitrick
B
C
Can function be applied to range in sumif prior to criteria check?
  • Cheese_whiz
Replies
4
Views
189K
Cheese_whiz
C
N
Copying Worksheets
  • Neil169
Replies
1
Views
366K
ryguy7272
R
M
Auto Capital Letter in a cell
  • Montu
Replies
3
Views
408K
Bernie Deitrick
B
J
Obtain row number of active cell
  • Jive
Replies
4
Views
178K
papou
P
C
SUMIF <>
  • Cooz
Replies
4
Views
103K
Cooz
C
J
Tables in Excel Spreadsheets
  • Jamesn Waters
Replies
2
Views
73K
Jamesn Waters
J
C
Calculating quarterly investment returns---XIRR or another function??
  • Carl LaFong
Replies
13
Views
1M
joeu2004
J
B
Making Cells Mandatory and Running Checks
  • Bob Effendi
Replies
3
Views
153K
Bob Effendi
B
R
View Values Formula is using?
  • Richhall
Replies
9
Views
400K
Richhall
R
J
Count Products
  • Jen
Replies
1
Views
74K
Fred Smith
F
B
Identify the row with specific criteria
  • Billy L
Replies
5
Views
585K
CLR
C
R
format a cell
  • Ray
Replies
2
Views
48K
Gord Dibben
G
Q
How do I combine text from adjacent cells?
  • Qegmag
Replies
2
Views
69K
Gord Dibben
G
D
IF statements
  • Dwain Kincaid
Replies
6
Views
83K
Rick Rothstein \(MVP - VB\)
R
B
Sum of digits in a number
  • Bob Ptacek
Replies
3
Views
178K
George Nicholson
G
R
can't click on cell to reference to another workbook
  • reallytryingtogetworkdone
Replies
1
Views
42K
pdberger
P
M
Variabilize File Path or File Name in SumProduct (and Vlookup too)
  • Mike H.
Replies
2
Views
85K
T. Valko
T
D
INDIRECT FUNCTION - I want to freeze reference when inserting rows
  • dim
Replies
3
Views
132K
dim
D
L
If not, then populate.
  • LiveUser
Replies
2
Views
337K
LiveUser
L
P
Date Calcuation with Blank Cells
  • PT40
Replies
5
Views
277K
PT40
P
G
Greater Than formula
  • ginasucasa
Replies
5
Views
568K
Chip Pearson
C
S
how touse features:enter, tab etc while typing text in excel cell
  • samit
Replies
2
Views
114K
Gord Dibben
G
A
Autofill in Various Tabs
  • Ann
Replies
1
Views
383K
Don Guillett
D
G
Adding data from multiple worksheets onto a total's page??
  • Guest
Replies
4
Views
206K
bernieb
B
L
Label template for Excel in Avery size 8160?
  • Lace
Replies
3
Views
465K
[email protected]
J
S
Fix EXACT function so it always compares in the same row.
  • soilcon1
Replies
5
Views
455K
soilcon1
S
H
Incorporating the first 40 out of 250 rows in column values
  • Hans Antlov
Replies
3
Views
434K
ShaneDevenshire
S
S
Excel data sort
  • Stacyb
Replies
1
Views
161K
Jim Cone
J
J
Conditional statements
  • james
Replies
9
Views
386K
james
J
F
Highlight automatically a specific cell
  • Frances Holden
Replies
1
Views
94K
Don Guillett
D
J
Formula
  • james
Replies
7
Views
453K
Gav123
G
B
Trying to get total mileage for a specific month
  • big_chief_hutch
Replies
5
Views
220K
Ron Coderre
R
H
If Statements & Combining Cells
  • Hark2k
Replies
2
Views
58K
Gary''s Student
G
G
Excel Formula Error
  • Griffey5
Replies
15
Views
857K
David Biddulph
D
B
worksheet to worksheet subtotals
  • bernieb
Replies
4
Views
426K
David Biddulph
D
B
adding subtotals from several worksheets
  • bernieb
Replies
2
Views
508K
David Biddulph
D
S
can i avoid repeating rows when adding calculated item in pivot ta
  • sophie
Replies
4
Views
544K
sophie
S
Y
Array extended formula - sort
  • yshridhar
Replies
3
Views
382K
yshridhar
Y
You must log in or register to post here.
Back
Top