Microsoft Excel Worksheet Functions

Post thread
A
Create Generic Formula for Entire Column
  • Andrea from MN
Replies
1
Views
558
Jacob Skaria
J
J
lookups and sums?
  • jb
Replies
1
Views
311
Jacob Skaria
J
G
Creating a formula
  • GAW
Replies
1
Views
270
Jacob Skaria
J
R
Hyperlink to a specific worksheet in another workbook
  • Romileyrunner1
Replies
5
Views
705
Jacob Skaria
J
D
Normal distribution curve
  • Dave
Replies
2
Views
918
ryguy7272
R
L
NETWORKDAYS Formula
  • LJ
Replies
1
Views
591
Chip Pearson
C
N
Round dates to weekdays
  • Nan
Replies
8
Views
2K
T. Valko
T
B
Remove Text
  • Brandon
Replies
7
Views
533
Gord Dibben
G
J
Protecting data after entering
  • jimbo
Replies
1
Views
338
Otto Moehrbach
O
A
Formula to get number of days excluding Fridays in a given period
  • Abdul
Replies
17
Views
1K
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
561
Gord Dibben
G
T
Product formula help
  • txsharla
Replies
6
Views
537
T. Valko
T
Z
Multiple IF/AND/OR statments
  • Zakynthos
Replies
12
Views
700
Joe User
J
S
Can you insert a shortcut to a different workbook?
  • Sheila
Replies
1
Views
348
Jacob Skaria
J
B
Concatentate text and insert blank line
  • Bethany
Replies
2
Views
676
Bethany
B
G
HOW TOCREATE A DROP-DOWN MENU FOR MACROS
  • grover740
Replies
2
Views
313
Dave Peterson
D
M
Compare List Summary of Results
  • mikew
Replies
3
Views
321
mikew
M
L
Vlookup returns n/a for all lines - what am I missing?
  • Lorina
Replies
3
Views
389
Jacob Skaria
J
A
Adding cells with formulas
  • Amy
Replies
2
Views
771
Tom Hutchins
T
C
percentage in brackets
  • CIW
Replies
2
Views
1K
Jacob Skaria
J
J
How do you combine a date field and a time field into one?
  • Janet Kreinbrink
Replies
6
Views
996
Janet Kreinbrink
J
C
adding values lists
  • CalvinFenny
Replies
1
Views
437
Jacob Skaria
J
A
If then statement
  • Anna McKenzie
Replies
4
Views
379
Pete_UK
P
E
Sumproduct igoring hidden value
  • Edward Wang
Replies
3
Views
404
Edward Wang
E
B
average sum of 5rows
  • bill gras
Replies
3
Views
373
Teethless mama
T
N
Working with Excel to control stock
  • Natalia Kenny
Replies
1
Views
681
Otto Moehrbach
O
T
Permanently link Col A edits, inc 'insert row' in multiple workshe
  • Tchipu
Replies
2
Views
511
Squeaky
S
W
Formatting cell
  • WLMPilot
Replies
4
Views
358
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
378
Hans Terkelsen
H
J
Limit access to range of cells
  • jvs
Replies
1
Views
395
Chaitanya Sagar
C
E
12 dependent series
  • Elton Law
Replies
5
Views
597
Elton Law
E
D
data entry needs to be changed in multiple files
  • drrons
Replies
1
Views
366
ryguy7272
R
F
Workaround no COUNTIFS in 2003
  • fay
Replies
5
Views
867
Teethless mama
T
N
simple counting gone awry
  • Nondisclosure007
Replies
3
Views
385
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
388
Ashish Mathur
A
M
produce a criteria based list
  • MarkN
Replies
5
Views
440
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
641
Andy
A
C
Can Excel look thru column of text & derive most commone
  • camsown
Replies
4
Views
477
ryguy7272
R
T
Converting Pounfs to US Dollars
  • Tom
Replies
3
Views
598
Sean Timmons
S
A
Lookup a location # with multiple dates
  • Andrea
Replies
2
Views
375
ryguy7272
R
J
Format dates from cvf file
  • Janet Kreinbrink
Replies
5
Views
406
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
363
Daryl S
D
C
Long list into Table to contain only ten
  • Chris Hough
Replies
2
Views
397
T. Valko
T
R
COUNTIF - across 2 columns
  • Rebekah
Replies
11
Views
760
David Biddulph
D
C
simple formula help
  • Cheryl
Replies
5
Views
362
WKH8919
W
P
Running total for 2 columns IF column 3.......
  • paulab
Replies
7
Views
461
Teethless mama
T
Back
Top