Microsoft Excel Worksheet Functions

Post thread
A
Create Generic Formula for Entire Column
  • Andrea from MN
Replies
1
Views
544
Jacob Skaria
J
J
lookups and sums?
  • jb
Replies
1
Views
288
Jacob Skaria
J
G
Creating a formula
  • GAW
Replies
1
Views
258
Jacob Skaria
J
R
Hyperlink to a specific worksheet in another workbook
  • Romileyrunner1
Replies
5
Views
674
Jacob Skaria
J
D
Normal distribution curve
  • Dave
Replies
2
Views
869
ryguy7272
R
L
NETWORKDAYS Formula
  • LJ
Replies
1
Views
567
Chip Pearson
C
N
Round dates to weekdays
  • Nan
Replies
8
Views
2K
T. Valko
T
B
Remove Text
  • Brandon
Replies
7
Views
509
Gord Dibben
G
J
Protecting data after entering
  • jimbo
Replies
1
Views
329
Otto Moehrbach
O
A
Formula to get number of days excluding Fridays in a given period
  • Abdul
Replies
17
Views
976
Bernd P
B
M
Error Message when I open Workbook
  • Mouimet
Replies
1
Views
1K
Mouimet
M
B
take some data column into next column ie ABC-DEF-GHI i want DEF
  • Bernard
Replies
6
Views
541
Gord Dibben
G
T
Product formula help
  • txsharla
Replies
6
Views
494
T. Valko
T
Z
Multiple IF/AND/OR statments
  • Zakynthos
Replies
12
Views
647
Joe User
J
S
Can you insert a shortcut to a different workbook?
  • Sheila
Replies
1
Views
342
Jacob Skaria
J
B
Concatentate text and insert blank line
  • Bethany
Replies
2
Views
639
Bethany
B
G
HOW TOCREATE A DROP-DOWN MENU FOR MACROS
  • grover740
Replies
2
Views
312
Dave Peterson
D
M
Compare List Summary of Results
  • mikew
Replies
3
Views
307
mikew
M
L
Vlookup returns n/a for all lines - what am I missing?
  • Lorina
Replies
3
Views
367
Jacob Skaria
J
A
Adding cells with formulas
  • Amy
Replies
2
Views
757
Tom Hutchins
T
C
percentage in brackets
  • CIW
Replies
2
Views
970
Jacob Skaria
J
J
How do you combine a date field and a time field into one?
  • Janet Kreinbrink
Replies
6
Views
976
Janet Kreinbrink
J
C
adding values lists
  • CalvinFenny
Replies
1
Views
422
Jacob Skaria
J
A
If then statement
  • Anna McKenzie
Replies
4
Views
358
Pete_UK
P
E
Sumproduct igoring hidden value
  • Edward Wang
Replies
3
Views
399
Edward Wang
E
B
average sum of 5rows
  • bill gras
Replies
3
Views
356
Teethless mama
T
N
Working with Excel to control stock
  • Natalia Kenny
Replies
1
Views
671
Otto Moehrbach
O
T
Permanently link Col A edits, inc 'insert row' in multiple workshe
  • Tchipu
Replies
2
Views
505
Squeaky
S
W
Formatting cell
  • WLMPilot
Replies
4
Views
335
Eduardo
E
A
Seperate Name, Street Address & City, State Zip
  • anna f
Replies
5
Views
1K
alex nerdster
A
J
multiplying by variables based off original number
  • jato
Replies
3
Views
369
Hans Terkelsen
H
J
Limit access to range of cells
  • jvs
Replies
1
Views
394
Chaitanya Sagar
C
E
12 dependent series
  • Elton Law
Replies
5
Views
570
Elton Law
E
D
data entry needs to be changed in multiple files
  • drrons
Replies
1
Views
365
ryguy7272
R
F
Workaround no COUNTIFS in 2003
  • fay
Replies
5
Views
857
Teethless mama
T
N
simple counting gone awry
  • Nondisclosure007
Replies
3
Views
376
Joe User
J
D
The ____ qualifier references the header row in the table.
  • David Simmons
Replies
2
Views
1K
Fred Smith
F
M
Week ending calculation
  • Michelle
Replies
6
Views
376
Ashish Mathur
A
M
produce a criteria based list
  • MarkN
Replies
5
Views
419
MarkN
M
A
Summing values within a matrix who are both in a column where theheaders are within a certain numeri
  • Andy
Replies
4
Views
617
Andy
A
C
Can Excel look thru column of text & derive most commone
  • camsown
Replies
4
Views
473
ryguy7272
R
T
Converting Pounfs to US Dollars
  • Tom
Replies
3
Views
583
Sean Timmons
S
A
Lookup a location # with multiple dates
  • Andrea
Replies
2
Views
366
ryguy7272
R
J
Format dates from cvf file
  • Janet Kreinbrink
Replies
5
Views
384
Janet Kreinbrink
J
A
Compare 2 columns and align duplicates into same row
  • AGOLFA
Replies
8
Views
5K
Otto Moehrbach
O
P
Account # is a known the description is not, need to create a look
  • placerpone
Replies
2
Views
356
Daryl S
D
C
Long list into Table to contain only ten
  • Chris Hough
Replies
2
Views
379
T. Valko
T
R
COUNTIF - across 2 columns
  • Rebekah
Replies
11
Views
693
David Biddulph
D
C
simple formula help
  • Cheryl
Replies
5
Views
340
WKH8919
W
P
Running total for 2 columns IF column 3.......
  • paulab
Replies
7
Views
448
Teethless mama
T
Back
Top