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 : New Users Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Excedl 2003 / How to automize file opening by Ced
Hello Everyone below, my issue with excel 2003: When opening my "mainfile.xls", I wish it could open others "datafileS.xls", needed for my calculation within...
December 9th, 2005 06:21 PM
by Jan Karel Pieterse Go to last post
3 255
calculating commission on sliding scale by corrado444
Hi, I am a fairly new Excell user and I hope someone here can help me or point me in the right direction. I am trying to figure out a fair way to charge...
December 9th, 2005 06:08 PM
by JR Go to last post
4 244
Office XP Photo editor by JethroUK
Is there a std Office XP (2002) app that can change picture resolution? M/S Photo Editor used to do this
December 9th, 2005 05:18 PM
by RagDyeR Go to last post
2 159
How do I set a formula if A1 is "a" then C1 is 3? by Karen
I'm wanting to set a formula so that if cell A1 is "a" then C1 would be 3 and if A1 is "b" then C1 would be 5.
December 9th, 2005 05:15 PM
by RagDyeR Go to last post
5 222
how do i compare two columns and remove duplicates? by aljernon805
i need to repeat a specific function almost daily. i have two coulums of 10 digit numbers. a is about 10 k to 60 k. b is usually less than 10 k. i want...
December 9th, 2005 05:04 PM
by gls858 Go to last post
1 337
Formating Font in a Formuls by Silvanus
Greetings all hopefully this is a simple question. In an IF function I would like to have the value that is returned when True to be one color (green) and the...
December 9th, 2005 04:22 PM
by Silvanus Go to last post
5 199
How to calculate quarterly by Rao Ratan Singh
I have a worksheet which has a date between Januarys to December. This worksheet I m using for record sales and Concession form. According to new rule sale...
December 9th, 2005 02:11 PM
by Rao Ratan Singh Go to last post
2 178
replicating a folder hiearchy. by Rodney
Mornin' all. (I have posted this perhaps in error to Win98se NG) Under a Folder say "001 December 2005" I need to open subfolders each day eg: 20051201...
December 9th, 2005 04:05 AM
by Rodney Go to last post
2 164
Can numbers be typed to automatically be negative in cells? by finnplan
I am a new excel user. I am doing a basic spread sheet. I would like to have cells formated so that when I type in a number it automatically is negative and...
December 8th, 2005 11:25 PM
by Gord Dibben Go to last post
1 188
duplicate the each row twice in one worksheet by L.J.
I have 89 rows data (first name, last name) in one worksheet, for some reason I need to repeat their name 3 times for some reasons. Is there any easy way to do...
December 8th, 2005 08:17 PM
by Ken Wright Go to last post
4 193
Provide a phone # to help the dummies. by sibby sisti
4-5 simple ?'s re EXCEL ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for...
December 8th, 2005 07:16 PM
by Barb Reinhardt Go to last post
1 172
assign a number value to a text. ie, PL equals .5 by JWDesigns
I'm using different material "plate, angle, tube steel" I would like to assign a number value to that text. ie. plate would equal .5 Is there a way I can do...
December 8th, 2005 06:03 PM
by JWDesigns Go to last post
3 162
How do I Default a modify password for each workbook by Sammy work
I'm sending excel docs to people via email - about 20-30 a day. Everytime I send one I have to individually set a password for each workbook to protect it from...
December 8th, 2005 05:11 PM
by Bernie Deitrick Go to last post
1 183
How do I delete duplicate entries in excel? by antieal
I have been given a large database in excel and need to distill it by removing duplicate entries. I would like the results to be displayed in a new worksheet...
December 8th, 2005 03:39 PM
by Ron Coderre Go to last post
1 159
How do I perform linear regression? by kunlez
How or where do I perform linear regression - in the chart or worksheet?
December 8th, 2005 01:37 PM
by Tushar Mehta Go to last post
1 202
How do I get macro to unmerge cells that have been previously merg by HankY
When I try to record the steps to unmerge 2 previously merged colums into 2 separate colums into a macro, when the macro is executed it tries to merge the...
December 8th, 2005 06:52 AM
by HankY Go to last post
2 197
Adavanced filter? by karyoker
I have a spreadsheet with about 13,000 song entries... Col a artist col b song title.. Iv'e read advanced filter tutorials till I'm blue in the face.. All I...
December 8th, 2005 02:50 AM
by Max Go to last post
5 217
how do I freeze top two rows -XL by mrwitt
need to freeze top two rows (headings) while move down in the work sheet
December 8th, 2005 01:06 AM
by Ron Coderre Go to last post
1 153
Countif if the value falls between 2 other values by les8
Need to count values that fall between two limits: for example 462 997 569 122 Need to count values between 300 and 600. I can do if my desired value is over...
December 7th, 2005 10:58 PM
by les8 Go to last post
3 140
why does excel change last digit of credit card numbers to zero? by dacton
Using Excel 2002, cutting and pasting credit card numbers, but excel changes the last number on many of them to zero. If I hold the mouse over the cell, it...
December 7th, 2005 10:05 PM
by Peo Sjoblom Go to last post
1 175
Post New Thread


Display Options
Showing threads 10141 to 10160 of 13737
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:09 AM.


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