Microsoft Excel Worksheet Functions

A
Sumproduct with filters
  • Andy
Replies
7
Views
341K
Mike H
M
S
count of max occcurances
  • stuart
Replies
9
Views
237K
Ashish Mathur
A
F
how i do this in EXCEL
  • FROM SA
Replies
4
Views
316K
Stefi
S
K
Formula - Budgeting
  • KD7410
Replies
2
Views
117K
KD7410
K
H
Sumproduct thru blank cells
  • Harsh Bahal
Replies
4
Views
169K
Harsh Bahal
H
D
Editing Weekly Inventory
  • Determined
Replies
1
Views
173K
Shane Devenshire
S
J
Populate days of the month in a column by checking on date
  • Joe
Replies
4
Views
415K
T. Valko
T
E
Sumproduct criteria
  • Eric
Replies
6
Views
583K
Harsh Bahal
H
I
Need LOOKUP to find the number above not below the specified numbe
  • Ivan
Replies
1
Views
31K
T. Valko
T
M
multiple formual'a that equal the same thing
  • machinist 101
Replies
2
Views
328K
machinist 101
M
A
FILTERS
  • ACCOUNTING GAL
Replies
1
Views
111K
Gord Dibben
G
K
Equation...help needed!
  • kippers
Replies
1
Views
284K
[email protected]
J
S
I can't get the lower margin to zero in Excel
  • Steeltipper
Replies
3
Views
252K
Gord Dibben
G
G
increasing or decreasing a cell
  • gma
Replies
16
Views
590K
gma
G
M
highlight cell
  • MAX
Replies
1
Views
208K
Otto Moehrbach
O
C
Copy and paste
  • Carl
Replies
3
Views
229K
Carl
C
D
Need Text columns to pull into subtotal lines
  • Denise
Replies
7
Views
239K
Ashish Mathur
A
J
Lookup and return range of values
  • Jose Mourinho
Replies
3
Views
29K
Ashish Mathur
A
R
HELP PLOTTING
  • Raz
Replies
2
Views
377K
Ashish Mathur
A
R
How do I find a macro in Excel?
  • RJ
Replies
2
Views
185K
Gord Dibben
G
G
Correct Count
  • GAIDEN
Replies
8
Views
618K
T. Valko
T
C
function stumped
  • Curt
Replies
3
Views
352K
T. Valko
T
N
How can we run FIFO Inventory in excel?
  • NH
Replies
1
Views
153K
Gary Brown
G
J
How to calculate # of days
  • Jonathan
Replies
3
Views
210K
Gord Dibben
G
M
Calculation completion date/time
  • MPI Planner
Replies
6
Views
422K
Glenn
G
S
Function to extract data from a list
  • sot
Replies
2
Views
404K
Herbert Seidenberg
H
S
function question
  • SteveDB1
Replies
2
Views
160K
SteveDB1
S
A
Linear Regression
  • al boccia
Replies
8
Views
738K
jls416
J
G
"If" function question
  • Gina
Replies
3
Views
276K
Shane Devenshire
S
H
Interpolation within a data table
  • hellmouthpirate
Replies
8
Views
221K
Bernd P
B
A
how can i set up changing invoice numbers in excel?
  • aninya
Replies
1
Views
127K
Niek Otten
N
J
value vs formula
  • Joe
Replies
8
Views
135K
Joe
J
C
Custom number format via formula
  • cube.head
Replies
3
Views
174K
cube.head
C
B
Freefloating?
  • bgkgmg
Replies
2
Views
25K
bgkgmg
B
B
TEXT Formula
  • Buckeyefan
Replies
2
Views
182K
jaf
J
M
Index Match
  • Mike B
Replies
3
Views
134K
Niek Otten
N
S
How can I use the SUMIF function using multiple criteria
  • Steve
Replies
1
Views
197K
Luke M
L
C
IF with substraction
  • Carolina
Replies
8
Views
601K
Carolina
C
M
IF Statement calculating Average if you have numeric & text respon
  • mellermj
Replies
2
Views
125K
mellermj
M
H
Search one worksheet to pull data into another worksheet
  • HyperMite
Replies
6
Views
559K
HyperMite
H
B
Evaluating more than 30 conditions using a formula
  • bevchapman
Replies
1
Views
292K
Mike H
M
D
Using Match to find value on worksheet
  • Dkline
Replies
3
Views
35K
Dkline
D
S
Index Match
  • Steven
Replies
4
Views
573K
Mike B
M
S
count if the two cells are equal
  • sdwilson
Replies
3
Views
85K
Dave Peterson
D
V
link formulas sheet 1 to same cells for sheet 1,2,3 etc
  • Vic
Replies
5
Views
569K
Ashish Mathur
A
J
How to divide a number with "less than" sign? ie: <1/1000 = <0.001
  • justinbeau
Replies
3
Views
180K
David Biddulph
D
M
information between multiple workshheets
  • minimoi
Replies
1
Views
65K
Jacob Skaria
J
M
Lookup in multple worksheets
  • Mike B
Replies
5
Views
412K
Mike B
M
M
multiple formula's in one row
  • machinist 101
Replies
2
Views
75K
machinist 101
M
P
Entering 6 digit numbers into a cell with zeros at the beginning
  • Pet710
Replies
2
Views
148K
Dave Peterson
D
You must log in or register to post here.
Back
Top