Microsoft Excel Worksheet Functions

H
Wild Cards in Vlookup
  • Hardeep Kanwar
Replies
3
Views
301K
pshepard
P
R
In Office 07, how do I format my pivot table data?
  • Razzberryzing
Replies
1
Views
79K
Debra Dalgleish
D
K
Two columns Data Validation and Password Recovery
  • Khalil
Replies
1
Views
171K
Shane Devenshire
S
F
Netwrokdays in VBA
  • fi.or.jp.de
Replies
1
Views
100K
Shane Devenshire
S
V
Complex SUM *** Variant of previous post
  • vsoler
Replies
8
Views
901K
Shane Devenshire
S
D
How do I make GRID LINES print LIGTHER
  • dee
Replies
3
Views
239K
Shane Devenshire
S
D
List Management Question- Combining into one
  • Daphtg
Replies
2
Views
143K
Shane Devenshire
S
M
=IF(ISNUMBER(SEARCH("ELB",B2)),"Pipe") add more like "ELB" "FLG"
  • MAHMOUD
Replies
5
Views
287K
T. Valko
T
N
I am using a macro and it cancels my formula
  • Nelly
Replies
3
Views
244K
Don Guillett
D
T
max-ing excel out
  • Tami
Replies
3
Views
117K
Gord Dibben
G
H
Vlookup Match Problem
  • Hardeep Kanwar
Replies
5
Views
276K
JP Ronse
J
V
Complex SUM
  • vsoler
Replies
4
Views
218K
JP Ronse
J
J
index, sumproduct, or other
  • JustBreathe
Replies
2
Views
395K
Ashish Mathur
A
M
SUM only Cells where there is text in Another cell
  • MCook
Replies
1
Views
402K
Ashish Mathur
A
D
List Management ???
  • Daphtg
Replies
1
Views
104K
Shane Devenshire
S
C
Conditional Format based upon if statement and max
  • CARFL97
Replies
11
Views
735K
T. Valko
T
A
Obtain Middle vlaue of text with unknow length
  • Abdul Shakeel
Replies
3
Views
160K
Teethless mama
T
A
Coloring the row and column numbering bars in Excel 2003â€
  • arasan77
Replies
2
Views
168K
bill kuunders
B
V
copy an exact formula without changing cell reference
  • Vidal
Replies
1
Views
90K
pshepard
P
B
Question on my Case of grouping the SW
  • Blue Fish
Replies
1
Views
84K
winnie123
W
B
Search for specific text within last non blank cell in a range
  • Bevo
Replies
2
Views
501K
Bevo
B
C
Vlookup
  • CARFL97
Replies
3
Views
249K
Hardeep Kanwar
H
B
How do I group text from cells into categories
  • bseeley
Replies
3
Views
110K
Shane Devenshire
S
N
PUTTING YOUR OWN TEXT IN EXCEL 2007 COLUMN HEADINGS
  • NewBee@excel2007
Replies
7
Views
442K
JLatham
J
K
Finding last used column
  • ken
Replies
7
Views
196K
ken
K
H
Combining If, Vlookup in formula
  • HR_Payroll
Replies
2
Views
311K
Shane Devenshire
S
L
MRound Formula
  • LauraLee
Replies
3
Views
239K
Shane Devenshire
S
G
THE CUMIPMT() IS NOT PRESENT?
  • Guest
Replies
8
Views
93K
Dave Peterson
D
S
Combine and display values in range in 1 cell but skip blank cells
  • Swiss
Replies
3
Views
188K
Swiss
S
L
Why won't target cell data changes trigger formula evaluation?
  • laura_in_abq
Replies
3
Views
350K
Gord Dibben
G
G
E-mail Addresses Won't Hyperlink in Excel 2007
  • Gretchen
Replies
5
Views
301K
Gord Dibben
G
J
linking data from 2 wrksheets using a common cell value
  • jmasterton
Replies
3
Views
114K
Sean Timmons
S
J
Extend the number of arguments of a function
  • JP Ronse
Replies
9
Views
528K
JP Ronse
J
M
VLookup with 2 criteria
  • Meredith
Replies
6
Views
387K
Ben Webman
B
M
Average Calculation
  • Munchkin
Replies
4
Views
305K
JP Ronse
J
R
SORT DATA ON A PROTECTED WORKSHEET!
  • Romileyrunner1
Replies
2
Views
241K
Romileyrunner1
R
H
count
  • hemusta
Replies
3
Views
41K
Shane Devenshire
S
S
formula help needed
  • stevenkeen
Replies
2
Views
214K
Shane Devenshire
S
S
Need reference for max and [#this row] function
  • SCC
Replies
2
Views
118K
SCC
S
S
ISERROR on GETPIVOTDATA
  • Sarah (OGI)
Replies
1
Views
177K
Shane Devenshire
S
S
Need different formula in table cells
  • SCC
Replies
2
Views
203K
SCC
S
S
Need reference for max and [#this row] functions
  • SCC
Replies
1
Views
21K
Shane Devenshire
S
S
Convert worksheet string name to date format in cell
  • Sabosis
Replies
2
Views
186K
Sabosis
S
A
Coloring the row and column numbering bars in Exce2003
  • arasan77
Replies
2
Views
277K
Kassie
K
S
Create new sheet for each row and include header
  • Sabosis
Replies
1
Views
237K
Don Guillett
D
A
Search for number after specific text in string
  • AMH
Replies
8
Views
303K
AMH
A
S
XIRR versus IRR help!
  • Seth M
Replies
6
Views
599K
JoeU2004
J
T
Can SUMPRODUCT be made to ignore text
  • Thanks
Replies
6
Views
27K
Pete_UK
P
N
dispay numbers as minutes and seconds in excel
  • neilandko
Replies
2
Views
283K
David Biddulph
D
R
Sumproduct error caused by too many curly brackets?
  • Romileyrunner1
Replies
7
Views
695K
Ashish Mathur
A
You must log in or register to post here.
Back
Top