Microsoft Excel Worksheet Functions

Post thread
B
Finding identical rows in a list
  • Brian Clarke
Replies
6
Views
635
Steve Dunn
S
P
Loose formula/value (when building graphs)
  • PvZ
Replies
3
Views
519
Roger Govier
R
M
Locking A Sheet Using Words & Numbers
  • Mumsy
Replies
3
Views
377
Dave Peterson
D
M
How do I delete a space at the end of an amount or text
  • Maureen
Replies
5
Views
7K
Jacob Skaria
J
J
Filter zeros from two columns, maybe on different rows
  • Jbaccinv
Replies
2
Views
517
Ashish Mathur
A
C
How to calculate the present value of a security, $5000 @ 7%, 20y.
  • catslgc
Replies
1
Views
1K
Tom-S
T
B
Converting number to text
  • booshi
Replies
1
Views
521
Jacob Skaria
J
R
Keyboard shortcut for current date and time
  • Raj
Replies
1
Views
923
Jim Cone
J
G
How do I put a blank value in a cell not using "" in a formula
  • Gunnatrada
Replies
2
Views
620
T. Valko
T
R
Case sensitivity of functions in Excel
  • Raj
Replies
2
Views
910
T. Valko
T
J
Cut, copy & paste functions in Excel 2007 are extremely slow.
  • Joe B.
Replies
4
Views
4K
odingalt
O
V
To protect all worksheet simultaneously in a excel workbook
  • Vimlesh
Replies
1
Views
2K
Gord Dibben
G
U
producing a report via a keyword - filtering and macros not suitab
  • UKMAN
Replies
1
Views
559
Steve Dunn
S
N
Remove columns containing all zeros
  • Nora_GG
Replies
1
Views
461
Nora_GG
N
B
Calculate the number of seconds between two times
  • Budda Belly
Replies
1
Views
1K
Roger Govier
R
W
Formula Discrepancy
  • watermt
Replies
2
Views
729
Steve Dunn
S
S
modifying T. Valko ws function
  • Steve
Replies
5
Views
573
Steve
S
N
Date Formula 85 factor
  • Newfie809
Replies
7
Views
940
Steve Dunn
S
C
IF formula question
  • charlie
Replies
2
Views
300
Lars-Åke Aspelin
L
M
How to know if a worksheet was unlocked
  • Mathieu936
Replies
8
Views
595
Dave Peterson
D
W
HLookup?
  • wagz
Replies
2
Views
461
Roger Govier
R
G
How do I save a header?
  • Global10
Replies
2
Views
2K
Gord Dibben
G
N
V-Lookup variation query
  • njcr83
Replies
2
Views
379
Glenn
G
M
Interpolation?
  • Mel
Replies
1
Views
521
Steve Dunn
S
R
Conditional formula with text and number in cell
  • RichM
Replies
7
Views
819
Steve Dunn
S
R
How does a function provide a blank cell as a result
  • Rene B.
Replies
2
Views
497
Anand
A
P
Reference(s) to worksheets for building graphs
  • PvZ
Replies
4
Views
537
PvZ
P
D
Address must be 18 characters long
  • Derek M
Replies
3
Views
336
Derek M
D
R
Difference between two date/time values
  • Raj
Replies
5
Views
862
Raj
R
M
Sumproduct formula help (possible Index????)
  • Mark D
Replies
7
Views
541
Jacob Skaria
J
M
Can't rework the formula
  • Malcolm
Replies
6
Views
524
T. Valko
T
S
If OR formula
  • Susan
Replies
1
Views
470
T. Valko
T
K
View Message when Mouse Hovers over Cell. (Not the Comments Feild)
  • Kev - Radio Man
Replies
2
Views
1K
Kev - Radio Man
K
R
Getting the content of a cell?
  • Rocky
Replies
1
Views
346
Per Jessen
P
G
Merging Columns
  • Guest
Replies
13
Views
616
vhnbvb
V
M
Lose the 0 in the Total cell
  • Malcolm
Replies
6
Views
467
Malcolm
M
A
File placement with copied sheets
  • AE
Replies
1
Views
443
Mike H
M
R
sheet name in workshhetfunction
  • Radhakant Panigrahi
Replies
2
Views
342
Mike H
M
B
Count number of people
  • burtlake
Replies
4
Views
740
Bernard Liengme
B
M
Remove non-space spaces?
  • msnyc07
Replies
3
Views
712
Bernard Liengme
B
R
Vlookup from different sheets
  • Radhakant Panigrahi
Replies
2
Views
828
Radhakant Panigrahi
R
G
Using a Text Cell to Reference a Worksheet Name
  • Guest
Replies
7
Views
938
Roger Govier
R
S
Excel formula to incrementally increase a value by 1 every 365 day
  • ScheduleMyAppointmentNow_Com
Replies
2
Views
2K
Max
M
C
Showing known cell reference in a popup
  • Colin Hayes
Replies
3
Views
483
FSt1
F
K
Find & replace different years (part of the date)in a column
  • krishna K
Replies
1
Views
391
Jacob Skaria
J
K
Need Help with Sumif Function including dates
  • KDenise
Replies
6
Views
1K
Max
M
J
Using a COUNTIF statement with an AND operator
  • JTurner
Replies
4
Views
779
Ashish Mathur
A
Q
Linking Equations to Highlights
  • Q
Replies
2
Views
430
Ashish Mathur
A
D
Yes - No Interactive Text Box
  • DisMusBeDaPlaz
Replies
1
Views
596
Normek
N
M
Source and Destination worksheet difference
  • Malcolm
Replies
5
Views
734
Malcolm
M
Back
Top