Microsoft Excel Worksheet Functions

G
What does the "-{1,7}" do in conjunction with SUM
  • Guest
Replies
3
Views
390K
T. Valko
T
G
Print every other row
  • Guest
Replies
1
Views
160K
Guest
G
G
Lookup Help.... (Please?)
  • Guest
Replies
1
Views
31K
Guest
G
B
Matching formula results to datasets
  • Ben Burns
Replies
3
Views
106K
Ben Burns
B
G
Networkdays with no start date and no end date
  • Guest
Replies
4
Views
203K
Guest
G
G
Conditionally lock a Cell
  • Guest
Replies
1
Views
162K
Guest
G
G
How do I sort two columns without changing the formatting?
  • Guest
Replies
5
Views
129K
Susan
S
G
QUERY data range to populate separate worksheet?
  • Greg Purnell
Replies
3
Views
325K
Don Guillett
D
G
Nested table subtotals
  • Guest
Replies
1
Views
280K
Guest
G
D
VLOOKUP gives duplicate results for "empty" searches
  • Doc Farmer
Replies
4
Views
201K
Pete_UK
P
P
Validation drop-down arrow not showing for SOME users - fine with others?
  • pennie.thomas
Replies
2
Views
500K
[email protected]
P
G
sumif or something
  • Guest
Replies
1
Views
68K
Guest
G
G
Help with nested function
  • Guest
Replies
10
Views
806K
Roger Govier
R
G
MS-Excel Formula
  • Guest
Replies
4
Views
324K
Fred Smith
F
G
create alert when in sheets are grouped
  • Guest
Replies
1
Views
27K
Guest
G
G
dates got me stuck
  • Guest
Replies
3
Views
98K
Guest
G
J
Question using DGET function
  • Jasonm
Replies
1
Views
396K
Jasonm
J
G
What is the priority of Mode function?
  • Guest
Replies
1
Views
229K
T. Valko
T
G
Lookup tables?
  • Guest
Replies
2
Views
197K
Guest
G
G
IF-OR Functions
  • Guest
Replies
3
Views
82K
Guest
G
G
Nested loop
  • giel.vanboxtel
Replies
1
Views
196K
Guest
G
G
Create filename based on cell contents
  • Guest
Replies
7
Views
680K
Guest
G
G
summing daily data by month
  • Guest
Replies
1
Views
388K
T. Valko
T
G
sorting without changing formats
  • Guest
Replies
4
Views
637K
Bill Kuunders
B
G
edit links
  • Guest
Replies
3
Views
290K
Peo Sjoblom
P
B
rearranging data
  • brianjohnalford
Replies
4
Views
264K
[email protected]
B
G
user defined function
  • Guest
Replies
6
Views
69K
Guest
G
D
This ones got me stuck
  • DB
Replies
4
Views
97K
DB
D
G
VLOOKUP Formulas
  • Guest
Replies
3
Views
306K
Guest
G
G
Function termnology
  • Guest
Replies
2
Views
126K
Guest
G
G
Adding numerical values based on multiple values in another column
  • Guest
Replies
6
Views
223K
Harlan Grove
H
G
Multiple Lookup as condition in sumproduct formula
  • Guest
Replies
2
Views
186K
Guest
G
B
reference to other sheet
  • Bakerman
Replies
2
Views
358K
Guest
G
G
Convert Data in a Cell
  • Guest
Replies
1
Views
202K
Guest
G
G
Excel 2003 - in a formula, " changes to @ - what do I do
  • Guest
Replies
1
Views
24K
Guest
G
G
Compounding a percentage
  • Guest
Replies
3
Views
301K
Guest
G
O
VLOOKUP/Index&Match data format issue
  • oscar.olipane
Replies
3
Views
400K
Allan
A
G
Sumproduct copying blanks or how to insert zero into blanks
  • Guest
Replies
4
Views
219K
Guest
G
G
Solver/Data Tables - help pls :)
  • Guest
Replies
1
Views
250K
Guest
G
G
Dragging Data into a new worksheet and arranging it by type
  • Guest
Replies
2
Views
31K
Guest
G
G
cell lookup
  • Guest
Replies
2
Views
45K
Guest
G
G
Help - I need to combine both a SUMIF and COUNTIF into one formula
  • Guest
Replies
7
Views
640K
Guest
G
G
Using multiple IF criteria
  • Guest
Replies
2
Views
53K
Hans Knudsen
H
G
how do i get data from another workbook
  • Guest
Replies
2
Views
217K
Guest
G
G
Formatting Time As hhmmss Gives Me Dates Instead?
  • Guest
Replies
3
Views
446K
Guest
G
G
How to leave the lines on my exel work sheet
  • Guest
Replies
3
Views
274K
George Nicholson
G
G
How can I make my entire document CAPS?
  • Guest
Replies
1
Views
55K
Paul B
P
G
Match data in 2 columns and return data from 3rd column
  • gwtreece
Replies
1
Views
183K
Dave Peterson
D
G
lookup the next matching record.
  • Guest
Replies
5
Views
419K
Max
M
G
Extracting information
  • Guest
Replies
1
Views
65K
Guest
G
You must log in or register to post here.
Back
Top