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 : Worksheet Functions Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
How do I truncate linked text? by Jenni
I am linking text from other worksheets, but I only want a portion of the text to appear in the final document, using a certain number of characters. Any...
April 9th, 2010 07:10 PM
by Dave Peterson Go to last post
1 98
Counting text within an Entire Workbook by Carrie_Loos via OfficeKB.com
Hi - Need help, still stuck. I have a workbook with several worksheets. Each worksheet has an inventory list with a part number and perhaps a word "missing"...
April 9th, 2010 06:58 PM
by Carrie_Loos via OfficeKB.com Go to last post
5 135
open workbook to specific sheet by Mr E
I am trying to force excel to open to the same workesheet each time the work book is opened. regardless of where it was last saved. Is this possible? If so,...
April 9th, 2010 06:53 PM
by Gary Brown[_6_] Go to last post
1 89
IF Formula by SilviaG
I have formula =min(312,200+8) and im trying to add the IF function to it as well, with the logic that if 0312 that the text will change a certain color if...
April 9th, 2010 06:26 PM
by David Biddulph Go to last post
1 74
Excel by Bear
Without manually changing each entry how do I change a column of positive numbers to negative numbers. Thanks in advance Bear
April 9th, 2010 06:24 PM
by David Biddulph Go to last post
2 74
Format custom number: C-0000-L by Sonia
Hi, I need to format a few cells in Excel to look like C-0000-L where "0000" represents four numbers and "L" represents a letter. I tried to do it in format...
April 9th, 2010 05:56 PM
by tompl Go to last post
3 96
Excel is reading formula as a value by Louise[_5_]
how do i get excel to read ='sf-14'!ag13 as a formula. i want the value from one worksheet to appear on another worksheet. -- Louise
April 9th, 2010 05:48 PM
by Louise[_5_] Go to last post
3 89
Conditional Formatting Confusion... by frakincaprica
What I am trying to do seems simple to me. I have a forumla in A2. A2 = B3-B2 I want to know when A2 is not equal to a value in F2. (Red) I want to know when...
April 9th, 2010 04:48 PM
by David Biddulph Go to last post
2 92
Clearing fields when differnt function selected by Xman
OK, I have a spreadsheet-packing list thats gets populated from 3 differrent list's depending on what kind of slip I'm preparing via a drop down menu. Is...
April 9th, 2010 04:46 PM
by Xman Go to last post
0 86
How do I write an IF function using dates? by Stinky
I'm trying to do a logical test that uses dates. If I use it returns the correct result, but if I use = or I get the wrong result: A ...
April 9th, 2010 04:42 PM
by David Biddulph Go to last post
3 83
How do I stop Excel from automatically resizing my row height? by Geerdad
I have a spreadsheet with approximately 3800 rows and about 40 columns of data that I'm constantly filtering and massaging data in. It's getting frustrating...
April 9th, 2010 04:40 PM
by Geerdad Go to last post
0 113
Protecting sheets with drop down boxes by Dolores Gomez[_2_]
I have a spread sheet that has drop down boxes with functions and validations. I want to be able to protect this spreadsheet so that users can only be able...
April 9th, 2010 04:13 PM
by Dolores Gomez[_2_] Go to last post
0 93
Include CDF to workbook by JP Ronse
Hi All, I want to use COUNTDIFF (Morefunc add-in) and sometime ago I have read overhere that is was possible to attach a function to a workbook (Excel 2007)...
April 9th, 2010 03:52 PM
by JP Ronse Go to last post
2 64
Help to resove this problem. by MAX
I have a workbook with 3 sheets. Sheet 1 is named (D), Sheet 2 (Settings) and Sheet 3 (Countries). In sheet (D), I have all the countries that I require ( 39...
April 9th, 2010 03:48 PM
by Don Guillett[_2_] Go to last post
1 63
Checking the results of a number of IF formula by Stu
Hi I am trying to verify that all the tests have passed in the Table below and show an over all pass. 1 B B C D 2 ...
April 9th, 2010 03:46 PM
by Teethless mama Go to last post
4 72
COUNT BLANK AND ZERO AS THE SAME THING by jjlang
I'm writing an IF function and want my formula to return a 1 if the cell has a number in it, but return a 0 if the cell is blank of has a zero in it. ie Cell...
April 9th, 2010 03:23 PM
by Ron Rosenfeld Go to last post
6 110
Help with N/A in formulas by Mark D
Afternoon everyone I have 2 formulas that I need a little bit of help on. Both are working fine but I want the cell to be blank if the result is N/A. Just...
April 9th, 2010 03:04 PM
by JP Ronse Go to last post
3 96
copy data from one sheet to another using a combo box by Tomwireless
I Have 2 sheets, a database of items sheet and a form with a combo box to put the record I get from the database. I want to pick a record from the database...
April 9th, 2010 02:56 PM
by Steve Dunn Go to last post
1 100
Hyperlink to the meat of a cell by Pierre
This would be easier for all of us if I knew the right terminology but here goes nothing. I have an excel spreadsheet with approx 5000 part numbers. I am...
April 9th, 2010 02:54 PM
by Steve Dunn Go to last post
4 166
Hostname from IP address by NickT[_2_]
Hi, I am hoping someone can help me please.. I have a spreadsheet that is linked to a survey being hosted on our website. The survey is about internet safety...
April 9th, 2010 02:31 PM
by Steve Dunn Go to last post
1 160
Post New Thread


Display Options
Showing threads 1421 to 1440 of 87787
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 03:54 PM.


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