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
How to hide a vaue by Bill B
I am trying to hide a value of 351 in a cell until the 351 is used in a calculation. How do I do this. Example: b3 is 351 I would like to subtract b2 which...
February 20th, 2010 04:56 PM
by Gord Dibben Go to last post
1 157
just need to display formulas nothing appears by Sissy81
I am a student and it says to display the cell formulas in the worksheet. I have tried EVERYTHING and can't figure it out??? Please help
February 20th, 2010 04:51 PM
by Gord Dibben Go to last post
3 170
Where is Excel 2007 on my computer? by Kickin' Ass and Takin' Names
I use Excel and Word 2003. My new computer -- new about six months ago -- came with MS Office 2007 pre-installed and I activated it. However, I never use the...
February 20th, 2010 12:44 AM
by Kickin' Ass and Takin' Names Go to last post
3 151
Percent column in Pivot report by NetNewbie
Hi, I have a pivot report based on a query against a database. The query has 3 columns Gender, CntMale, CntFemale In the pivot report, I need to show the...
February 19th, 2010 08:14 PM
by Daryl S[_2_] Go to last post
1 212
Excel 2003 Drop Down Box by Brooklyn
I am attempting to create a drop down box in Excel, I have created a list in a separate range but when I copy that range, it isn't the same in the Drop Down...
February 19th, 2010 06:55 PM
by Gord Dibben Go to last post
2 182
Display ranges in a Pivot by NetNewbie
Hi all, I have a column called IncomeRange. I need to display the value in ranges like 0 - 100, 101-200 etc., How can I convert a column in a pivot report to...
February 19th, 2010 05:01 PM
by NetNewbie Go to last post
3 144
formula help by Rohit
Hi i got this formula =INDEX($A$13:$BD$1000,MATCH($C$13,$A$13:$A$1000,0),MATCH(D2,$A$11:$BZ$11,0)) i want to use the same formual but this time to match...
February 18th, 2010 11:54 PM
by Max Go to last post
5 156
find&press button by Gord Dibben
What do you mean by "disabled"? You're saying that Find does not find the data you are looking for but you can see the data in a cell? Perhaps that exact...
February 18th, 2010 04:39 PM
by Gord Dibben Go to last post
0 135
Excel 2003, Auto Filter Help! by [email protected]
I have a 21,000 row XML file that I pull into Excel every morning: Data / Import Data / Select Data Source / OK ...and all is well ....until I updated to a new...
February 18th, 2010 03:49 PM
by [email protected] Go to last post
0 163
how to insert a collum on a sheet without it changing cell referen by Just Me
Its difficult to explain but I have this formula on a sheet: =COUNTIF(Numbers!$A3:Numbers!AE3,1) I want to be able to insert a collum on the Numbers sheet and...
February 18th, 2010 03:10 PM
by Max Go to last post
8 198
Formula? by omocron
First, let me apologise for my lack of Excel knowlege. I have tried to teach myself to create this formula on my Excel 2002, however....I give. I humbly...
(Multi-page thread 1 2)
February 18th, 2010 04:57 AM
by JLatham Go to last post
16 322
Variable Frame Reference by Branden Durst
I am in the process of creating a very large excel spreadsheet and am hoping to find a workaround. My intermediate excel skills have let me down! Here is...
February 17th, 2010 10:16 PM
by Gord Dibben Go to last post
1 163
How do I convert text to "proper text"? by Sunny
I am trying to convert the text from all caps to Caps and lower case better known as proper text. I used the functions tab and then the formula auditing box...
February 17th, 2010 09:58 PM
by Gord Dibben Go to last post
1 155
New free mail add-in for Excel/Outlook 2007-2010 by Ron de Bruin
Posted to more then one newsgroup FYI Today I upload a new version of my Excel Mail add-in for Outlook. If you want to test it you can find it...
February 17th, 2010 09:29 PM
by Ron de Bruin Go to last post
0 154
Template by vandy
I downloaded a Donation Receipt template and would like to create a spread sheet to connect to it . Beside individual receipts I need to have the total...
February 17th, 2010 06:55 PM
by Gord Dibben Go to last post
1 182
format for weight by exntluser
In Excel 2007 is it possible to format cells for weight, such as stones & lbs? e.g. 14 lbs = 1 stone
February 17th, 2010 06:44 PM
by Gord Dibben Go to last post
4 175
excel formula by Rohit
Hi i have this formula =INDEX(Consol!$A$13:$BD$1000,MATCH($C$13,Consol!$A$13:$A$1000,0),MATCH(D2,Consol!$A$11:$BZ$11,0)) i want to use same formula but this...
February 17th, 2010 03:34 PM
by Max Go to last post
1 197
SumIF by Mufasa[_2_]
I would like to know how to sum the values in a particular column baesd on a portion of text in two other columns. Ideally something like...
February 17th, 2010 07:46 AM
by Mufasa[_2_] Go to last post
2 144
what does a mini toolbar contain by Nelly Zayas
Questions on excel. microsoft office excel 2007.
February 17th, 2010 06:30 AM
by Russell Dawson Go to last post
2 171
Calculating averages and not including blank cells by Mercedes
Hello all, Could someone tell me how to calculate the average of a column in Excel that has blanks? I don't want to include the blanks in the average. I...
February 17th, 2010 03:22 AM
by Bernard Liengme Go to last post
1 186
Post New Thread


Display Options
Showing threads 381 to 400 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:58 PM.


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