Microsoft Excel Worksheet Functions

P
HELP COUNTING
  • Pat Brewington
Replies
6
Views
146K
Bob Phillips
B
G
How to determine color of a cell?
  • Guest
Replies
2
Views
322K
Guest
G
G
Lookup value in table
  • Guest
Replies
5
Views
257K
Biff
B
G
Forecast using 2 data sets
  • Guest
Replies
1
Views
206K
Mike Middleton
M
M
Excel VBA bug?
  • markx
Replies
1
Views
228K
Ron de Bruin
R
G
Keep cursor in 1 cell
  • Guest
Replies
5
Views
330K
Niek Otten
N
G
meaning of : IF(Switch; Average(array A, array B); array A)
  • Guest
Replies
1
Views
128K
Bernard Liengme
B
T
Counting multiple values within single cells
  • Terry Bennett
Replies
5
Views
172K
Guest
G
G
Formula Help
  • Guest
Replies
1
Views
81K
Guest
G
G
Worksheet function: last saved date
  • Guest
Replies
1
Views
55K
Guest
G
G
How can I sort or search the sheet tabs?
  • Guest
Replies
3
Views
113K
Dave Peterson
D
R
=IF(B1,"",SUMPRODUCT(--(B$1:B$5=""),--(A1<A$1:A$5))+1), Biff formula
  • Rasoul Khoshravan
Replies
1
Views
63K
Guest
G
G
Extract Symbol
  • Guest
Replies
9
Views
349K
Guest
G
L
Rearranging Data Within a Cell
  • LDL
Replies
5
Views
274K
LDL
L
J
Passwords in macros
  • Julian Glass
Replies
1
Views
130K
Paul B
P
G
Automatically display filter range in report header in Excel
  • Guest
Replies
3
Views
182K
Guest
G
G
Cell to cell hyperlinking does not work, please help
  • Guest
Replies
1
Views
82K
Bernard Liengme
B
G
Count months away betwwen a strat and end date by month
  • Guest
Replies
1
Views
378K
Bernard Liengme
B
R
SUMPRODUCT, SUM(IF(...), or some combination?
  • roberthofheimer
Replies
2
Views
384K
RobertH
R
G
HOW TO ASSIGN NUMERICAL VALUES TO LETTERS IN EXCEL
  • Guest
Replies
5
Views
415K
Guest
G
G
Hyperlink using a variable destination
  • Guest
Replies
1
Views
41K
Bernie Deitrick
B
G
Change Tab colour using Macro
  • Guest
Replies
4
Views
85K
Guest
G
G
what does { and } mean in an Excel formula?
  • Guest
Replies
2
Views
476K
Pete_UK
P
F
AND function?
  • fish
Replies
4
Views
175K
fish
F
G
How do I match up two tables of data with one column in common
  • Guest
Replies
1
Views
130K
Guest
G
G
add text in a cell to trigger a calculation
  • Guest
Replies
3
Views
280K
Pete_UK
P
G
Nexted if()s are limited to Seven What other functions can I use?
  • Guest
Replies
8
Views
333K
Guest
G
G
Dsum date based on selection of months
  • Guest
Replies
1
Views
141K
Biff
B
G
Formulae Help, should be easy...
  • Guest
Replies
2
Views
99K
Guest
G
G
I need a template for my supply inventory
  • Guest
Replies
4
Views
65K
Guest
G
G
5 minutes intervals
  • Guest
Replies
2
Views
167K
Pete_UK
P
G
Copy a table from a web site, then manipulate the data?
  • Guest
Replies
1
Views
153K
Don Guillett
D
J
automation autosave .xls as .txt
  • jim sturtz
Replies
5
Views
276K
Guest
G
G
FUNCTION STABILITY
  • Guest
Replies
5
Views
94K
Guest
G
G
matching two worksheets and return to different value
  • Guest
Replies
2
Views
383K
smw226 via OfficeKB.com
S
G
my mouse pointer locks on a cell in excel
  • Guest
Replies
4
Views
461K
Dave Peterson
D
G
VBA language question.
  • Guest
Replies
1
Views
178K
Sandy
S
G
Lookup multiple values return one value corresponding value Excel
  • Guest
Replies
1
Views
243K
Biff
B
G
Parameters question
  • Guest
Replies
5
Views
750K
Guest
G
G
change tab colour when using conditional formatting in a cell
  • Guest
Replies
6
Views
402K
Guest
G
G
how do i make negative numbers equal zero
  • Guest
Replies
2
Views
201K
Guest
G
G
How can I check for dupes in more than one column in excel?
  • Guest
Replies
1
Views
291K
Guest
G
G
Round to up to a threshold
  • Guest
Replies
6
Views
158K
Guest
G
G
How to return value from functions in other sheets?
  • Guest
Replies
3
Views
668K
Guest
G
M
Cell contents in header/footer
  • mdavison
Replies
5
Views
493K
mdavison
M
G
REVERSE SINGLE CELL TEXT STRING
  • Guest
Replies
2
Views
198K
Biff
B
G
Vlookup formula criteria
  • gmunro
Replies
3
Views
350K
Biff
B
M
Whats wrong with this OR formula?
  • Mark
Replies
4
Views
160K
Pete_UK
P
H
Unhide and hide columns
  • hamad.fatima
Replies
1
Views
194K
Dave Peterson
D
G
Create a List by formula from other data
  • Guest
Replies
1
Views
105K
Biff
B
You must log in or register to post here.
Back
Top