Microsoft Excel Worksheet Functions

Post thread
E
how do I sum currency values in a row containing currency and uni.
  • Eusebius
Replies
2
Views
834
Don Guillett
D
M
Vlookup not sufficient - suggestions for combining multiple matche
  • m
Replies
7
Views
519
Mike H
M
L
Parsing one part of an address
  • LSSR
Replies
4
Views
403
Pete_UK
P
K
Formula in Excel
  • kejak28
Replies
3
Views
780
Mike H
M
C
Autofill summary worksheet
  • Cheryl
Replies
8
Views
697
Don Guillett
D
A
distribute the collaborators in 3 groups
  • Alexandra Lopes
Replies
5
Views
360
Alexandra Lopes
A
A
Gauss Chart
  • Alexandra Lopes
Replies
2
Views
1K
Alexandra Lopes
A
T
VLOOKUP with date ranges
  • The Cherub
Replies
6
Views
530
The Cherub
T
S
Count Records
  • Simon
Replies
5
Views
468
Ashish Mathur
A
R
Formula in excel
  • Rhianne
Replies
3
Views
317
Pete_UK
P
Z
VLOOKUP for this problem?
  • Zakynthos
Replies
4
Views
607
Zakynthos
Z
S
Change format of a date field
  • Sageman
Replies
7
Views
360
Ashish Mathur
A
P
SUMPRODUCT won't work on a row
  • PFB
Replies
5
Views
1K
Bob Phillips
B
M
Find numbers lower / further than the previous (Track & Field)
  • Mal/Betty
Replies
2
Views
341
Shane Devenshire
S
A
create popup message
  • Ann
Replies
6
Views
391
Razak
R
M
transfer data cell from another work sheet
  • MDAM
Replies
2
Views
378
Ashish Mathur
A
B
VLOOKUP formula
  • Briggs
Replies
3
Views
549
Sheeloo
S
C
Formula gone awry
  • Connie Martin
Replies
10
Views
681
Sheeloo
S
H
following the active cell address without recalc
  • haystack
Replies
3
Views
678
haystack
H
D
Count how many times a phrase comes up?
  • Deplywrker
Replies
3
Views
558
Shane Devenshire
S
P
i need to get all matches in one column for one criteria
  • PERANISH
Replies
2
Views
507
Ashish Mathur
A
R
sumifs, sumif with dates
  • Richard Manor
Replies
6
Views
825
Shane Devenshire
S
R
CountIF(A9:A20, B9 not equal B10, B10 not equal B11, etc.)
  • Red Herald
Replies
2
Views
1K
Ashish Mathur
A
N
Countif with criteria
  • NM
Replies
11
Views
606
Ashish Mathur
A
M
Count Function
  • Mickey
Replies
5
Views
454
Gary''s Student
G
T
Conditional formatting if a cell contains a formula
  • tsbarr
Replies
2
Views
828
Ashish Mathur
A
F
First Non-Blank Cell
  • FrankM
Replies
6
Views
7K
Gary''s Student
G
M
Query Wizard - Choose Columns
  • MichaelRobert
Replies
3
Views
756
MichaelRobert
M
A
Solver
  • Alonso
Replies
4
Views
594
Dana DeLouis
D
P
Run data analysis
  • Papergal
Replies
3
Views
399
Dana DeLouis
D
M
If 5th character="-" delete everything to the left otherwise do no
  • Mike R.
Replies
6
Views
427
Rick Rothstein
R
A
Summarizing data assigned to a label
  • Al Davis
Replies
2
Views
271
T. Valko
T
S
how do I round a column of numbers to the nearest
  • Suzy
Replies
3
Views
516
T. Valko
T
Y
Pivot table help
  • Yossy
Replies
1
Views
273
Shane Devenshire
S
X
If Than Statement
  • Xfree
Replies
3
Views
362
Xfree
X
C
split print area in excel - One Page Print
  • Cyhill
Replies
3
Views
7K
Cyhill
C
N
Count with criteria
  • NM
Replies
5
Views
364
NM
N
R
How do I re arrange numbers
  • Raz
Replies
3
Views
423
Pete_UK
P
K
Help! Minimum Excluding zeros across multiple sheets
  • kingart69
Replies
5
Views
899
[email protected]
K
F
Second Saturday Of The Month
  • FrankM
Replies
11
Views
960
Ron Rosenfeld
R
J
What's causing error message?
  • Jim Tibbetts
Replies
4
Views
450
Peo Sjoblom
P
E
Referencing an active cell's content from another sheet.
  • emon
Replies
2
Views
360
emon
E
P
copy a cell value based on search of another cell
  • Pendal
Replies
1
Views
363
Pete_UK
P
M
multiple ranges, transposing?
  • Mea
Replies
19
Views
693
Herbert Seidenberg
H
S
Conditional format entire row from one cell
  • Shanie
Replies
2
Views
507
Shane Devenshire
S
E
cell lookup
  • Excel Challenged
Replies
2
Views
345
John C
J
B
IF AND statements
  • bob
Replies
6
Views
340
John C
J
P
function for accessing a database
  • Paul
Replies
2
Views
290
Paul
P
R
SUMIF and SUM.NUMBER
  • Rockbear
Replies
8
Views
534
Bob Phillips
B
C
Lookup between two books
  • CSmith
Replies
2
Views
455
Shane Devenshire
S
Back
Top