Microsoft Excel Worksheet Functions

B
if function and ifblank() function
  • Bob Phillips
Replies
3
Views
163K
Guest
G
G
Formula not copying down
  • Guest
Replies
6
Views
442K
Guest
G
G
top ten customers by transaction count by product
  • Guest
Replies
2
Views
439K
Guest
G
B
Removing 1-2 caharacters
  • Bob Phillips
Replies
1
Views
106K
Guest
G
B
ranking based on criteria
  • Bob Phillips
Replies
1
Views
176K
Guest
G
G
calculate the sum of characters in a cell
  • Guest
Replies
8
Views
89K
Guest
G
B
How to calculate time after converting 12.22 to 12:22
  • Bob Phillips
Replies
1
Views
79K
Guest
G
G
Concatenate & Date
  • General Specific
Replies
2
Views
169K
Guest
G
G
Text Restrictions
  • Guest
Replies
3
Views
159K
Guest
G
G
sumproduct with one variable criteria?
  • Guest
Replies
11
Views
675K
Epinn
E
G
Conditional Scenario of Text value
  • Guest
Replies
14
Views
969K
Guest
G
G
Counting if between date range
  • Guest
Replies
7
Views
190K
Guest
G
B
Nested IF functions beyond eight items?
  • Bob Phillips
Replies
3
Views
208K
vezerid
V
G
Can I protect a document and still open / close groups
  • Guest
Replies
1
Views
57K
Dave Peterson
D
G
Need ability to get cell address of max value in range
  • Guest
Replies
11
Views
214K
Guest
G
G
Helpful New Functions: ALL and ANY
  • Guest
Replies
6
Views
338K
Stephen Bye
S
G
Adapting MAX function
  • Guest
Replies
4
Views
73K
Guest
G
C
Lookup a row and column and return value
  • Carim
Replies
2
Views
305K
Steve Crombie
S
G
How do I use more than one value in Conditional Formatting?
  • Guest
Replies
4
Views
81K
Guest
G
D
Need big help with look up....is this possible
  • Dan B
Replies
5
Views
536K
Dan B
D
G
skip errors in an average
  • Guest
Replies
8
Views
269K
Guest
G
G
Conditional Formatting
  • Guest
Replies
1
Views
44K
Guest
G
G
Countif & Sumif with Multiple criteria
  • Guest
Replies
6
Views
631K
Bob Phillips
B
G
How do I repair broken links that worked with Excel 2000?
  • Guest
Replies
2
Views
144K
Guest
G
G
formulas within a work book
  • Guest
Replies
1
Views
49K
Carim
C
C
Sum column based on value in each row, if two cells equal, or if date is within time period
  • clynneo
Replies
8
Views
727K
Carim
C
G
SUMPRODUCT WITH A VARIABLE CRITERIA?
  • Guest
Replies
2
Views
225K
Bob Phillips
B
G
Tracking Date/Actual Working Time Elapsed
  • Guest
Replies
1
Views
247K
Guest
G
G
add time
  • Guest
Replies
6
Views
198K
Guest
G
G
Calculate working hours from a start and finish time over several
  • Guest
Replies
1
Views
64K
Guest
G
L
text and formula within the same cell
  • Lucy
Replies
7
Views
301K
Lucy
L
G
SUMIF across multiple worksheets
  • Guest
Replies
11
Views
793K
Guest
G
G
Automotive 5 Year Depreciation
  • Guest
Replies
6
Views
179K
Roger Govier
R
G
how to make an function to list all the same records
  • Guest
Replies
6
Views
291K
Epinn
E
G
CSE formulas
  • Guest
Replies
4
Views
220K
Bob Phillips
B
G
How to switch negative numbers to positive numbers in Excel ?
  • Guest
Replies
2
Views
334K
Arvi Laanemets
A
G
how do i delete rows that end in SMPT
  • Guest
Replies
1
Views
98K
Guest
G
G
Hlookkup/Match won't work
  • Guest
Replies
4
Views
309K
Max
M
G
Flashing cell for conditional formatting as an option
  • Guest
Replies
1
Views
142K
David McRitchie
D
G
formula to choose a hyperlink from a cell
  • Guest
Replies
1
Views
374K
David McRitchie
D
G
SUMIF with the Sum_range across several colums
  • Guest
Replies
7
Views
653K
Biff
B
J
npv calc for customer pay plans
  • Juan Valdez
Replies
1
Views
73K
Fred Smith
F
G
Formatting to show 0 as first number in a cell when input
  • Guest
Replies
5
Views
362K
Max
M
G
Employee Tracking
  • Gymclass14 via OfficeKB.com
Replies
11
Views
176K
Ragdyer
R
G
Worksheet Colour
  • Guest
Replies
2
Views
67K
Epinn
E
G
How do you get the values of the data between data points
  • Guest
Replies
1
Views
165K
Guest
G
G
I'm going crazy, Excel returns 0 for a simple sum
  • Guest
Replies
4
Views
140K
Gord Dibben
G
G
Upper case text
  • Guest
Replies
1
Views
28K
Gord Dibben
G
M
chart or macro problem
  • mcgrath383
Replies
1
Views
28K
Don Guillett
D
C
Need to sum a column if two cells in row are equal
  • cynthiaorser
Replies
1
Views
258K
Guest
G
You must log in or register to post here.
Back
Top