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
#n/a - how can I avoid and format it to number to include in sum by Rechie
I am using vlookup but some results are #n/a. How can i avoid it so that my sum formula will not show #n/a. Thanks Rechie
March 27th, 2010 10:20 PM
by T. Valko Go to last post
6 241
Round up or down by set variable by Supe
Is there a way to have a number round up or down based on a threshhold it hits between the two number? I want a number when it hits .8 to round up,...
March 27th, 2010 09:02 PM
by Joe User[_2_] Go to last post
3 154
Select specific location in spreadsheet by dhstein
I have a menu set up for a user to get information based on a choice from a drop down list. The event macro will go to a specific location based on the...
March 27th, 2010 09:02 PM
by tompl Go to last post
3 156
printer paper will not advance by bob5
When printing the paper will not advance properly and the text prints on top of the previous lines
March 27th, 2010 05:10 PM
by Fred Smith[_4_] Go to last post
2 167
Converting excel 2007 to tab delimeter text file by Naresh kumar
when I convert excel 2007 data into tab delimeter text file, it is adding two extra tab spaces at the end of each row, but it is not happending the same...
March 27th, 2010 04:56 PM
by Sheeloo Go to last post
1 198
Undo autocorrect - one time only (Excel 2007) by Darby
I'd like to stop Excel from Auto correcting HSA to HAS for only one particular entry, so I don't want to delete it from the autocorrect list. I have seen...
March 27th, 2010 04:50 PM
by Sheeloo Go to last post
1 212
numbering items in a cell by Maanu
Hi, Is it possible to number items in a cell? This number should automatically increment when I enter a new item at the end of the cell as in microsoft...
March 27th, 2010 04:01 PM
by Gord Dibben Go to last post
5 174
edited spreadsheet saves as template by marysully
Each time I save my Excel spreadsheet after editing it saves as template. This has created a problem with duplicate copies of the spreadsheet. I'm using...
March 27th, 2010 03:53 PM
by Gord Dibben Go to last post
3 151
Selection copy and insert to other sheet (Macro) by VLOOKUP fORMULA
Any body help with a macro please........ I have selected two cells from a row from sheet1 Is there any way to copy those cells go to Sheet2 and insert a...
March 27th, 2010 03:48 PM
by Gord Dibben Go to last post
8 146
Matrix selection by Marco Rod
Hello, I have a problem and I need a solution that I'm not finding out. I need a formula that give me a specific value in a matrix (under the condition of...
March 27th, 2010 03:23 PM
by Marco Rod[_2_] Go to last post
4 197
tab in a cell by Maanu
Hi, How can I put a tab in a cell?. If I press the tab key, the control goes to the next cell. Thanks!
March 27th, 2010 01:53 PM
by Dave Peterson Go to last post
3 124
How to reduce size of ms excel file-2003 by vijay[_4_]
I am usung excel 2003. A file containing 6000 records and 85 columns and used formula in each cell becomes a larger size and dificult in saivng. It takes more...
March 27th, 2010 01:28 PM
by Don Guillett[_2_] Go to last post
1 157
If Formula , Adding Days to a Date by Khalid A. Al-Otaibi
A B 1 06/06/10 I want to make a formula that calculate as following; in Cell (B1) if the date in future the result will be , if not it will be Cell...
March 27th, 2010 10:29 AM
by Lars-ลke Aspelin[_4_] Go to last post
1 142
counting identical items in a column and returning the occurrences by ExcelWizardImNot
I use excell 2000. I have one column with 700 rows. In each cell is one number, either a 0, 1, 2, 3, 4, or 5. In the second column I have five rows, each...
3 156
Counting Days by DyingIsis
Hello - I'm trying to figure out a formula that tells me the number of days until a date or tells me how many days have passed since the date. Meaning, if...
March 27th, 2010 05:58 AM
by Fred Smith[_4_] Go to last post
6 154
HOW TO MAKE A NUMBER OF CELLS INTO 1 BIG ONE AT THE BOTTEM by barry
I need to put a long sentence at the bottem across a number of cells, how to do it?
March 27th, 2010 03:51 AM
by JLatham Go to last post
2 161
Utilizing a macro for a datasets that don't have a fixed number of by DyingIsis
Hello - I have multiple datasets of varying numbers of rows, and I would like to develop a macro that I can use for all of them. Below is a sample...
March 27th, 2010 03:40 AM
by JLatham Go to last post
1 149
make camera object refer to dynamic range by Mica
I have a camera object that refers to a range on another spreadsheet. When the user makes a selection the range filters to show only matching records. ...
March 27th, 2010 01:14 AM
by Mica Go to last post
0 142
Remove 2003 Password in 2007 by RoadKill
We have a workbook that was originally created and password protected in 2003. It give the option to open as read only or to enter in the password to edit...
March 27th, 2010 12:45 AM
by H้ctor Miguel Go to last post
1 174
R1C1 reference by Rick
Can anyone tell me the proper structure for thid statement? ActiveCell.FormulaR1C1 = "=IF(TagNmeMe.value!RC="""","""",TagNmeMe.value!RC)" TagNmeMe is a...
March 27th, 2010 12:24 AM
by Rick Go to last post
4 148
Post New Thread


Display Options
Showing threads 3141 to 3160 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 08:16 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.