Microsoft Excel Worksheet Functions

M
Vlookup not sufficient - suggestions for combining multiple matche
  • m
Replies
7
Views
284K
Mike H
M
L
Parsing one part of an address
  • LSSR
Replies
4
Views
380K
Pete_UK
P
K
Formula in Excel
  • kejak28
Replies
3
Views
146K
Mike H
M
C
Autofill summary worksheet
  • Cheryl
Replies
8
Views
599K
Don Guillett
D
A
distribute the collaborators in 3 groups
  • Alexandra Lopes
Replies
5
Views
266K
Alexandra Lopes
A
A
Gauss Chart
  • Alexandra Lopes
Replies
2
Views
87K
Alexandra Lopes
A
T
VLOOKUP with date ranges
  • The Cherub
Replies
6
Views
65K
The Cherub
T
S
Count Records
  • Simon
Replies
5
Views
109K
Ashish Mathur
A
R
Formula in excel
  • Rhianne
Replies
3
Views
250K
Pete_UK
P
Z
VLOOKUP for this problem?
  • Zakynthos
Replies
4
Views
238K
Zakynthos
Z
S
Change format of a date field
  • Sageman
Replies
7
Views
56K
Ashish Mathur
A
P
SUMPRODUCT won't work on a row
  • PFB
Replies
5
Views
497K
Bob Phillips
B
M
Find numbers lower / further than the previous (Track & Field)
  • Mal/Betty
Replies
2
Views
46K
Shane Devenshire
S
A
create popup message
  • Ann
Replies
6
Views
42K
Razak
R
M
transfer data cell from another work sheet
  • MDAM
Replies
2
Views
308K
Ashish Mathur
A
B
VLOOKUP formula
  • Briggs
Replies
3
Views
500K
Sheeloo
S
C
Formula gone awry
  • Connie Martin
Replies
10
Views
354K
Sheeloo
S
H
following the active cell address without recalc
  • haystack
Replies
3
Views
188K
haystack
H
D
Count how many times a phrase comes up?
  • Deplywrker
Replies
3
Views
325K
Shane Devenshire
S
P
i need to get all matches in one column for one criteria
  • PERANISH
Replies
2
Views
327K
Ashish Mathur
A
R
sumifs, sumif with dates
  • Richard Manor
Replies
6
Views
750K
Shane Devenshire
S
R
CountIF(A9:A20, B9 not equal B10, B10 not equal B11, etc.)
  • Red Herald
Replies
2
Views
138K
Ashish Mathur
A
N
Countif with criteria
  • NM
Replies
11
Views
568K
Ashish Mathur
A
M
Count Function
  • Mickey
Replies
5
Views
262K
Gary''s Student
G
T
Conditional formatting if a cell contains a formula
  • tsbarr
Replies
2
Views
370K
Ashish Mathur
A
F
First Non-Blank Cell
  • FrankM
Replies
6
Views
421K
Gary''s Student
G
M
Query Wizard - Choose Columns
  • MichaelRobert
Replies
3
Views
345K
MichaelRobert
M
A
Solver
  • Alonso
Replies
4
Views
441K
Dana DeLouis
D
P
Run data analysis
  • Papergal
Replies
3
Views
108K
Dana DeLouis
D
M
If 5th character="-" delete everything to the left otherwise do no
  • Mike R.
Replies
6
Views
114K
Rick Rothstein
R
A
Summarizing data assigned to a label
  • Al Davis
Replies
2
Views
78K
T. Valko
T
S
how do I round a column of numbers to the nearest
  • Suzy
Replies
3
Views
46K
T. Valko
T
Y
Pivot table help
  • Yossy
Replies
1
Views
77K
Shane Devenshire
S
X
If Than Statement
  • Xfree
Replies
3
Views
283K
Xfree
X
C
split print area in excel - One Page Print
  • Cyhill
Replies
3
Views
477K
Cyhill
C
N
Count with criteria
  • NM
Replies
5
Views
258K
NM
N
R
How do I re arrange numbers
  • Raz
Replies
3
Views
425K
Pete_UK
P
K
Help! Minimum Excluding zeros across multiple sheets
  • kingart69
Replies
5
Views
677K
[email protected]
K
F
Second Saturday Of The Month
  • FrankM
Replies
11
Views
372K
Ron Rosenfeld
R
J
What's causing error message?
  • Jim Tibbetts
Replies
4
Views
277K
Peo Sjoblom
P
E
Referencing an active cell's content from another sheet.
  • emon
Replies
2
Views
39K
emon
E
P
copy a cell value based on search of another cell
  • Pendal
Replies
1
Views
91K
Pete_UK
P
M
multiple ranges, transposing?
  • Mea
Replies
19
Views
446K
Herbert Seidenberg
H
S
Conditional format entire row from one cell
  • Shanie
Replies
2
Views
92K
Shane Devenshire
S
E
cell lookup
  • Excel Challenged
Replies
2
Views
301K
John C
J
B
IF AND statements
  • bob
Replies
6
Views
343K
John C
J
P
function for accessing a database
  • Paul
Replies
2
Views
143K
Paul
P
R
SUMIF and SUM.NUMBER
  • Rockbear
Replies
8
Views
614K
Bob Phillips
B
C
Lookup between two books
  • CSmith
Replies
2
Views
169K
Shane Devenshire
S
H
Pivottable calculated item - how to suppress zero?
  • HMallen
Replies
4
Views
360K
HMallen
H
You must log in or register to post here.
Back
Top