Microsoft Excel Worksheet Functions

Post thread
C
LOOKUP function reversed?
  • Chris
Replies
3
Views
740
OssieMac
O
D
cond. formating quesiton
  • dlotz
Replies
1
Views
382
T. Valko
T
O
Is it possible to choose a certain amount of rows and have them ex
  • ocean
Replies
6
Views
390
ocean
O
V
Searching multiple fields and then print the entire row from resul
  • Vegeta_matt18
Replies
2
Views
450
Ashish Mathur
A
M
How calculate exact # of months between two dates?
  • Mark Livingstone
Replies
9
Views
3K
Ashish Mathur
A
M
Conditional format stoplight based on worst color
  • Morgimo
Replies
3
Views
602
Gord Dibben
G
F
Displays wrong result
  • FirstVette52
Replies
2
Views
532
Teethless mama
T
B
Lookup Formula
  • BAD
Replies
2
Views
367
Teethless mama
T
B
automatically update a field only when data has changed
  • bigdog2112
Replies
1
Views
311
Niek Otten
N
E
Include email dist. list into a Excel macro - how?
  • Excel problem/challenge
Replies
1
Views
446
Ron de Bruin
R
C
Max with Multiple Ifs
  • ChrisWWiese
Replies
3
Views
523
ChrisWWiese
C
J
Array Function?
  • Johnnie
Replies
4
Views
352
Johnnie
J
C
why does the dateif function result in an error in Excel 2003?
  • Cheryl
Replies
5
Views
1K
Mike H
M
O
Alarm function, disable sound if data is erased
  • offdah3z
Replies
1
Views
1K
Bernard Liengme
B
Z
Remove Password
  • Zita
Replies
3
Views
284
Gord Dibben
G
R
Drop Down Lists: Allow option of adding own data if not in drop do
  • ruperthouse
Replies
8
Views
1K
Gord Dibben
G
V
How the data may stay on top with scroll ?
  • Vladimir Nikolov
Replies
1
Views
377
Eduardo
E
S
Formating a cell
  • Smiley
Replies
5
Views
426
Rick Rothstein
R
J
permanent conversion of 1904 date format to 1900 date format
  • Jos
Replies
3
Views
4K
Harlan Grove
H
L
Custom Format or use function?
  • Lisa W
Replies
4
Views
479
Rick Rothstein
R
F
Cross Reference
  • fgwiii
Replies
1
Views
464
Eduardo
E
L
Count Columns, Return Content
  • Leah G
Replies
5
Views
411
Mike H
M
N
Sums
  • Natalie
Replies
1
Views
378
Eduardo
E
T
Count If Column A = x and Column B = y
  • Trish
Replies
18
Views
1K
Fred Smith
F
S
Highlight a row with the current date.
  • sword_fishx
Replies
11
Views
886
T. Valko
T
P
format number to date
  • Picodillo
Replies
7
Views
489
T. Valko
T
G
Micro
  • Ganesh Kumar
Replies
2
Views
326
Jacob Skaria
J
C
Counting Column
  • Cul
Replies
3
Views
360
Shane Devenshire
S
S
Formula for calculator Table
  • Sky
Replies
8
Views
532
Sky
S
J
Selecting rows within a range
  • JCG
Replies
5
Views
438
Don Guillett
D
D
VLOOKUP or MATCH and/or INDEX to extract value on a given date
  • Don Kline
Replies
7
Views
1K
Max
M
R
auto scrol doune for hyperlink.
  • rajaiy
Replies
2
Views
476
Dave Peterson
D
E
Why doesn't it print the colours?
  • EN
Replies
8
Views
447
EN
E
W
using the Cell function
  • WT
Replies
2
Views
463
T. Valko
T
S
Lookup dates and values
  • Suan
Replies
4
Views
521
Max
M
H
Counting number of rows between date range and meeting 2 string criteria
  • Hii Sing Chung
Replies
11
Views
2K
Hii Sing Chung
H
L
'Smart worksheet'
  • Lorraine.vdWalt
Replies
1
Views
372
RagDyer
R
D
Ignoring Text using the AND OR IF function
  • domgiants
Replies
0
Views
374
domgiants
D
L
Identifying correct elements with Countif
  • Lady Success
Replies
3
Views
472
T. Valko
T
J
Excel 2007 worksheet to WEB page
  • JAW
Replies
3
Views
376
JAW
J
P
Multiple Criteria for Sumproduct
  • Pam
Replies
6
Views
1K
Pam
P
N
Return result of IF logical test in a different cell
  • navyraine
Replies
1
Views
521
T. Valko
T
P
Spliting dimensions down
  • PSM
Replies
3
Views
386
Ron Rosenfeld
R
N
MACRO: Selecting "Cancel" from a drop down to copy and paste entirerow to another sheet
  • Nicole Hannington
Replies
1
Views
448
Bernie Deitrick
B
D
How do I copy the page set up from one worksheet to another?
  • Deb Raskob
Replies
2
Views
367
Jacob Skaria
J
D
Multiple lookups and SUM function
  • DevonDilema
Replies
4
Views
890
Teethless mama
T
J
Formula updates with SAVE AS
  • JenG
Replies
1
Views
301
Bernie Deitrick
B
L
Need to Speed Up A Code
  • LostInNY
Replies
2
Views
377
Per Jessen
P
J
=SUMPRODUCT((C481:C507<>"")/COUNTIF(C481:C507,C481:C507&""))
  • Jeff
Replies
3
Views
322
Eduardo
E
J
Determine Value based on criteria
  • Jan S
Replies
1
Views
430
T. Valko
T
Back
Top