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
Shared Workbook opens as read-only by Miranda
I have a shared workbook which seems to work fine sometimes (multiple users can edit at the same time) but other times when I try to open it I get a message...
March 30th, 2010 08:12 PM
by Miranda Go to last post
0 420
Tracking RANK by Bob
Every month I create a spreadsheet that ranks customers by past due amounts owed that I share with our sales team. What's important is the relational change...
March 30th, 2010 08:08 PM
by JLatham Go to last post
2 247
Brugervenlig udfyldning by flemmingdane
I en faktura ønsker jeg at man ved at taste ENTER automatisk kan gå til forudbestemte celler der skal indtastes. Eksempel hvis adresssefeltet starter i...
March 30th, 2010 07:50 PM
by flemmingdane Go to last post
0 118
Is Error Help on a formula by Jim
Hello, I need a little help changing this formula: =IF(ISNUMBER(A2),A2,DATEVALUE(LEFT(A2,10))) to return a blank if the referencing cell is blank. I...
March 30th, 2010 07:47 PM
by JLatham Go to last post
5 123
AutoFill Option Button by Loris
I appreciate your response, but I guess I didn't make myself clear. It is not Auto Complete that is at issue. It is Auto Fill. When dragging the Auto fill...
March 30th, 2010 07:44 PM
by Gord Dibben Go to last post
1 143
Count the number of columns on row that are not empty within a ran by Mathew
I have a very large range, say A3 to AD97. Within this data, there needs to be additional data added weekly. What I want to do is add the data, via a...
March 30th, 2010 07:34 PM
by Mike H Go to last post
3 153
Convert vertical data to horizontal data by Kiley
I have a listing of 6 performance ratings for each employee. The ratings appear vertically. How do I convert the ratings data to a single row for each...
March 30th, 2010 07:33 PM
by Kiley Go to last post
8 205
Location of Grand Total in Pivot table by Rosemary
Is the a way to show the Grand total next to the selected Field as opposed to the right now column ( I am using a file that had data results by Date)?
March 30th, 2010 07:16 PM
by Jim Thomlinson Go to last post
1 200
Simple IF statement by Bob[_53_]
In simple terms i am trying to say if the value in box E2 is "CASH02" or the cell is empty then put "ACTIVE" otherwise put "CLOSED" I have tried many...
March 30th, 2010 07:12 PM
by T. Valko Go to last post
4 94
Excel 2010 Beta Professional by Leonard Cravath
Will not "save" or "Save As". Response is that "Excel has encountered a problem and must close". Returns to working spread sheet . Further efforts to save...
March 30th, 2010 07:11 PM
by Leonard Cravath Go to last post
0 175
AutoComplete feature - Turn off by JMay
In certain files I work with the annoying feature above reacts and enters a string of text as soon as I enter the first letter. I notice the ON/OFF button...
March 30th, 2010 07:06 PM
by JMay Go to last post
0 119
How do I multiply the content of a cell by a number by KTK
I need to multiply the content of a cell by a number (e.g. 2) but have been receiving the error message saying that there is a circular reference. Is there a...
March 30th, 2010 06:10 PM
by Eduardo Go to last post
2 123
Averaging all values for each hour??? by Jennifer
I have been trying for hours to try to figure this out. I have data that has been recorded every few minutes over a two week period for temperature, say...
(Multi-page thread 1 2)
March 30th, 2010 06:05 PM
by Bob I Go to last post
12 279
can't open Excel file by shari
After a worksheet disappeared, I tried to re-open. Explorer lists the file, but when I open it, the command section at the top is inaccessible and the...
March 30th, 2010 05:51 PM
by shari Go to last post
0 113
function Making one row out of many by dersonnenach
I have 72 rows, each one is about 10 cells long. Does someone know a function to make one row out of this? Thanks a lot! Melanie
March 30th, 2010 05:40 PM
by Jim Cone[_2_] Go to last post
2 142
Highlight Five Values With Conditional Formula by Herbert Seidenberg
Excel 2007 Table, PivotTable, CF http://c0718892.cdn.cloudfiles.rackspacecloud.com/03_30_10.xlsx Pdf...
March 30th, 2010 05:32 PM
by Herbert Seidenberg Go to last post
0 109
excel macro/funcion insert row if by dersonnenach
I need to insert rows in my excel spreadsheet under certain conditions. Specifically, I should always have six lines with certain data in it. But sometimes I...
March 30th, 2010 05:31 PM
by Reg Go to last post
1 139
Index/Match ... Excel has encountered an Error by Ken
Excel2003 WorkBook with many INDEX/MATCH Formulas ... Issue ... When I attempt to write a new INDEX/MATCH Formula I am having a problem with Excel each time...
March 30th, 2010 05:24 PM
by Dave Peterson Go to last post
2 105
Multiple Languages by Infexus Bytez
I'm working on a community template, and was going to save the document in multiple languages. Is there an easy way to convert the text, without having to...
March 30th, 2010 05:18 PM
by Jim Thomlinson Go to last post
1 127
DropDown aand Auto Fill by Maanu
Hi, I have column with DropDown List.. The items are a. Documentation b. Logic c. Optimization Is there a option to automatically fill a cell, if I type...
March 30th, 2010 05:14 PM
by Gord Dibben Go to last post
5 143
Post New Thread


Display Options
Showing threads 3021 to 3040 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 07:58 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.