Microsoft Excel Worksheet Functions

I
Using search when it returns #VALUE!
  • IanMcGreene
Replies
1
Views
99K
Niek Otten
N
G
How do I set a cell to auto expand when it has a formula?
  • Guest
Replies
5
Views
289K
Guest
G
C
Concatenating entire columns
  • c_sicker
Replies
2
Views
224K
Guest
G
G
repeat macro until empty space in next column
  • Guest
Replies
1
Views
225K
Guest
G
G
how to convert a column of numbers (monthdayyear) into dates?
  • Guest
Replies
5
Views
272K
Guest
G
G
vlookup and hlookup
  • Guest
Replies
4
Views
438K
Guest
G
G
Consolidation of dulpicate rows of data.
  • Guest
Replies
2
Views
309K
Guest
G
G
alphanumeric sorting
  • Guest
Replies
1
Views
277K
Guest
G
G
Sum largest numbers based on condition
  • Guest
Replies
6
Views
254K
Biff
B
G
alternative to if statement
  • Guest
Replies
4
Views
218K
Niek Otten
N
G
Mathematic problem solving using Excel
  • Guest
Replies
2
Views
300K
Guest
G
G
negative numbers
  • Guest
Replies
3
Views
187K
Dave
D
G
Text Color Change prompted by different columns
  • Guest
Replies
1
Views
156K
Bob Phillips
B
G
Excel 2003 is missing toolbar button select visible cells
  • Guest
Replies
1
Views
75K
Guest
G
G
Vlookup not Resolving
  • Guest
Replies
4
Views
309K
Guest
G
G
Excel should let you select 2 rows, right click, and SWAP them
  • Guest
Replies
3
Views
299K
Jim Cone
J
G
Sumproduct Not Working
  • Guest
Replies
5
Views
338K
Guest
G
W
% query
  • wally
Replies
11
Views
2M
Biff
B
X
Compare Two Columns (Exact and Wildcard)
  • Xavier
Replies
4
Views
537K
Xavier
X
G
Sumproduct using dates
  • Guest
Replies
8
Views
194K
Guest
G
G
Searching a text string in a range of cells.
  • Guest
Replies
2
Views
77K
Guest
G
G
I need to understand how the IRR, NPV and FPV formulas work? Thks
  • Guest
Replies
1
Views
39K
Niek Otten
N
G
use concatenate function to put carrage returns in a text string
  • Guest
Replies
4
Views
525K
Guest
G
G
Calculate number of months between dates
  • Guest
Replies
1
Views
92K
Bob Phillips
B
D
Using seperate sets of radio buttons in one sheet
  • Duster
Replies
1
Views
201K
Duster
D
G
How do I match values in one spreadsheet to values in another?
  • Guest
Replies
2
Views
126K
Guest
G
G
Where in Office 2007 can I record a macro?
  • Guest
Replies
1
Views
130K
Guest
G
G
How to convert Kgs to Stns, Pds & Ozs
  • Guest
Replies
2
Views
373K
Guest
G
D
Convert from Excel to Software ?
  • David
Replies
1
Views
123K
Guest
G
M
Overwriting prior formula
  • Mark
Replies
3
Views
247K
Guest
G
S
How do I select the first cell of a filtered list?
  • Shane Moore
Replies
2
Views
224K
Bernie Deitrick
B
G
no #VALUE! to printout
  • garyww
Replies
1
Views
83K
Bondi
B
G
COUNTIF
  • Guest
Replies
8
Views
211K
Guest
G
W
MOre than 8 argurement
  • wan
Replies
5
Views
358K
wan
W
G
Rate function
  • Guest
Replies
1
Views
253K
[email protected]
J
G
Filename from a Cell
  • Guest
Replies
7
Views
612K
Hurtige
H
G
color code a row by expiration date?
  • Guest
Replies
6
Views
179K
Guest
G
G
analysing sales vs price
  • Guest
Replies
1
Views
420K
Dav
D
G
Use filename in cell to link data
  • Guest
Replies
2
Views
53K
Guest
G
G
Rank Function
  • Guest
Replies
1
Views
232K
Biff
B
C
validation list. Scroll to top when using, how?
  • Corey
Replies
4
Views
229K
Arvi Laanemets
A
G
Moving Related Fields
  • Guest
Replies
2
Views
24K
Guest
G
G
find two (2) lowest values in a range (Excel)
  • Guest
Replies
3
Views
514K
Biff
B
G
net present value
  • Guest
Replies
1
Views
135K
Fred Smith
F
C
Help with Random Functions
  • CIL
Replies
6
Views
302K
RagDyer
R
N
eliminate repeat values from a list of ascending order
  • norumbegan
Replies
5
Views
499K
Guest
G
O
if cell = no how to copy to another sheet
  • oasisoflife
Replies
6
Views
326K
Guest
G
G
automatic table to table copy
  • Guest
Replies
3
Views
200K
Guest
G
G
Excel 2002 dropdown lists
  • Guest
Replies
2
Views
253K
Debra Dalgleish
D
Q
Finding the average across multiple sheets
  • quailhunter
Replies
16
Views
692K
Fin Fang Foom
F
You must log in or register to post here.
Back
Top