|
|
|
July 6th, 2004 08:26 PM
by jeff
|
1 |
189 |
|
|
Missing toolbar by
Roger Bedford
Am looking for the toolbar in Excel 2002 that shows the cell range and any
text that is currently being typed. Any suggestions would be appreciated.
Roger
|
|
1 |
381 |
|
|
lookup formula by
gregork
I am trying to come up with a formula that looks up an order number (eg
2013864) on a list on another sheet (2)and then returns all the listings
corresponding...
|
|
8 |
169 |
|
|
if, index, match by
rsikin
I am setting up a payroll journal entry in Microsoft Excel 2000 (PC)
(Col A) (Col B) (Col C)
(Col D)
Employee Gross ...
|
July 6th, 2004 07:11 PM
by rsikin
|
3 |
145 |
|
|
"Comments" Default Font by
tim
I'm going to try this again. This is not a huge problem,
just a point of irritation.
I would like to change the default font when
using "Insert Comment". If...
|
|
1 |
229 |
|
|
Dropdowns by
Janice
I am using Office 2000 on a windows 2000 machine.
Can you tell me how to create a dropdown with choices
for a cell.
I want to put choices such as water,...
|
|
4 |
242 |
|
|
|
|
6 |
394 |
|
|
Rank column with changing # of rows by
Amy
Is there a formula that will Rank even when rows are added and deleted? Currently I am using =RANK(C8,C8:C43) but when I add or delete rows it throws...
|
|
1 |
150 |
|
|
OptionButton Help by
BryC
I'm trying to change the OptionButton group names to the name of the 'Current Sheet' name automatically. Is there protocol to assigning a name without having...
|
|
5 |
199 |
|
|
Selecting a Value from a Range of Values by
breenmck
I want to select a value from a range of 20 Values depending upon the relationship between two cells outside that range.
Lets say the Range of Values I want...
|
|
1 |
351 |
|
|
how to use "barcode" in excel 2000?? by
gg
Dear all,
i would like to set up an inventory system for recording
the stuff. previously, i have a long table of data in
excel. i need to do some...
|
|
3 |
382 |
|
|
Pivot Table Summary by
arunsharm82
Hi,
I want to be able to summarise some data that I have in a Pivot Table I
created.
The data from the Pivot Tables is contained in many tabs in my
workbook....
|
|
2 |
248 |
|
|
How can I use minutes and seconds by
guilbj2
I'm trying to create a spreadsheet (Excel97) to calculate average handle
time for a call center. Each entry will be in minutes and seconds. No
matter what...
|
|
3 |
529 |
|
|
Moving data by
gary
Column "A" contains JUNDREDS of unique part-numbers. For
example:
001
002
003
123
234
345
456
|
July 6th, 2004 02:01 PM
by gary
|
6 |
665 |
|
|
print macro to solve limit on page breaks by
Jim Palmer
I have encountered the limit on the number of page breaks that excel
allows, and I'd like to write a macro to work around this.
My data is as follow:
Part...
|
|
8 |
237 |
|
|
Assign Unique Number by
vecia
Does anyone know how to assign a unique number to a record entered into
a spreadsheet?
I have an excel database with a form (made with template wizard...
|
|
4 |
220 |
|
|
How to open Lotus123 files by
RB
I recently installed Office 2003 and cannot open Lotus
123 files (Millenium Edition). I get the error
message "Cannot open Lotus 123 file". Does anyone...
|
|
1 |
380 |
|
|
Spreadsheet query by
Michael Dedman
I have devised a list of items in a Microsoft Excel
spreadsheet. Against each item (in a different cell) is an amount which
represtents the items value.
I...
|
July 6th, 2004 11:53 AM
by papou
|
1 |
194 |
|
|
Struggling with MS Query... by
Alex
I am learning about MS Query from a book. I am falling at
the first hurdle...
I have an Excel file on my desktop that I want to be able
to query. It contains...
|
|
5 |
1,703 |
|
|
hours and minutes calculation by
charlie
does anyone know how to make a spread sheet formulae to
calculate hours and minutes, which reports in jours and
minutes?
|
|
1 |
167 |