Microsoft Excel Worksheet Functions

A
lookup data across worksheets, one with 56K rows
  • AlfNeuman
Replies
4
Views
349K
Glenn
G
J
COPY SEVERAL FORMULAS FROM ONE WORKSHEET TO ANOTHER WORKSHEET
  • jackie
Replies
3
Views
34K
jackie
J
M
Trying to transpose a row to a column - it is not working - help!
  • MRAWLS
Replies
4
Views
28K
Shane Devenshire
S
T
=IF(test,true,false) only ever returns "true"?
  • TagTech
Replies
3
Views
325K
TagTech
T
P
SlNo.
  • Pai
Replies
3
Views
367K
Pai
P
J
Function or Code Needed
  • Jennifer
Replies
6
Views
34K
Bernard Liengme
B
C
Part of VLOOKUP not working
  • Code Numpty
Replies
4
Views
453K
Max
M
L
Output text from numbers
  • LiAD
Replies
7
Views
515K
LiAD
L
J
IF command
  • JRD
Replies
4
Views
47K
xlm
X
T
return a list of names, from a large list of repeated names.
  • The Fru Fru
Replies
9
Views
378K
Max
M
K
Averaging Cells without an Error
  • Kcope8302
Replies
6
Views
634K
Jarek Kujawa
J
I
hy i m pratap i want to about AND command in excel
  • i my name is pratap and
Replies
2
Views
33K
David Biddulph
D
J
recorded macros
  • Jemma
Replies
3
Views
213K
Mike H
M
M
How do I Hyperlink to document using filename in cell?
  • Matt Bennette
Replies
3
Views
402K
Matt Bennette
M
A
Setting a column read figure from table
  • atikah
Replies
2
Views
32K
Max
M
K
HOW DO I UPDATE MONTHLY AVERAGES
  • kimmiep
Replies
1
Views
201K
Ron@Buy
R
N
auto shift down a cell after entering data
  • Newpeeky
Replies
1
Views
176K
Ron@Buy
R
H
CREATING FORMULA FOR CALCULATING ENDING BALANCE WITH PMT AND INTRE
  • HEIDI
Replies
1
Views
309K
Ron@Buy
R
L
Sumproduct with weekend day test
  • Loge
Replies
4
Views
322K
T. Valko
T
B
Nested if(and(or)) function?
  • budward
Replies
9
Views
778K
budward
B
E
List of cells that were selected
  • esecan
Replies
3
Views
241K
esecan
E
B
removing drop down option after its been selected
  • bbennett2
Replies
4
Views
520K
Max
M
J
looking for a formula please.
  • john
Replies
5
Views
426K
Harlan Grove
H
D
Deletion Of Cells
  • DDD
Replies
1
Views
312K
Sheeloo
S
M
combine columns of data from multiple worksheets into one
  • Michael
Replies
7
Views
337K
Michael
M
I
Is it possible to add a cover page to excel worksheet?
  • ialeite
Replies
1
Views
15K
Fred Smith
F
M
Removing zeros from data list
  • mokihi
Replies
4
Views
203K
T. Valko
T
C
Excel - Averaging
  • Christy
Replies
5
Views
538K
muddan madhu
M
P
Grouping dates in PT; need last 6 month data
  • Pierre
Replies
5
Views
493K
Ken Wright
K
G
Help needed with creating a Formula in Excel 2007 please ?
  • Gerry1234567
Replies
11
Views
540K
Sandy Crowley
S
S
Counting items with a specific quanitifier in a date range
  • sprillaman
Replies
3
Views
401K
Teethless mama
T
V
Formula works only if other sheet is open
  • Vince
Replies
6
Views
307K
Vince
V
S
Populate formula results in cells to next unique result. VBA or Fu
  • Sandy Crowley
Replies
1
Views
589K
Sandy Crowley
S
J
Repeating formulas when inserting new row
  • junzworld
Replies
3
Views
408K
Gary''s Student
G
K
Text removal question
  • knowshowrosegrows
Replies
5
Views
99K
Rick Rothstein
R
E
I can't reference a cell as the criteria in the AVERAGEIFS functio
  • Evan
Replies
2
Views
463K
T. Valko
T
R
Need formula help
  • Ross
Replies
8
Views
249K
T. Valko
T
G
Can I make a formula that always uses the latest wksht in Book2?
  • grateful
Replies
2
Views
458K
grateful
G
S
lookup with match
  • stacy.burk
Replies
4
Views
466K
xlm
X
I
my excel is not responding to arrow keys, what do I do?
  • ifeoma
Replies
1
Views
72K
Glenn
G
S
Copy several formulas from....
  • Shane Devenshire
Replies
1
Views
227K
Glenn
G
J
Excel 2007 Copying Worksheets
  • jej617
Replies
2
Views
174K
jej617
J
C
Time stamp revisions (not just when open/print file)
  • Cando :o)
Replies
2
Views
51K
Shane Devenshire
S
J
I need a formula please.
  • John WEC
Replies
8
Views
131K
John WEC
J
K
IF Macro / Function
  • Kimmon
Replies
7
Views
93K
Teethless mama
T
G
How do I follow an arrow to a worksheet icon when tacing dependent
  • goblue
Replies
1
Views
102K
Max
M
D
VLOOKUP and Auto Fill problesm
  • Dylan @ UAFC
Replies
1
Views
300K
Max
M
L
Comparing YTD numbers between last year and present
  • LilBeanie1033
Replies
1
Views
78K
Eduardo
E
G
date subtraction
  • geert.van.ransbeeck
Replies
6
Views
53K
[email protected]
G
J
VBA problem for forumla with relative reference
  • Joanne
Replies
2
Views
190K
Joanne
J
You must log in or register to post here.
Back
Top