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
Replace #N/A with 0 by Emece
When I use the vLookup formula and the result is #N/A, I need to replace this with a 0, is this possible in only one formula? Thanks in...
March 30th, 2010 05:13 PM
by Gary''s Student Go to last post
1 186
Scroll bar disappears when panes frozen by AIS Jay
Hi When I freeze the panes on a spreadsheet the right scroll button on the bottom scroll bar disappears. Also a bunch of vertical lines appear within the...
March 30th, 2010 04:55 PM
by AIS Jay Go to last post
0 128
Dragging a formula across the row in 2007 by Carolyn
When I drag from one cell to the next it puts in the correct forumla (i.e., O16+O31 is P16+P31 in the next cell); however, it puts the value from the O...
March 30th, 2010 04:53 PM
by Carolyn Go to last post
2 167
Need a quanity of items printed by DevilDog1978
I am working with Excel 2003. I am new to excel and having some difficulties. I Have a form that requires 5 pages be printed out. WhAT I am trying to do is...
March 30th, 2010 04:43 PM
by DevilDog1978 Go to last post
4 244
Excel 2007 - Rows - Height - AutoSize question by John
I am having difficulties using the Rows/Height/Autofit Row Height setting. When I autofit row height for cells that have greater than ~1250 -1300 characters,...
March 30th, 2010 04:35 PM
by John Go to last post
0 154
Conditional format Formula -Duplicate & n/a by BeckyB
I am trying to do a conditional format formula to highlight duplicate results, but I have #n/a on some. Is there a way to write the formula to find all...
March 30th, 2010 04:30 PM
by Chip Pearson Go to last post
1 156
VBA code and protected cells by manni
Hello - I created a form template in excel and I unlocked various cells and then protected the sheet so that users who completed the form would only be able...
March 30th, 2010 04:30 PM
by Gord Dibben Go to last post
9 285
UNREADABLE CONTENT by Tree
We receive an unreadable content error in our Excel (happens on both computers) spreadsheet. This was a 2003 file that we have converted to 2007 and has an...
March 30th, 2010 04:16 PM
by Tree Go to last post
0 135
Measure on the date different by Sky[_3_]
Hi, I had a huge file of aroiund 10 000 line. This 10 000 line only consist of 500 items. I wish to have an analyise a information. Example in the file it...
March 30th, 2010 03:58 PM
by Sky[_3_] Go to last post
0 111
Date Difference by Maanu
Hi, My DOB is 2-Feb-1970.. I want to know my age on 1-Jan-2010 in Years,Months and days for Eg: 10 Years,9 months and 10 days. How can I do this in...
March 30th, 2010 03:52 PM
by FSt1 Go to last post
4 140
=TODAY() and HLOOKUP - help needed by GD
Hi, I am building a model that I am trying to 'automate' as well as possible to reduce running time of scenario work. The data I utilise is in monthly...
March 30th, 2010 03:48 PM
by Roger Govier[_8_] Go to last post
2 129
Excel 2007 convert into tab delimeter text file with extra tab spa by Naresh kumar[_2_]
Hi , Sub: I have excel 2007 trying to save as tab delimeted text file having an issue. I have saved my excel 2007 as separate Tab delimited Text files. I...
March 30th, 2010 03:48 PM
by Naresh kumar[_2_] Go to last post
0 157
Data collection Sum/Total by Michael_R
Here's how I understand your setup: Column A has 365 dates (01.Jan - 31.Dec) (starting in A2) Column B has the weekday of the date in col.A. (starting in B2....
March 30th, 2010 03:38 PM
by Michael_R Go to last post
1 107
Excel 2007 - A Conditional Formatting ?'s by roadkill
Frankly I'm very annoyed with conditional formatting in Excel 2007 but am hoping that there are settings or something that will at least take care of the...
March 30th, 2010 03:37 PM
by Michael_R Go to last post
1 106
Drop down list by Asoka Walpitagama - Brandix College IT
When right clicked on a cell there appears an option called 'pick from drop down list',. How to use this feature & does it have any relationship to Data...
March 30th, 2010 03:34 PM
by מיכאל (מיקי) אבידן Go to last post
2 168
Ho do i create drop down list? by Peter
I need choices to be saved within drop-down list! "Eduardo" wrote: Hi, look into Debra web she has excellent explanation and examples ...
March 30th, 2010 03:34 PM
by Eduardo Go to last post
1 154
cumulative counting by Roy Gudgeon[_2_]
I have a sales database with 300 records (sales orders) allocated to 6 salespersons. The database is added to constantly. I want to be able to run a report...
March 30th, 2010 03:34 PM
by Roy Gudgeon[_2_] Go to last post
0 128
DropDown aand Auto Fill by מיכאל (מיקי) אבידן
'Tools' 'Options...' 'Edit' tab check 'Allow Auto-fill of cell values' 'OK' Micky "Maanu" wrote: Hi, I have column with DropDown List.. The...
March 30th, 2010 03:34 PM
by מיכאל (מיקי) אבידן Go to last post
0 175
DropDown aand Auto Fill by Pritesh[_2_]
If you have your three (or any other) values, above or below, in same column "continued without line-gap", then this works the way you are asking. If its...
March 30th, 2010 03:28 PM
by Pritesh[_2_] Go to last post
0 127
=TODAY() and HLOOKUP - help needed by GD
Formatting got messed up... The example should read: "March" | January February March 3 ...
March 30th, 2010 03:26 PM
by Michael_R Go to last post
3 165
Post New Thread


Display Options
Showing threads 3041 to 3060 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:14 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.