Microsoft Excel Worksheet Functions

Post thread
B
Returning Bottom 10 Percent in another spreadsheet
  • Brandon
Replies
4
Views
434
Max
M
I
Arrays/vlookup???
  • Ian
Replies
6
Views
562
Ian
I
C
interpolation within subranges
  • Christopher Glaeser
Replies
4
Views
484
[email protected]
J
T
concatenating
  • TED
Replies
3
Views
305
Rick Rothstein
R
A
multiple selection....
  • AND
Replies
1
Views
249
Max
M
D
Sorting & sub-totaling data on an excel spreadsheet
  • dmills
Replies
3
Views
380
Fred Smith
F
P
Dependent Validation
  • Paul
Replies
1
Views
364
[email protected]
D
W
Multiple Row and Column Criteria
  • wade04
Replies
8
Views
425
Roger Govier
R
H
Transpose columns to rows using first columns repeated.
  • hn7155
Replies
7
Views
1K
Max
M
V
Sum of items in a column if they meet two criteria in another colu
  • vlpckett
Replies
6
Views
522
Ashish Mathur
A
T
Compare two datasets and extract unique records from each
  • toadflax
Replies
3
Views
937
[email protected]
T
L
count a word recurrent in many cells
  • learningaccess
Replies
1
Views
377
Pete_UK
P
L
count how many rows a word appears in
  • learningaccess
Replies
1
Views
484
Pete_UK
P
C
no leading zero for minutes and seconds
  • Christopher Glaeser
Replies
4
Views
449
Pete_UK
P
M
Auto Lettering
  • Mollycat
Replies
4
Views
338
Glenn
G
P
Please help me add something to this macro
  • Paula
Replies
2
Views
285
Paula
P
M
Creating Templates
  • Mary
Replies
1
Views
279
Shane Devenshire
S
D
Need help comparing data in two columns
  • drew
Replies
1
Views
387
Shane Devenshire
S
L
Filter Multiple Columns on Multiple Criteria and count the last co
  • LBitler
Replies
2
Views
606
Shane Devenshire
S
H
Continuous calculation of a formula.
  • Husker87
Replies
1
Views
522
Shane Devenshire
S
K
Ignore Blanks in Countifs statement
  • Kcope8302
Replies
4
Views
901
T. Valko
T
H
Locating duplicates within range of time punch data
  • heyredone
Replies
2
Views
458
Shane Devenshire
S
P
Need help on this macro
  • Paula
Replies
1
Views
230
Shane Devenshire
S
V
Return a given value if the value of a cell is in a given range
  • vlpckett
Replies
2
Views
687
Shane Devenshire
S
L
Based on Mulipple Criteria acrossed Column count last column
  • LBitler
Replies
1
Views
437
Fred Smith
F
K
Copying first three characters of text in a cell
  • Kris
Replies
3
Views
521
David Biddulph
D
M
Calculating payroll cost
  • MRH
Replies
1
Views
673
Chip Pearson
C
C
Formatting cells for text and numbers
  • CMEknit
Replies
2
Views
243
Shane Devenshire
S
R
unique record count with multiple criteria
  • Rick
Replies
1
Views
415
T. Valko
T
M
Getting rid of PivotTable format
  • MichaelRobert
Replies
1
Views
5K
Shane Devenshire
S
S
VLOOKUP Reading Wrong Record
  • Spock of Vulcan
Replies
2
Views
268
Shane Devenshire
S
J
Help
  • Jamesbfagan
Replies
1
Views
193
DILipandey
D
S
Calling the contents of a random cell
  • suitcase
Replies
3
Views
490
Shane Devenshire
S
J
Cell format will not update
  • Joll
Replies
1
Views
306
HARSHAWARDHAN. S .SHASTRI
H
B
hidden rows reappearing when using filter
  • Betty
Replies
2
Views
952
Shane Devenshire
S
M
I need calculated time in a "real number" format
  • MRH
Replies
2
Views
441
Mike H
M
P
Formatting cells for text and numbers
  • Preston
Replies
2
Views
285
MRH
M
T
Auto Lettering Rows
  • Tobycat
Replies
1
Views
423
Pete_UK
P
U
Custom list in a excel 2007 chart
  • Use of a specific custom list in excel
Replies
1
Views
427
Shane Devenshire
S
S
Excel 2007 single cell selecting muliple cell
  • Submit2s
Replies
1
Views
467
Bernard Liengme
B
B
Indirect alternatives
  • Brad
Replies
1
Views
345
Fred Smith
F
C
potential duplicate max values
  • Caren
Replies
2
Views
478
Caren
C
R
Using Small to return 2nd smallest value
  • Rachel7
Replies
2
Views
423
Rachel7
R
L
How do I change the sizes of individual cells not whole sheet?
  • Loadsheet Maker
Replies
2
Views
332
Pete_UK
P
P
To Refer particular Month in large datas
  • PERANISH
Replies
2
Views
432
Shane Devenshire
S
K
How can I use an if formula that works on a cell with column?
  • KarenABS
Replies
4
Views
370
KarenABS
K
M
Why can't I link to a cell that contains a date or a time?
  • Meenie
Replies
7
Views
438
Meenie
M
U
Specific custom list in a excel 2007 chart
  • Use of a specific custom list in excel
Replies
1
Views
415
Shane Devenshire
S
M
Problem with date - can't enter 15th!
  • Meenie
Replies
8
Views
518
Meenie
M
M
Having problem with 'if' in what should be a simple formula
  • Meenie
Replies
5
Views
396
John
J
Back
Top