|
|
|
|
9 |
160 |
|
|
Reference List by
Gene L.
I am currently using Excel from Microsoft Office 2007 and could use some
help.
I have a list of about 50 suppliers to which I have assigned individual
vendor...
|
|
1 |
144 |
|
|
Cell References: R[-2]C[0] vs A10 by
Arthur[_4_]
One of my excel spreadsheet suddenly replaced all of the "normal" Ax
references to RC references.
How to I restore the default reference system???
Thanks
|
|
4 |
152 |
|
|
|
|
2 |
131 |
|
|
|
|
1 |
143 |
|
|
|
|
1 |
140 |
|
|
Rounding in Excel by
egg_grader
When I enter a number into a cell that has a formula I am using the results
are not accurate. For example when I enter a number 946399, I get a result
of...
|
|
2 |
148 |
|
|
vlookup by
Rohit
how can i use vlookup to return value using the col_index_num to be a cell
refence instead of column number.
=vlookup(...............,2,false) to...
|
|
6 |
191 |
|
|
|
|
2 |
129 |
|
|
Add 1 hour to data by
israel
I have data 1 tru 200 with time "12:01:04". How can I add a hour to read
"1:01:04"
so when they move the clock in March '10 I will have the correct...
|
August 26th, 2009 08:56 PM
by Max
|
1 |
245 |
|
|
|
August 26th, 2009 05:44 PM
by mike
|
2 |
130 |
|
|
Save as comma csv problems by
rock
Hello,
I hace Excel 2002.
I have near 6000 addresses and contacts and wish to save the xls to a
comma csv.
I have done that before and then imported the...
|
|
1 |
138 |
|
|
|
|
2 |
168 |
|
|
IF and Vlookup? by
Heather
Hi - is there a way to incorporate 1 more IF to this formula? I need to use
this formula but add which kind of currency to it so in cell B4 they choose...
|
August 26th, 2009 12:49 AM
by Heather
|
3 |
129 |
|
|
Linking sheets to summarize data by
Robertya
I have a spreadsheet which has employee details on. One sheet has main
details Employee no., salary, pension %, job grade, job title etc. Then I
have...
|
|
1 |
127 |
|
|
Autofilter includes extra row by
George Gee
Just recently Autofilter has started including the last row of data in the
sheet, even though this row does NOT contain the filter criteria.
Anything I can...
|
|
4 |
183 |
|
|
|
|
5 |
138 |
|
|
SUMIF Problem by
tuafc
I am on Excel 2003 and having difficulty with a seemingly simple function.
Month 1 Month 2 Month 3
a 10 100 1000
b 20 200 2000
c 30 300 3000
I want to sum...
|
|
2 |
123 |
|
|
SUMIF Formula (I think...) by
JS
Hi,
I have a workbook (well obviously or I wouldn't be here...), Excel 2003.
One sheet is a running sheet containing a summary of invoices for the month -...
|
August 25th, 2009 02:41 PM
by Max
|
9 |
225 |
|
|
|
|
1 |
126 |