Microsoft Excel Worksheet Functions

G
How do I generate random lottery numbers in Excel?
  • Guest
Replies
7
Views
763K
Ragdyer
R
G
More Help Needed with Count formula
  • Greegan
Replies
4
Views
74K
Greegan
G
L
Need help in calculation at specific location
  • Lewis Koh
Replies
10
Views
325K
Lewis Koh
L
S
Error Handling #N/A with AVERAGE Function - Average of values in Row
  • Sam via OfficeKB.com
Replies
13
Views
1M
Sam via OfficeKB.com
S
G
How do you add numerous subtotals in a spreadsheet?
  • Guest
Replies
1
Views
34K
Anne Troy
A
G
My IF(AND passes logical, but doesn't reveal correct results
  • Guest
Replies
6
Views
124K
Guest
G
S
Count Intervals of Filtered TEXT values in Column and Return Count across a Row
  • Sam via OfficeKB.com
Replies
9
Views
937K
Sam via OfficeKB.com
S
G
Extracting Text only
  • Guest
Replies
2
Views
73K
CLR
C
P
Strip leading spaces from cell
  • Pete
Replies
3
Views
396K
CLR
C
G
how to use shift and down arrow keys in a macro?
  • Guest
Replies
1
Views
108K
David McRitchie
D
G
Count number of values in a cell
  • Guest
Replies
3
Views
410K
Guest
G
G
search a series of rows for a specific formating
  • Guest
Replies
2
Views
38K
Biff
B
G
Excel
  • Guest
Replies
2
Views
478K
Flintstone
F
D
Using text and data in formula.
  • Dave the lost
Replies
2
Views
58K
Dave the lost
D
G
look up number in column
  • Guest
Replies
2
Views
330K
Guest
G
B
Drop-Down Colours
  • Bal
Replies
2
Views
45K
Bal
B
G
Formula pull factor from chart based on value of diff field?
  • Guest
Replies
3
Views
201K
Anne Troy
A
R
indirect function?
  • Russ
Replies
6
Views
198K
Russ
R
T
Drop Down Boxes
  • tiab86
Replies
2
Views
105K
Gord Dibben
G
C
sumproduct problem
  • christophe meresse
Replies
3
Views
103K
christophe meresse
C
G
Automatic date
  • Guest
Replies
2
Views
52K
KL
K
G
autosum problems
  • Guest
Replies
3
Views
288K
Max
M
G
How do I pull a date from a separate worksheet using the IF functi
  • Guest
Replies
8
Views
587K
Anne Troy
A
G
How can I replace the path of the linked spreadsheet in a cell?
  • Guest
Replies
2
Views
170K
Guest
G
G
Using the tab key...
  • Greegan
Replies
2
Views
189K
Anne Troy
A
G
Help with conditional formatiing?
  • Guest
Replies
2
Views
58K
abqhusker
A
G
Conversion formula (Proper Case)
  • Guest
Replies
6
Views
67K
David McRitchie
D
L
Need help to reflect number of days in a month.
  • Lewis Koh
Replies
8
Views
109K
Roger Govier
R
G
how do I create or add to a formula . . .
  • Guest
Replies
3
Views
381K
Bob Phillips
B
G
Totaling Hours in Standard Format
  • Guest
Replies
4
Views
80K
Bob Phillips
B
G
Password protection of worksheet when copied and pasted.
  • Guest
Replies
1
Views
27K
Anne Troy
A
G
Referencing lists in a nested IF formula
  • Guest
Replies
1
Views
309K
Biff
B
G
In Excel, how do we convert text into number (value)?
  • Guest
Replies
1
Views
26K
Biff
B
G
I need help with a macro which will copy a worksheet and..
  • Greegan
Replies
2
Views
85K
Greegan
G
G
UPDATED - Referencing named Ranges within a Nested IF formula
  • Guest
Replies
1
Views
311K
Biff
B
G
How Do I Enter Data Into A Single Cell
  • Guest
Replies
3
Views
121K
Paul B
P
G
How do I work with part of a cell entry?
  • Guest
Replies
4
Views
393K
Guest
G
G
change headers from letter to number/number to letter
  • Guest
Replies
1
Views
75K
Biff
B
G
Count Function Help
  • Guest
Replies
4
Views
156K
Bob Phillips
B
G
Index, Match, Offset? Not sure which to use
  • Guest
Replies
4
Views
168K
Guest
G
G
VLOOKUP - dealing with lookup_value differences
  • Guest
Replies
1
Views
120K
Biff
B
G
Indirect or Vlookup Function
  • Guest
Replies
1
Views
87K
Biff
B
G
Need a little help w/ COUNTIF
  • Guest
Replies
1
Views
37K
Sandy Mann
S
G
Can I get Excel not to save a file if certain information is not i
  • Guest
Replies
4
Views
75K
Bernie Deitrick
B
G
excel function
  • Guest
Replies
6
Views
132K
Guest
G
G
how do I print a page with only grid lines showing
  • Guest
Replies
2
Views
264K
Gord Dibben
G
G
how do I add another page with different cell sizes?
  • Guest
Replies
1
Views
25K
Gord Dibben
G
I
Quotations and blanks cells (that aren't)...
  • Ingeniero1
Replies
3
Views
276K
swatsp0p
S
B
Possible to insert cell data in the middle of line of text?
  • Bob Smith
Replies
6
Views
141K
Bob Smith
B
D
REALLY COMPLICATED--the sooner you can help the better
  • Derek Y via OfficeKB.com
Replies
4
Views
199K
Derek Y via OfficeKB.com
D
You must log in or register to post here.
Back
Top