A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : General Discussion Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Copying transactions pairs to the next row by TurkisH
Hiya peeps, I need to copy transaction pairs to the next row. A particular row looks like...
July 6th, 2004 08:26 PM
by jeff Go to last post
1 184
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
July 6th, 2004 08:23 PM
by William Go to last post
1 345
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...
July 6th, 2004 07:51 PM
by RagDyer Go to last post
8 164
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 Go to last post
3 140
"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...
July 6th, 2004 07:09 PM
by Debra Dalgleish Go to last post
1 224
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,...
July 6th, 2004 07:03 PM
by Debra Dalgleish Go to last post
4 237
Default Font Setting in Excel Comments by tim
How do I change the default setting for the font in an Excel Comment from Tahoma 8 pt.?
July 6th, 2004 06:59 PM
by Debra Dalgleish Go to last post
6 381
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...
July 6th, 2004 06:44 PM
by Myrna Larson Go to last post
1 145
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...
July 6th, 2004 05:52 PM
by Dave Peterson Go to last post
5 194
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...
July 6th, 2004 05:11 PM
by RagDyeR Go to last post
1 338
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...
July 6th, 2004 05:02 PM
by Thomas Lutz Go to last post
3 370
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....
July 6th, 2004 04:04 PM
by arunsharm82 Go to last post
2 243
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...
July 6th, 2004 02:49 PM
by Norman Harker Go to last post
3 516
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 Go to last post
6 652
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...
July 6th, 2004 01:43 PM
by Dave Peterson Go to last post
8 232
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...
July 6th, 2004 12:50 PM
by Clarkey Go to last post
4 215
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...
July 6th, 2004 11:59 AM
by Jim Rech Go to last post
1 375
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 Go to last post
1 189
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...
July 6th, 2004 11:46 AM
by Jamie Collins Go to last post
5 1,680
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?
July 6th, 2004 11:45 AM
by Norman Harker Go to last post
1 162
Post New Thread


Display Options
Showing threads 138581 to 138600 of 139764
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:41 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.