Microsoft Excel Worksheet Functions

Post thread
L
Comparing two ranges and get true or false in one cell depending onresult
  • Leon
Replies
3
Views
473
Leon
L
D
How do I subtotal specific / random rows from a spreadsheet?
  • Duke Bond
Replies
1
Views
520
Tom Hutchins
T
E
Replace hard return with a delimiter?
  • Erin.
Replies
3
Views
659
Ethan Strauss
E
G
SUMPRODUCT not working.
  • Gaurav
Replies
2
Views
341
Gord Dibben
G
P
Cycle Times
  • PAL
Replies
4
Views
474
PAL
P
S
Automatic Cell Copy to other worksheets
  • sharice.g
Replies
1
Views
403
Ron de Bruin
R
L
Excel Comments
  • lisa
Replies
5
Views
343
lisa
L
L
forgoten password
  • Leon
Replies
4
Views
626
Hans Terkelsen
H
R
Merge two columns of data with a condition
  • Richard
Replies
2
Views
340
Lars-Åke Aspelin
L
J
lookup issue....
  • John
Replies
2
Views
259
Gord Dibben
G
B
Using tab key in protected worksheet
  • bev
Replies
4
Views
1K
bev
B
M
Conditional Count Formula
  • Mully
Replies
2
Views
788
T. Valko
T
L
how to use vlookup for more than 1line
  • LHM
Replies
3
Views
440
LHM
L
H
is there a formula that will subtract todays date from a hire date
  • Heather
Replies
4
Views
1K
Shane Devenshire
S
K
how to make a preforated page-break insert
  • KoldKream
Replies
2
Views
501
Gord Dibben
G
H
Sorting Coloumns that are Formula's
  • heritage1450
Replies
1
Views
368
Eduardo
E
T
Woman age 40
  • Tony_student
Replies
9
Views
485
JLatham
J
W
Extracting email address from various data
  • Wade
Replies
2
Views
504
Jacob Skaria
J
V
i need some help in a type
  • Vatos
Replies
2
Views
353
Shane Devenshire
S
S
count value dependent on unique or repeated values in another colu
  • singing_inmysleep
Replies
2
Views
468
RagDyeR
R
R
How do I freeze individual cells with formulas in them
  • Robernaut
Replies
3
Views
1K
Susan
S
H
Check for CAPS
  • Heidi
Replies
3
Views
349
Heidi
H
B
Turn of 'Read Only'
  • Barb
Replies
2
Views
394
Barb
B
J
How do I get Excel to display a table on a different worksheet?
  • John
Replies
7
Views
3K
Stefi
S
L
Array formulas
  • Lynda
Replies
3
Views
430
Shane Devenshire
S
F
Merge 2 datasheets into single Pivot Table.
  • free_ur_mind
Replies
2
Views
4K
Eduardo
E
G
IF formula & formatting
  • Guest
Replies
6
Views
373
Fred Smith
F
B
DSUM using alpha numeric codes
  • brian
Replies
1
Views
412
brian
B
B
Protected worksheet/tab key
  • bev
Replies
2
Views
589
bev
B
J
How to average the last 10 numbers in a row?
  • John P
Replies
9
Views
1K
John P
J
J
Limit data entry in range of cells
  • JStiehl
Replies
2
Views
345
JStiehl
J
M
Sports Tipping Formula!
  • Mully
Replies
1
Views
539
Mully
M
B
Search
  • backmara
Replies
1
Views
304
Joel
J
3
adding a zero in front of a colon
  • 303mike
Replies
5
Views
992
Per Jessen
P
L
Auto-adding text when a certain number is input
  • Lauren
Replies
1
Views
321
Jacob Skaria
J
S
If Statements??/Conditional formatting from drop-down multiple she
  • sarah
Replies
1
Views
375
Sheeloo
S
S
Countif Criteria Reference Cell
  • StephonM
Replies
4
Views
1K
T. Valko
T
R
Finding the first value that is less than zero
  • russhess8
Replies
4
Views
1K
T. Valko
T
F
VLOOKUP returning a #VALUE! error and I've not idea why! HELP!!!
  • forevertrying
Replies
17
Views
645
Scarlett
S
S
Reconize the first digit only
  • Steved
Replies
1
Views
348
Jacob Skaria
J
S
Comparing dates from VLOOKUP functions not working right
  • Sambonator
Replies
2
Views
697
Max
M
M
Hide row based on cell value
  • Munchkin
Replies
2
Views
916
Jacob Skaria
J
T
Making drop down selection lists
  • TheQuickBrownFox
Replies
2
Views
330
FatBytestard
F
D
How can I create a simple form where users can tab between fields
  • DMAC
Replies
1
Views
372
Gord Dibben
G
P
Row Height-expand if text wraps in a cell
  • Penny Miller
Replies
3
Views
678
Gord Dibben
G
M
Pulling data from Sheets in A workbook
  • MRSVATEK
Replies
2
Views
487
Gord Dibben
G
T
Count Unique Values in a column, with critera, exclude empty cells
  • tyrdrannoy
Replies
11
Views
3K
T. Valko
T
D
Sum function
  • dannyboy8
Replies
3
Views
320
Gord Dibben
G
W
sum/autosum not calculating correctly
  • websterk12
Replies
6
Views
3K
Gord Dibben
G
F
Formula for 0
  • Fareez
Replies
4
Views
381
Gord Dibben
G
Back
Top