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
How to total a column of cells without using Autosum by Goldar
Help me remember please. I used to be able to quickly total a rance of cells by simply highlighting them. The total would then appear in the fx box. I can't...
April 21st, 2010 10:46 PM
by Jim Thomlinson Go to last post
3 346
Count based on cell value between two numbers by joemc911
Perhaps for the more experienced this is easy. I hope so. I want to build a sheet that scores a point value based on data entered in one cell. I would like...
April 21st, 2010 09:57 PM
by Mike H Go to last post
4 220
April 21st, 2010 09:48 PM
by Bernard Liengme Go to last post
3 198
Spreadsheet filename no longer appears in title bar by Jim R[_6_]
Spreadsheet filename no longer appears in the title bar of the spreadsheet window. What do I need to do to get the spreadsheet filename to appear? Thanks --...
April 21st, 2010 09:33 PM
by Jim R[_6_] Go to last post
0 201
Excel 2003 - Skip a cell by Ed
How do I skip a blank cell? I have a column of dates (Col A) and a column of numbers (Col C). Col C has irregular blanks. I want to copy these to another...
April 21st, 2010 09:21 PM
by Ed Go to last post
5 271
counting by pierre
hello i have cells from A1:A3 and A6:A10 which contain text strings. now what should be the formula if i want to count these cells ? (answer should be...
April 21st, 2010 09:20 PM
by Dave Peterson Go to last post
2 171
Removing spaces from middle of cell by TJAC
In my spreadsheet there is a column that contains number, 3 on the left, space, 3 on the right. I want to remove that space. Rather than doing this in...
April 21st, 2010 08:24 PM
by Ron Rosenfeld Go to last post
5 284
Tables and Custom views in Excel 2007 by Mervyn Thomas
I now find that the latest version does not allow tables and custom views to coexist. I have loads of sheets which are driven by ODBC feeds which...
April 21st, 2010 07:59 PM
by Kristi Czajkowski Go to last post
1 438
allow merging cells in protected sheet by Doug
When I protect the sheet, the Merge & Center button is greyed out. I need to allow users to merge and center cells in a protected sheet (these cells are not...
April 21st, 2010 07:57 PM
by Doug Go to last post
0 293
look up formula by Jane Griffel[_2_]
I have two customers with two different list of procedures on one report. cell A1 has a drop down list of the customers when a certain customer is chosen How...
April 21st, 2010 07:55 PM
by Jane Griffel[_2_] Go to last post
3 214
Formula shows as text by EmilyE
I'm trying to write a formula into a cell and it will work in some, but in other cells it makes the formula show in the cell as if I am just typing text. Why...
April 21st, 2010 07:44 PM
by FSt1 Go to last post
1 199
entering current time in shared work book - 2003 by Radhakant Panigrahi
Hi, i am maintaing a excel tracker in shared drive where i am manually entering the time when a person came into the office. Is it possible that when a...
April 21st, 2010 07:32 PM
by Don Go to last post
1 207
Sum of two groups by JHL
I have the following formula attempting to get some totals by aging category. =SUMPRODUCT(--(B2:B1096=T12),--(AA2:AA1096=U11),Q2:Q1096) T12 = a 2 digit code...
April 21st, 2010 07:29 PM
by Luke M[_4_] Go to last post
1 157
Find/Replace Numbers stored as Text drops zeros by mduncan1153
This SEEMS to have changed when Office 2003 SP3 rolled out - as we USED to be able to do this. I'm not ruling out OE (Operator Error) - although we've tried...
April 21st, 2010 07:19 PM
by Don Go to last post
1 177
Recover lost excel tabs/spreadsheets from workbook by J&L
Have an excel workbook with multiple spreadsheets. For reasons unknown all the tabs have disappeared from the workbook except for one. I know they are...
April 21st, 2010 07:11 PM
by Don Go to last post
2 196
Lookup formula by Michael
Hi, I have a lookup that is looking at 2 different worksheet and the formula is =IF(ISERROR(IF($D1="ruth baybutt",HLOOKUP(A$3,ruth...
April 21st, 2010 07:03 PM
by Roger Govier[_8_] Go to last post
2 212
I can't see Grand total rows even though the option's switched on by RachaelE
Can anyone help ? I am creating a Pivot table in Excel 2007 and want to see Totals for columns and rows. I have checked both boxes in Options / Totals &...
April 21st, 2010 07:01 PM
by Don Go to last post
2 238
How do I cancel/delete read only for a worksheet? by Help me!
I don't even know how ready only got put on in the first place.
April 21st, 2010 06:44 PM
by Jim Thomlinson Go to last post
2 224
Lookup Formula by EmilyE
I'm not sure if this would be a look up formula, but is there a formula where I can type in a number in one cell and in the cell next to it, it will pop up a...
April 21st, 2010 06:34 PM
by Roger Govier[_8_] Go to last post
2 176
Pie of Pie by Jeff
Can anyone walk me through how to build a "pie of pie" chart? That is, I need a secondary pie chart to "explode" a slice of the main pie chart. Excel's...
April 21st, 2010 06:29 PM
by Billns Go to last post
5 281
Post New Thread


Display Options
Showing threads 1941 to 1960 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:21 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.