Microsoft Excel Worksheet Functions

B
GET.CELL
  • Biff
Replies
2
Views
198K
Biff
B
G
Spreadsheet is only showing formulas not the actual values
  • Guest
Replies
2
Views
160K
Gord Dibben
G
G
format negative values in parenthesis
  • Guest
Replies
3
Views
83K
Gord Dibben
G
L
How can I sum a cell in multiple worksheets as new ones are created.
  • lawhesl
Replies
2
Views
82K
Gord Dibben
G
G
a CHALLANGE using OR in an array formula
  • Guest
Replies
5
Views
64K
Guest
G
G
3-d reference not adjusting when using Fill Handle to copy down
  • Guest
Replies
3
Views
261K
Gord Dibben
G
G
excel template for calculating trial balances and adjusting entri.
  • Guest
Replies
2
Views
273K
Guest
G
G
example if IF(ISNA()) function
  • Guest
Replies
8
Views
194K
Guest
G
G
Data Validation
  • Guest
Replies
2
Views
38K
Guest
G
G
Header included in sort
  • Guest
Replies
1
Views
65K
Frank Kabel
F
G
How do I link an identical cell address across multiple worksheet.
  • Guest
Replies
1
Views
87K
Frank Kabel
F
C
entering matrix formula
  • Christian
Replies
3
Views
154K
Frank Kabel
F
M
OpenFile dialogbox
  • Manu Palao
Replies
1
Views
45K
Jason Morin
J
S
Lookup Data in Several Columns
  • simplywitt
Replies
4
Views
117K
Domenic
D
G
Function help
  • Guest
Replies
2
Views
43K
Guest
G
A
sumproduct to add total amounts for the month
  • Annette
Replies
6
Views
82K
Frank Kabel
F
G
Data Sort
  • Guest
Replies
3
Views
80K
Guest
G
G
Sumproduct
  • Guest
Replies
4
Views
326K
Frank Kabel
F
I
hyperlink based on user's input
  • izbryte
Replies
1
Views
20K
Frank Kabel
F
G
calculate average hours worked
  • Guest
Replies
1
Views
116K
izbryte
I
G
SUMIF across a range of worksheets
  • Guest
Replies
3
Views
191K
Domenic
D
O
Highest Value from Unique range
  • Odysseus
Replies
3
Views
143K
Odysseus
O
G
I have a list of dates that I need to count based on a date range
  • Guest
Replies
4
Views
94K
Guest
G
G
how to use if,and,or functions together in excel
  • Guest
Replies
3
Views
338K
Alex Delamain
A
B
frequency for each occurance
  • bjg
Replies
3
Views
297K
N Harkawat
N
G
Help!!!
  • Guest
Replies
4
Views
189K
Guest
G
J
filter function
  • Johannes van der Pol
Replies
6
Views
125K
Johannes
J
G
about =bahttext()
  • Guest
Replies
2
Views
285K
JE McGimpsey
J
G
combining several individual cells of numbers into one cell
  • Guest
Replies
5
Views
336K
FatOldGit
F
G
Insert column in Pivot Table
  • Guest
Replies
1
Views
91K
Frank Kabel
F
P
Auto Sort
  • Phil
Replies
1
Views
54K
Frank Kabel
F
G
I need a template for stock
  • Guest
Replies
1
Views
29K
Frank Kabel
F
G
Auto Filter will not work in a new worksheet
  • Guest
Replies
1
Views
54K
Frank Kabel
F
G
Fjerning av dobbeltlagringer i liste
  • Guest
Replies
1
Views
202K
Arvi Laanemets
A
G
How do I check for duplications in a range of data (excel)?
  • Guest
Replies
2
Views
180K
Alan
A
H
Roundup
  • Hakan D
Replies
3
Views
68K
Guest
G
G
decimal correction
  • Guest
Replies
2
Views
89K
Guest
G
P
copying text into a macro
  • pagelocator
Replies
1
Views
120K
Harald Staff
H
G
Help for a formula using two conditions
  • Guest
Replies
7
Views
579K
Guest
G
M
Counting unique values + frequency
  • Mike Ferguson
Replies
3
Views
87K
Guest
G
G
I need help to link information such as name, address and phone t.
  • Guest
Replies
1
Views
44K
Frank Kabel
F
G
need look up table to return blank
  • Guest
Replies
2
Views
231K
Aladin Akyurek
A
B
Schedule Rotation Question
  • Bob
Replies
4
Views
252K
Max
M
G
Find a Name, Duplicate a Row, Change a Value
  • Guest
Replies
3
Views
24K
Max
M
G
Change number of columns mid page?
  • Guest
Replies
4
Views
113K
Guest
G
M
hyperlink function
  • Mary
Replies
7
Views
376K
Andrew
A
A
calculate month from week number
  • ankman
Replies
2
Views
248K
bveara
B
O
Formula doesn't calculate correctly
  • OhMarty
Replies
2
Views
47K
BenjieLop
B
G
subtract a running balance from a SUM at the bottom of worksheet
  • Guest
Replies
1
Views
77K
Gord Dibben
G
G
list box length
  • Guest
Replies
2
Views
70K
Gord Dibben
G
You must log in or register to post here.
Back
Top