Microsoft Excel Worksheet Functions

S
Formula
  • Shepdawg
Replies
2
Views
251K
Glenn
G
G
countif symbols
  • goldsharkfish
Replies
3
Views
371K
Glenn
G
R
I am locked out of the cells on my excell
  • rpercivill
Replies
2
Views
14K
AnthonyHo2008
A
2
Search an alphanumeric in a column and return true/false
  • 2226
Replies
9
Views
509K
Max
M
F
How to HLookup but return a value in a different column.
  • fats_71
Replies
1
Views
351K
Max
M
A
names in different worksheets
  • a m spock
Replies
2
Views
282K
a m spock
A
J
excel 2002
  • John
Replies
1
Views
14K
John
J
T
Count the times a value appears in a column based on another value
  • TrainingGuru
Replies
6
Views
727K
JE McGimpsey
J
M
Looking Up Two Values in an Array
  • Mike M
Replies
4
Views
361K
T. Valko
T
B
COUNT IF WITH 2 CRITERIAS WITH SEVERALS ITEMS ON EACH CRITERIA
  • Bere
Replies
3
Views
195K
T. Valko
T
F
How to do a Vlookup and choose the corresponding Value with highes
  • fats_71
Replies
3
Views
389K
fats_71
F
R
how do I get the last entered value in a column of values
  • Rodney
Replies
12
Views
918K
T. Valko
T
G
How to combine several successive rows into one cell
  • gordom
Replies
2
Views
352K
Sheeloo
S
M
Assigning values to adjacent cells from a function
  • MJ_N_CO
Replies
1
Views
104K
JE McGimpsey
J
G
"filtration" of dataset
  • gordom
Replies
6
Views
401K
Max
M
Y
conditional format
  • Yossy
Replies
3
Views
185K
JE McGimpsey
J
R
Date format in Excel 2007 mm/dd/yy not appearing correctly
  • RickGCR
Replies
2
Views
554K
Shane Devenshire
S
Y
find function
  • Yossy
Replies
5
Views
17K
Yossy
Y
S
COMPARING TWO COLUMNS OF INFORMATION, ACROSS TWO WORKSHEETS
  • Susan
Replies
2
Views
377K
Ashish Mathur
A
O
Floating Titles
  • Olrjr
Replies
4
Views
388K
Max
M
A
Skip Blanks Not Working
  • Adam
Replies
4
Views
319K
[email protected]
K
D
No Analysis Tool Pack=EDATE formula not working! HELP!!
  • Danny Boy
Replies
8
Views
653K
Danny Boy
D
N
Sorting data of various length's, numbers, letters and dash's
  • Nicole
Replies
4
Views
127K
Shane Devenshire
S
F
How do I write up-side-down in Excel?
  • Fredde_kd
Replies
2
Views
22K
Keep It Simple Stupid
K
H
Vlook up value is #N/A
  • Hong
Replies
4
Views
456K
Shane Devenshire
S
S
=IF AND or OR
  • sumif and
Replies
7
Views
821K
Glenn
G
T
State abbrev. TN changes to ten can not type TN as abbre.
  • teresac
Replies
2
Views
35K
Shane Devenshire
S
J
Time Conversion
  • Jodi Macy
Replies
3
Views
354K
Gary''s Student
G
R
Are Protection Options Compatible?
  • Reitanos
Replies
3
Views
281K
Dave Peterson
D
M
Trying to calculate hours worked on timecard using "IF" command
  • Melissa
Replies
6
Views
966K
Shane Devenshire
S
S
Current Time Function
  • Shaun
Replies
11
Views
714K
Shane Devenshire
S
R
Rounding Cell Values
  • RWAMSLEY
Replies
3
Views
543K
Lars-Åke Aspelin
L
B
Date Calculation
  • Bill
Replies
13
Views
226K
Lars-Åke Aspelin
L
E
Macro with custom sort order
  • Erin
Replies
4
Views
328K
Erin
E
K
How do I fix (prevent scrolling) of part of an Excel worksheet?
  • katherin
Replies
2
Views
317K
Eduardo
E
C
Re-establish function on exiting workbook
  • Colin Hayes
Replies
4
Views
541K
Colin Hayes
C
P
Summing only #'s on unhidden columns
  • Peter Trumbo
Replies
2
Views
482K
Dave Peterson
D
R
How to have conditional dropdown
  • Ramki
Replies
1
Views
221K
Roger Govier
R
2
find a alphanumeric in a list
  • 2226
Replies
2
Views
290K
Shaun
S
K
Conditional PRODUCT or SUM
  • Kevin H.
Replies
9
Views
397K
Pete_UK
P
V
Need a Formula for Multiplication of Feet and Inches
  • vmohan1978
Replies
6
Views
319K
vmohan1978
V
A
Labels in formula
  • a m spock
Replies
6
Views
500K
a m spock
A
R
How to restrict input to a list of values - with a twist
  • Rod
Replies
7
Views
427K
Ashish Mathur
A
C
Simple formula, I'm sure
  • Connie Martin
Replies
2
Views
38K
Shane Devenshire
S
M
need a order fill rate spread sheet
  • mv
Replies
2
Views
13K
Shane Devenshire
S
B
How to Lock sort on a data entry sheet.
  • Bob
Replies
1
Views
243K
Bob
B
M
How to sum when the criteria and the range are in the same row?
  • Mo
Replies
2
Views
441K
Mo
M
G
Averaging blank or cells with Zeros in them.
  • Glenn
Replies
4
Views
341K
Glenn
G
V
create overview page; lookup results from multiples worksheet
  • van0710
Replies
5
Views
218K
Shane Devenshire
S
S
Countifs to Sumproduct for 2003 -> was Simple Countifs.. from Fr
  • Steve
Replies
2
Views
319K
Steve
S
You must log in or register to post here.
Back
Top