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 Reverse Sort Order Last Post Replies Views
Sorting by Group of Cells by -random-
I doubt this can be done, but it sure would be handy. Column is grouped by conceptual blocks, (note, there is not second column of unique data)...
November 20th, 2005 05:14 AM
by David McRitchie Go to last post
4 144
MAX & MAXA returning 0 value by -Rocket
I am trying to simply get the highest value in a column. I have tried both MAX & MAXA functions, as well as ensured the values are formatted as a number...
March 19th, 2007 06:31 PM
by -Rocket Go to last post
6 107
using worksheet references in formulas by -sb
I'm referencing data from one worksheet in a formula: =SUM(IF('1'!F5:'1'!F16 = 6,IF('1'!G5:'1'!G16 ="YES", 1,0),0)) I'd like to reuse this formula for...
July 27th, 2006 09:26 PM
by -sb Go to last post
2 160
File name equal cell contents by -tinka
Is it possible to make an Excel (2003) template (or a macro in the template) to save a file with a specific cell-contents as file name? For example...
(Multi-page thread 1 2)
June 17th, 2008 06:46 PM
by NeedToKnow Go to last post
14 417
Pasting to Protected Cells in Xl2000 by -VMill
I am trying to prevent users from making changes to certain cells in XL2000. I have the cells 'Locked' and both the Sheet and the Workbook are Protected...
August 17th, 2006 03:30 PM
by Ken Johnson Go to last post
3 94
number of rows with cells by ..::CyrusD::..
I want to know if it is possible to put in one formulates I number of the tie row to the value of a cell thank
November 24th, 2006 06:14 PM
by tim m Go to last post
1 119
Solar cells for less than 1 USD per Watt by ..[_2_]
Do you know that you can find solar cells for less than 1 USD per Watt on www.ebay.com ? Regards.
February 7th, 2010 10:31 PM
by ..[_2_] Go to last post
0 148
how can you link images to cells? by .: usman :.
hi there, im using excel as part of coursework for my A-Level ICT, and i need to somehow link images into the program. I have a list of names which i...
December 12th, 2005 08:46 PM
by Ron Coderre Go to last post
2 231
Setting up Invoices by .:RoKsTaR:.[_2_]
Here's what I need to do: Invoice and average of 50 different customers each month for one or more of the dozen services I offer. I figure I need a database...
April 17th, 2010 05:46 AM
by RobN[_2_] Go to last post
4 253
Trying to copy and paste line of text into multiple cells by .Net Sports
I have a text file that has sports pointspread data, and i need to just simply copy a line of characters such as: L -15' 17-14 u44 ...and then make sure...
October 21st, 2008 02:10 AM
by Bernard Liengme Go to last post
1 111
Newbie problem: numbers with +positive and -negative indicators by .Net Sports
I have a column of numbers that i need to have a positive or negative indicator to add up with the AutoSum function, +3 -3.5 +10 ....but can't get the...
October 2nd, 2008 06:08 PM
by Gord Dibben Go to last post
9 148
unable to open .xlsx file in 2003 version by .xlsx file
unable to open .xlsx file in 2003 version
May 11th, 2010 12:13 PM
by Mike H Go to last post
1 296
"Excel cannot complete this task with available resources" by /Torben, Denmark
Every time I try to conduct a copy/cut/paste operation I get the error message: "Excel cannot complete this task with available resources". It started a few...
May 6th, 2007 04:19 PM
by /Torben, Denmark[_2_] Go to last post
2 121
How to lock a file (wholly or partly) by 0-0 Wai Wai ^-^
How to lock a file (wholly or partly) Hi. 1) I would like to lock my file. Thus if someone opens my file, it needs password to access it. Do you know how I...
November 27th, 2005 10:17 PM
by Tonto Go to last post
1 136
Cell to follow content AND/OR formating of another cell by 0-0 Wai Wai ^-^
Hi. How can I tell one cell to follow content AND/OR formating of another cell? Here's an example: A1: =I am the bbest!/b (b.../b means bold...
September 8th, 2005 02:00 PM
by Mike Go to last post
1 302
Transfer/Copy Sheet, Dynamically linked Sheet by 0-0 Wai Wai ^-^
Hi. When you open an Excel file, you will see some tabs at the bottom. They are called "sheets". 1) How can I transfer selected "sheets" to another Excel...
December 23rd, 2005 11:04 PM
by paul Go to last post
2 107
Reference cell formats + content by 0-0 Wai Wai ^-^
Hi. How can I tell one cell to follow content AND/OR formating of another cell? Here's an example: A1: =I am the bbest!/b (b.../b means bold...
December 24th, 2005 03:46 AM
by 0-0 Wai Wai ^-^ Go to last post
4 109
Change/Reverse the table by 0-0 Wai Wai ^-^
Hi. There's the table: A1 A2 B1 B2 C1 C2 1) I would like to make the table upside-down, ie: C1 C2 B1 B2
December 7th, 2005 04:30 PM
by Ian Go to last post
5 106
Strange Calculation Error in Excel by 0-0 Wai Wai ^-^
Hi. I have a table of numbers, and I do some simple Math based on this data. Eg: 4.1 4.1 3.97 4.03 4.15 4.15 4.1 4.1 For the formula "=A4-B4", the answer...
(Multi-page thread 1 2)
December 12th, 2005 12:30 PM
by [email protected] Go to last post
15 245
Use different formula to calculation based on conditions by 0-0 Wai Wai ^-^
Hi. It's the look of my Excel file: Item 1----Amount Category---Details: ... Item 2----Amount Category---Details: ... Item 3----Amount Category---Details:...
December 3rd, 2005 09:28 AM
by [email protected] Go to last post
2 127
Post New Thread


Display Options
Showing threads 201 to 220 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 03:33 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.