Microsoft Excel Worksheet Functions

I
Arrays/vlookup???
  • Ian
Replies
6
Views
474K
Ian
I
C
interpolation within subranges
  • Christopher Glaeser
Replies
4
Views
288K
[email protected]
J
T
concatenating
  • TED
Replies
3
Views
133K
Rick Rothstein
R
A
multiple selection....
  • AND
Replies
1
Views
77K
Max
M
D
Sorting & sub-totaling data on an excel spreadsheet
  • dmills
Replies
3
Views
269K
Fred Smith
F
P
Dependent Validation
  • Paul
Replies
1
Views
70K
[email protected]
D
W
Multiple Row and Column Criteria
  • wade04
Replies
8
Views
607K
Roger Govier
R
H
Transpose columns to rows using first columns repeated.
  • hn7155
Replies
7
Views
945K
Max
M
V
Sum of items in a column if they meet two criteria in another colu
  • vlpckett
Replies
6
Views
432K
Ashish Mathur
A
T
Compare two datasets and extract unique records from each
  • toadflax
Replies
3
Views
507K
[email protected]
T
L
count a word recurrent in many cells
  • learningaccess
Replies
1
Views
209K
Pete_UK
P
L
count how many rows a word appears in
  • learningaccess
Replies
1
Views
256K
Pete_UK
P
C
no leading zero for minutes and seconds
  • Christopher Glaeser
Replies
4
Views
282K
Pete_UK
P
M
Auto Lettering
  • Mollycat
Replies
4
Views
14K
Glenn
G
P
Please help me add something to this macro
  • Paula
Replies
2
Views
141K
Paula
P
M
Creating Templates
  • Mary
Replies
1
Views
88K
Shane Devenshire
S
D
Need help comparing data in two columns
  • drew
Replies
1
Views
147K
Shane Devenshire
S
L
Filter Multiple Columns on Multiple Criteria and count the last co
  • LBitler
Replies
2
Views
129K
Shane Devenshire
S
H
Continuous calculation of a formula.
  • Husker87
Replies
1
Views
233K
Shane Devenshire
S
K
Ignore Blanks in Countifs statement
  • Kcope8302
Replies
4
Views
433K
T. Valko
T
H
Locating duplicates within range of time punch data
  • heyredone
Replies
2
Views
358K
Shane Devenshire
S
P
Need help on this macro
  • Paula
Replies
1
Views
66K
Shane Devenshire
S
V
Return a given value if the value of a cell is in a given range
  • vlpckett
Replies
2
Views
434K
Shane Devenshire
S
L
Based on Mulipple Criteria acrossed Column count last column
  • LBitler
Replies
1
Views
108K
Fred Smith
F
K
Copying first three characters of text in a cell
  • Kris
Replies
3
Views
288K
David Biddulph
D
M
Calculating payroll cost
  • MRH
Replies
1
Views
228K
Chip Pearson
C
C
Formatting cells for text and numbers
  • CMEknit
Replies
2
Views
190K
Shane Devenshire
S
R
unique record count with multiple criteria
  • Rick
Replies
1
Views
341K
T. Valko
T
M
Getting rid of PivotTable format
  • MichaelRobert
Replies
1
Views
208K
Shane Devenshire
S
S
VLOOKUP Reading Wrong Record
  • Spock of Vulcan
Replies
2
Views
81K
Shane Devenshire
S
J
Help
  • Jamesbfagan
Replies
1
Views
68K
DILipandey
D
S
Calling the contents of a random cell
  • suitcase
Replies
3
Views
373K
Shane Devenshire
S
J
Cell format will not update
  • Joll
Replies
1
Views
338K
HARSHAWARDHAN. S .SHASTRI
H
B
hidden rows reappearing when using filter
  • Betty
Replies
2
Views
455K
Shane Devenshire
S
M
I need calculated time in a "real number" format
  • MRH
Replies
2
Views
150K
Mike H
M
P
Formatting cells for text and numbers
  • Preston
Replies
2
Views
290K
MRH
M
T
Auto Lettering Rows
  • Tobycat
Replies
1
Views
13K
Pete_UK
P
U
Custom list in a excel 2007 chart
  • Use of a specific custom list in excel
Replies
1
Views
98K
Shane Devenshire
S
S
Excel 2007 single cell selecting muliple cell
  • Submit2s
Replies
1
Views
187K
Bernard Liengme
B
B
Indirect alternatives
  • Brad
Replies
1
Views
167K
Fred Smith
F
C
potential duplicate max values
  • Caren
Replies
2
Views
352K
Caren
C
R
Using Small to return 2nd smallest value
  • Rachel7
Replies
2
Views
192K
Rachel7
R
L
How do I change the sizes of individual cells not whole sheet?
  • Loadsheet Maker
Replies
2
Views
329K
Pete_UK
P
P
To Refer particular Month in large datas
  • PERANISH
Replies
2
Views
206K
Shane Devenshire
S
K
How can I use an if formula that works on a cell with column?
  • KarenABS
Replies
4
Views
310K
KarenABS
K
M
Why can't I link to a cell that contains a date or a time?
  • Meenie
Replies
7
Views
695K
Meenie
M
U
Specific custom list in a excel 2007 chart
  • Use of a specific custom list in excel
Replies
1
Views
163K
Shane Devenshire
S
M
Problem with date - can't enter 15th!
  • Meenie
Replies
8
Views
309K
Meenie
M
M
Having problem with 'if' in what should be a simple formula
  • Meenie
Replies
5
Views
17K
John
J
K
Using function on column?
  • KarenABS
Replies
2
Views
238K
KarenABS
K
You must log in or register to post here.
Back
Top