Microsoft Excel Worksheet Functions

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