Microsoft Excel Worksheet Functions

Post thread
S
How to get exact match with LOOKUP function?
  • s51janez
Replies
1
Views
385
Pete_UK
P
N
automatically generate unique serial numbers for invoices
  • nhlanhla
Replies
1
Views
911
Pete_UK
P
A
Find components of an Average Result
  • al_ba
Replies
6
Views
409
Pete_UK
P
S
Copy Rows with a cell value >0 from several worksheets to a new sh
  • Skeletor
Replies
4
Views
414
Skeletor
S
C
Matching a single value, with a value category.
  • classic3283
Replies
2
Views
313
Arvi Laanemets
A
J
Minimum results
  • JD
Replies
4
Views
457
ShaneDevenshire
S
M
excel 2002 functions
  • Mrs Luke
Replies
6
Views
482
Mrs Luke
M
J
COUNTIF Function
  • Jill V
Replies
4
Views
307
Ashish Mathur
A
M
Per day average using DAY360
  • Mark
Replies
3
Views
805
Fred Smith
F
C
multi tiered percentage rent calculation
  • CoreyWA
Replies
3
Views
2K
Fred Smith
F
R
AND & OR function
  • roger
Replies
6
Views
270
Peo Sjoblom
P
E
sum on multiple worksheets
  • exGW
Replies
0
Views
409
exGW
E
J
Using Countif with autofillter
  • John
Replies
4
Views
443
John
J
A
How to make a column of cells have a drop down menu
  • Alzheimer'sResearch
Replies
3
Views
389
ryguy7272
R
L
Linking to data in another file
  • Lenchik
Replies
1
Views
272
Dave Peterson
D
R
Two Levels of Security in Database Tool. ASP Report Maker
  • ryguy7272
Replies
3
Views
423
ryguy7272
R
R
I want to copy one cell value from sheet 1 to sheet 2 conditionall
  • RobertoB
Replies
2
Views
534
ShaneDevenshire
S
D
Using dates in Excel 2003
  • dhmilw
Replies
2
Views
259
dhmilw
D
S
CellColorIndex
  • Steven
Replies
3
Views
444
Steven
S
C
Adding in Excel
  • Corey
Replies
3
Views
317
Corey
C
B
Link all data from several workbooks to one "master" workbook
  • bchin2020
Replies
1
Views
417
Ron de Bruin
R
H
Percentage of a "sum of" amount in a different field of a pivot re
  • HL Questions
Replies
2
Views
679
HL Questions
H
B
excel formulas
  • Brian B
Replies
5
Views
269
Brian B
B
P
Automatic Data Update by Date Range
  • Pinkney.Chandra
Replies
1
Views
390
Duke Carey
D
J
copy paste SQL query result to excel spreadsheet with formatting
  • Juliet
Replies
1
Views
2K
Duke Carey
D
R
Calculating Hours
  • Ruthie
Replies
2
Views
471
Pete_UK
P
M
Fill Series of Disjointed Selection across Rows & Columns?
  • Marie
Replies
5
Views
435
Bernie Deitrick
B
G
significant digits
  • Gordon
2
Replies
20
Views
1K
Bernd P
B
P
Please Help! Getting a funtion to work.
  • PZ
Replies
1
Views
326
Sean Timmons
S
D
Date Sequence 2
  • Daren
Replies
7
Views
373
Pete_UK
P
L
excel simulation formula
  • larry
Replies
1
Views
623
Sean Timmons
S
J
Auto Filter is unavailable - grayed out
  • Julieeeee
Replies
1
Views
633
Dave Peterson
D
R
Microsoft Excel Formula "IF" to create a timesheet
  • reagolly
Replies
3
Views
1K
David Biddulph
D
H
Row Column Cross Hair
  • h2fcell
Replies
3
Views
3K
h2fcell
H
N
merging worksheets into an overall report
  • neebri
Replies
3
Views
793
Ron de Bruin
R
S
Formula Entry
  • Susi
Replies
2
Views
324
Susi
S
D
auto-fill customer address
  • Dgwood90
Replies
1
Views
377
Don Guillett
D
D
Refering cell to the worksheet name
  • Dave
Replies
6
Views
534
ShaneDevenshire
S
S
Counting fileterd cells with spesific value
  • Sjur
Replies
4
Views
526
ShaneDevenshire
S
C
VLOOKUP Function returning multiple values in a separate table
  • CAT
Replies
8
Views
888
CAT
C
G
Please help with Sumproduct, adding additional criteria
  • Gina
Replies
5
Views
479
Gina
G
N
Pivot table creation in excel
  • NRCan13
Replies
1
Views
422
ShaneDevenshire
S
D
How do I get the unique values from a column in excel?
  • Durgesh M
Replies
6
Views
7K
Mike H
M
J
Find a range using code
  • Jonathan Brown
Replies
3
Views
477
Roger Govier
R
W
Nested IF Statements, Months of Year
  • Wendy
Replies
4
Views
692
Arvi Laanemets
A
K
excel
  • Kelley
Replies
2
Views
261
ShaneDevenshire
S
J
Number of records after filter
  • Jon Dow
Replies
2
Views
272
ShaneDevenshire
S
J
Counting the occurrence of data in one column based on two criteri
  • Jim Prentice
Replies
3
Views
697
Jim Prentice
J
P
Nested IF not working.....
  • Patrick
Replies
5
Views
360
JMB
J
L
conditional formatting across rows
  • learningdba
Replies
1
Views
418
T. Valko
T
Back
Top