Microsoft Excel Worksheet Functions

Post thread
M
Use of Vlookup vs Index-Match (workbook size)
  • MK
Replies
1
Views
472
Bob Phillips
B
S
Rotational Date Changes
  • SAM
Replies
7
Views
371
Rick Rothstein \(MVP - VB\)
R
D
What formula would transpose stale dated cells?
  • Debbie
Replies
1
Views
518
Max
M
J
Conditional Formatting (Icon sets - 3 Arrows)
  • Jackie
Replies
2
Views
1K
Jackie
J
A
Lookups...
  • ajayb
Replies
3
Views
417
Pete_UK
P
I
Help! Need to lookup referencing 2 variables
  • I M Desperate!!!
Replies
3
Views
305
Max
M
J
Find value in column, return value in same position of other colum
  • Josiecorey
Replies
1
Views
400
Pete_UK
P
G
Calculating Dates
  • Gina1737
Replies
1
Views
314
Pete_UK
P
R
Update
  • robzrob
Replies
2
Views
277
robzrob
R
P
Characters in cell.
  • poirot
Replies
1
Views
294
Gary''s Student
G
J
macro averages number above and below
  • J-Chef-T
Replies
4
Views
543
Dave Peterson
D
C
regression- estimated output table extend beyond bounds wksht
  • Chuck
Replies
1
Views
8K
Mike Middleton
M
S
Multiple workbook data imported into single workbook
  • SaipanRick
Replies
4
Views
736
Dave
D
M
Need to assign new codes
  • Mat
Replies
3
Views
278
Dave
D
R
CONDITIONAL FORMATTING
  • robzrob
Replies
3
Views
285
robzrob
R
J
worksheet LOCKED
  • James8309
Replies
2
Views
298
Spiky
S
C
Pivot Table
  • carl
Replies
1
Views
289
Bernie Deitrick
B
B
Counting Days
  • Belinda7237
Replies
2
Views
310
Belinda7237
B
R
Reference cell above in a subtotaled sheet
  • Rubystarx
Replies
2
Views
351
Rubystarx
R
S
Using text to lookup different table arrays in vlookup.
  • stuart
Replies
2
Views
527
stuart
S
S
Sorting data in multiple columns
  • Sadie5757
Replies
2
Views
247
Spiky
S
D
austrian number formats
  • DianeG
Replies
11
Views
360
Bernard Liengme
B
J
a cell in excel will not display the formula total
  • John
Replies
2
Views
353
Spiky
S
K
Cost Charge Conundrum
  • kjh198
Replies
2
Views
417
kjh198
K
N
Need a Match formula
  • Nellie2488
Replies
3
Views
354
T. Valko
T
D
Can I insert 'carriage/line returns' in text string?
  • DC-Frank
Replies
1
Views
535
Bob Phillips
B
I
BAG_DEG_DOLU_SAY (COUNTA)
  • ibrahim Ozcan
Replies
2
Views
434
David Biddulph
D
I
How to limit the characters in a cell
  • Igneshwara reddy
Replies
1
Views
380
Bob Phillips
B
M
IF an array..
  • michael
Replies
1
Views
292
Gary''s Student
G
R
compress a potentially long concatenate
  • robzrob
Replies
10
Views
572
robzrob
R
K
Sorting issues
  • KKT
Replies
2
Views
363
Bernard Liengme
B
G
Grades to Marks
  • Greener2224
Replies
5
Views
544
Mike H
M
A
Referencing several cells with IF?
  • andim
Replies
2
Views
359
Pete_UK
P
M
help on vlookup
  • matching names in different formats
Replies
2
Views
366
Pete_UK
P
M
How do I use the HandleNA fomula?
  • mmc0412
Replies
1
Views
321
David Biddulph
D
S
Column I:I blue
  • Steved
Replies
3
Views
362
Stefi
S
L
Autoshow whole word when typing one item in the data validation bo
  • Learning Curve
Replies
1
Views
394
Ken Johnson
K
F
Graph of 2nd serious in the Line type graph is not connected
  • Frank Situmorang
Replies
2
Views
547
Frank Situmorang
F
S
asign the next 10th as the due date.
  • slow but sure
Replies
3
Views
374
Ron Rosenfeld
R
S
Gathering rows of data from multiple wrkbks to single column
  • SaipanRick
Replies
2
Views
397
SaipanRick
S
S
Set day of week to display in date field
  • SaipanRick
Replies
2
Views
436
SaipanRick
S
M
countif
  • mikesteven
Replies
1
Views
361
Don Guillett
D
C
What function to use to return the no. of same value by mths
  • Carol
Replies
4
Views
234
Fred Smith
F
D
Sum / Sumif
  • Dave
Replies
8
Views
410
Dave
D
B
Vlookup Problem
  • Belinda7237
Replies
7
Views
268
Dave
D
D
How does one auto-change values?
  • Darin
Replies
1
Views
292
Gary''s Student
G
L
"Custom" Data Validation
  • leimst
Replies
5
Views
344
T. Valko
T
K
Finding the interest rate.
  • Kevin W
Replies
3
Views
556
Fred Smith
F
B
Making this simple formula
  • Beebs
Replies
3
Views
395
Beebs
B
B
adding a control button with a filter
  • Belinda7237
Replies
2
Views
431
Belinda7237
B
Back
Top