Microsoft Excel Worksheet Functions

P
Highlight rows if duplicates are found
  • Pierre
Replies
3
Views
324K
Glenn
G
M
count values in range based on value in same row
  • Mick Bonser - newbold
Replies
1
Views
89K
Bob Phillips
B
C
Looking up both row and column to give a third value
  • CameronM
Replies
2
Views
121K
John
J
B
multiple match
  • bill gras
Replies
4
Views
509K
bill gras
B
J
AND formula
  • Jafferi
Replies
2
Views
341K
Eduardo
E
E
Is there a more efficient way to write this SUMPRODUCT
  • enna49
Replies
4
Views
424K
Per Jessen
P
E
Vlookup and rounding
  • excelrookie
Replies
3
Views
279K
Ashish Mathur
A
A
Multilayered Spreadsheet Function
  • Ali14
Replies
1
Views
141K
Ashish Mathur
A
F
Auto fit row height
  • Fountain
Replies
2
Views
419K
Dave Peterson
D
P
using two cells 1 with total time n 1 with date how can i put the.
  • Peter Gonzalez
Replies
2
Views
394K
Peter Gonzalez
P
M
subtracting 2 cells but only if 1st cell is greater than 0
  • Maureen
Replies
1
Views
309K
FSt1
F
W
calculate percentage from cells in different worksheets
  • wissam
Replies
1
Views
155K
T. Valko
T
J
Vlookup and retrieve values 1 row below the normally retrieved val
  • Jon Ratzel
Replies
2
Views
301K
Chip Pearson
C
P
Formula To Bring The Best Name 2
  • peterh
Replies
2
Views
180K
Chip Pearson
C
D
simple formula help for matching information
  • danlinksman
Replies
1
Views
170K
trip_to_tokyo
T
J
Excel - Ignoring the contents of cells when there are letters in thecell
  • James McErlain
Replies
3
Views
326K
Gord Dibben
G
M
Copy and move check box (check boxes) with new cell link?
  • Marty
Replies
1
Views
297K
Gord Dibben
G
S
VLOOKUP to return Cell Address
  • Steve Haack
Replies
3
Views
167K
T. Valko
T
C
SUMIF/AVERAGEIF with mulitle range and sum ranges
  • CSB
Replies
1
Views
16K
T. Valko
T
P
Negative Standard Deviation?
  • PMK
Replies
3
Views
336K
Glenn
G
K
90 day Running total
  • Karen
Replies
1
Views
199K
Herbert Seidenberg
H
C
How do I calculate a specific formula for price increases?
  • Charlie
Replies
3
Views
183K
Charlie
C
B
Comparing two spreadsheets
  • barb
Replies
2
Views
257K
barb
B
D
Rounding dollar amounts in half dollar increments
  • DC
Replies
2
Views
359K
Joe User
J
J
if function?
  • Joann
Replies
2
Views
67K
RonaldoOneNil
R
M
Change listbox text size in Excel 2007
  • Maxwell Crompton
Replies
1
Views
187K
Luke M
L
D
Unhide, Unprotect, Enter Password
  • Don
Replies
2
Views
197K
Luke M
L
M
DSUM - SUMIF - or something else?
  • MAPepin
Replies
3
Views
363K
MAPepin
M
Y
Splitting data from one spreadsheet into multiple spreadsheets
  • yowzers
Replies
2
Views
449K
Ashish Mathur
A
H
Multiple data returning initial hit
  • hp
Replies
3
Views
65K
Ashish Mathur
A
F
Password Userform
  • Freshman
Replies
1
Views
87K
Per Jessen
P
F
typing in a new cell and carrying the formatting of the previous c
  • fadwa
Replies
2
Views
170K
Stefi
S
F
writing a formula in Excel spreadsheet to track how long data has
  • flyboy719
Replies
2
Views
107K
Jacob Skaria
J
T
Vlookup
  • Trainer
Replies
1
Views
249K
Stefi
S
M
Delete a sheet
  • MAX
Replies
1
Views
208K
Per Jessen
P
S
Counting number of cells
  • Sabrina
Replies
4
Views
248K
Sabrina
S
P
Formula To Bring The Best Name
  • peterh
Replies
2
Views
352K
peterh
P
P
Macro Fill
  • palups
Replies
2
Views
167K
Jacob Skaria
J
P
Macro Fill Formula
  • palups
Replies
1
Views
188K
Bob Bridges
B
L
Multiple Variables in Conditional Formatting with Excel 2003
  • Lonnie Clute
Replies
1
Views
282K
Bob Bridges
B
A
Conditionally formatting numeric data and text differently
  • Albannach
Replies
1
Views
134K
Dave
D
C
Number Formatting Issue
  • Cathy Landry
Replies
1
Views
166K
Fred Smith
F
A
Display tabs for all worksheetts at bottom
  • Ann Gaston
Replies
2
Views
149K
T. Valko
T
D
Collated Survey Analysis Finding Average
  • Debbie D.
Replies
4
Views
313K
Debbie D.
D
M
testing for left 2 characters in set of 3 choices
  • MusicMan
Replies
5
Views
94K
Teethless mama
T
U
SUMIF and multiple criteria
  • UCfts
Replies
3
Views
410K
UCfts
U
D
Data Matching
  • Demosthenes
Replies
1
Views
207K
Don Guillett
D
C
Unstring in excel
  • chuck
Replies
4
Views
190K
Don Guillett
D
B
create list based on criteria
  • Bexi
Replies
1
Views
188K
Eva
E
A
Correcting Multiple Div#0s
  • ANTBOH
Replies
6
Views
280K
Eva
E
You must log in or register to post here.
Back
Top