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 can I use wildcards in IF statements and Macros by AlanF
I want to include in a Macro, something to take a particular action if the active cell contains text beginning with X. I thought something based on an IF...
November 23rd, 2009 12:08 AM
by Dave Peterson Go to last post
2 141
Clear a cell's contents when document is saved by Gary
Is there a non-macro way to clear a cell's contents automatically when the spreadsheet is saved? This is one of several un-locked cells in my spreadsheet...
November 22nd, 2009 11:33 PM
by Gary Go to last post
2 137
How do I count the number of time 2 columns meet my criteria by Mrswhit9
Can anyone tell me what is wrong with this formula? I am trying to say if the text in column B = this, and the text from column C = this, and then count the...
November 22nd, 2009 11:19 PM
by Gary''s Student Go to last post
2 122
1904 negative time by Dale G[_2_]
I would like to use the 1904 date system to calculate positive & negative time. I have column (c) preset with an scheduled arrival time, and a blank column...
November 22nd, 2009 10:44 PM
by Dale G[_2_] Go to last post
5 120
Cannot empty the clipboard by Jaleel
Hello, I am using Excel 2003. All on a sudden, when I am trying copy even a single cell, I am getting the message, "Cannot empty the clipboard". I don't...
November 22nd, 2009 09:57 PM
by Victor Delta[_2_] Go to last post
1 199
Excel formula by sleepless
I have a list of about 400 last names that I want to use to find in those names in other lists I have by doing an advanced filter. Many of the names are...
November 22nd, 2009 09:48 PM
by sleepless Go to last post
4 116
Can I sort text data by reference to text data in another column? by mel1936
I have imported text data (e-mail addresses) into a worksheet that also has a column of text data (also e-mail addresses), many of which, but not all, are...
November 22nd, 2009 08:29 PM
by JLatham Go to last post
1 114
Data Forms by MarkOffice2007
How do you create a data form from a worksheet and does the information entered into a data form appear in the worksheet? Once information has been entered...
November 22nd, 2009 08:28 PM
by FSt1 Go to last post
2 138
Removing unwanted fonts by Abi
I've tried to remove unwanted fonts from Excel and place them in a folder called 'fonts backup'. However, they keep appearing when I open Excel. Is Excel...
November 22nd, 2009 06:47 PM
by Gord Dibben Go to last post
2 95
how to generate data from graph in excel by Vads
I've a graph (source data of which is not avalable), from which I want to extract data (X & Y values). Can anyone guide me how to do this?
November 22nd, 2009 06:38 PM
by Herbert Seidenberg Go to last post
2 111
Spreadsheet macro stopped working! by Anders[_3_]
Hi, I recently made an Excel spreadsheet for keeping track of my golf score. The spreadsheet is quite simple. It consists of 4 sheets: Scorecard,...
November 22nd, 2009 06:28 PM
by Gord Dibben Go to last post
5 109
Migrating to Excel 2007 by RussellT
I use the following code to filter data in Exel 2003. Sheets("DevData").Range(SourceDev).AdvancedFilter Actiion:xlFilterCopy,...
November 22nd, 2009 05:36 PM
by Jon Peltier[_2_] Go to last post
2 160
assign value based on criteria and total by rascal
I have cells from c9 to AB9 that are populated with 1 of 4 different letters. I have been able to get a count based on the criteria but what I need to do is...
November 22nd, 2009 04:38 PM
by Mike H Go to last post
1 95
How to use Report Manager to print a series of worksheets? by Davidhg
I used to use Report Manager to print a series of worksheets or worksheet views which I found very helpful. But I can't now find this tool amongst Excel 2003...
November 22nd, 2009 03:32 PM
by JLatham Go to last post
1 157
Outlook 2007 crashes by sknair02
Hi, AppName: outlook.exe AppVer: 12.0.4518.1014 AppStamp:4542840f ModName: outlfltr.dll ModVer: 12.0.4326.0 ModStamp:44c81343 fDebug: 0 ...
November 22nd, 2009 02:29 PM
by Dave Peterson Go to last post
1 232
Formula to extract number values only by April
Hi, I can't seem to remember how to use a formula to extract numbers only. For example, I would like to take a create a formula to pull only "3.5" for a cell...
November 22nd, 2009 01:06 PM
by Ron Rosenfeld Go to last post
9 145
RANK based on result and average by Narendra Boga[_2_]
Hi All, I have a trouble with Rank() function. I have written normal rank function based on "Average" column and working fine. But I need the rank based on...
November 22nd, 2009 12:51 PM
by Lars-Åke Aspelin[_2_] Go to last post
5 151
what format to use for an subsentance in law 9.15.1.1 (1)(a)(ii) by hidingfromcops
when ever i try to enter things in to a colomn it sorts it like 9.1.1.1 9.15.1.2 9.2.4.5 9.25.4.2 9.6.1.4 as you can see I would like the bigger number after...
November 22nd, 2009 10:11 AM
by David Biddulph Go to last post
2 99
Net Send to many by Tazflerts
Hi All, I am trying to send network notifications from a selection in Excel 2003 net send B1F4CU35 Please remember business casual Wednesday, Thursday and...
November 22nd, 2009 05:21 AM
by JLatham Go to last post
1 113
Excel number format by Mibrayev
People, here is the problem I am facing. my excel accepts both number in "100.00" (hundred) format and "100,00" (hundred ) format. both of them are numbers...
November 22nd, 2009 03:27 AM
by Ms-Exl-Learner Go to last post
1 129
Post New Thread


Display Options
Showing threads 9621 to 9640 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 02:38 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.