Microsoft Excel Worksheet Functions

M
Vlookup is adding quotes!
  • Michael Enoksen
Replies
3
Views
327K
Dave Peterson
D
S
Data Disappears When Closed
  • Shawn
Replies
2
Views
243K
Spiky
S
L
Creating reference numbers from column of data
  • LucasD
Replies
3
Views
528K
Glenn
G
G
how to set up an IF formula
  • Gene
Replies
6
Views
299K
Gene
G
G
calculate month
  • Guest
Replies
9
Views
159K
Glenn
G
B
Compare 2 worksheets all 6 columns in each worksheet
  • Bud
Replies
7
Views
434K
Bud
B
C
Filtering by Colour
  • Colin Hayes
Replies
4
Views
105K
Bob Umlas
B
L
=SUMPRODUCT
  • LHerring
Replies
2
Views
125K
Teethless mama
T
R
Referencing data across sheets
  • RDR
Replies
2
Views
432K
RDR
R
C
If statement containing today formula
  • Christi
Replies
8
Views
301K
Christi
C
J
Finding data between blank rows
  • j.ruderman
Replies
2
Views
218K
j.ruderman
J
R
How to differentiate groups of numbers
  • RodJ
Replies
6
Views
43K
Max
M
O
combine data in two cells into a third cell
  • ordnance1
Replies
3
Views
58K
Max
M
T
IF , match formula problems
  • treeroot
Replies
1
Views
140K
Ashish Mathur
A
B
problem with number format with 2 decimals?
  • Brenda
Replies
5
Views
535K
Ashish Mathur
A
S
Return an array based on a lookup
  • seanss
Replies
2
Views
251K
seanss
S
B
collate
  • bubbly_silk
Replies
2
Views
59K
Ashish Mathur
A
K
multiple cell comparisons...nested if formulas?
  • KalliKay
Replies
1
Views
290K
Ashish Mathur
A
A
Choose and Match
  • Atif
Replies
3
Views
29K
ryguy7272
R
B
Why do Excel functions return the text and not run?
  • Bill
Replies
1
Views
339K
Peo Sjoblom
P
E
Array Formula
  • Erin Searfoss
Replies
2
Views
105K
Erin Searfoss
E
D
Sum from different worksheets
  • DSilvers
Replies
1
Views
52K
Pete_UK
P
H
need some columns to auto add decimal pt & others to not - How to.
  • His child
Replies
2
Views
364K
Bernie Deitrick
B
D
How can I change NOW() to a date when combined with text?
  • djenk2
Replies
7
Views
94K
Pete_UK
P
A
Trying to avoid nested IFs
  • Alonso
Replies
8
Views
592K
Pete_UK
P
P
Inserting current date
  • pdaws
Replies
8
Views
281K
Gord Dibben
G
V
Signing Spreadsheets
  • Vercingetorix.XIII
Replies
5
Views
39K
Gord Dibben
G
J
If cell equals a name then get data from column
  • JDB
Replies
2
Views
230K
Gord Dibben
G
K
Displaying and formatting data between tabs
  • Keith J.
Replies
1
Views
243K
Gord Dibben
G
R
Locking a worksheet, but allowing user to add rows in a table
  • Ray Carter
Replies
2
Views
57K
Ray Carter
R
J
How do I set up a time sheet in Excel?
  • Julie Holmberg
Replies
8
Views
980K
Peo Sjoblom
P
S
I want to copy rows with values >0 to another worksheet automatica
  • Skeletor
Replies
4
Views
298K
Gord Dibben
G
D
Can I include both AND and OR in the same function?
  • Dave
Replies
7
Views
139K
Peo Sjoblom
P
L
sumif formula based on dates
  • linnipen
Replies
2
Views
32K
T. Valko
T
C
Highest 50 Day Rolling Average
  • cincyman
Replies
1
Views
305K
cincyman
C
S
Need help with monthly averages, and copying formulas
  • SusanU
Replies
3
Views
248K
SusanU
S
B
LookUp (Date) Value from Forecast Data - From 2nd Sheet
  • Bam
Replies
3
Views
280K
Bam
B
T
convert & multiply (number & time)formulas
  • targueta
Replies
11
Views
489K
MartinW
M
B
validation in a list
  • BoatChief
Replies
1
Views
192K
Sean Timmons
S
K
How to remove duplicated data repeated....
  • Kimmie
Replies
7
Views
527K
Peo Sjoblom
P
S
Excel Formula
  • Stormin
Replies
6
Views
101K
Stormin
S
H
IF statement
  • help!
Replies
4
Views
255K
help!
H
M
Search a cell for a specific number
  • mpenkala
Replies
4
Views
82K
T. Valko
T
L
=sumproduct in Excel 2000
  • LPS
Replies
2
Views
229K
LPS
L
S
Problem with a conditional Min formula
  • SCarroll
Replies
1
Views
232K
Sean Timmons
S
D
%
  • debs27
Replies
4
Views
145K
HARSHAWARDHAN. S .SHASTRI
H
H
Rank – multiple ranges from different worksheets
  • Heather
Replies
3
Views
262K
Lori
L
H
Date Function
  • HARSHAWARDHAN. S .SHASTRI
Replies
6
Views
283K
David Biddulph
D
P
Hghlight the best price for each row
  • PaulinaDi
Replies
5
Views
375K
David Biddulph
D
A
Delete a "locked for editing file by..."
  • an
Replies
3
Views
222K
Dave Roberson
D
You must log in or register to post here.
Back
Top