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
Cross/Multi-posted on purpose...... by CLR
Hi All, SameStuffDifferentDay..........my posts are still all missing from this newsgroup, and have been cut 'way back from the other groups.......as soon as...
October 2nd, 2003 05:17 PM
by Jake Marx Go to last post
4 160
list sorting by jake
I have a long list, about 2,000 rows with 8 columns, and I am trying to get a random sample from this list. I then want this random sample to be drawn from...
October 2nd, 2003 06:39 PM
by Harlan Grove Go to last post
1 326
SUMIF based on Today() function by Andrew Holmes
I would like to be able to calculate sales figures in one column based on a comparison of today's date with the date received information put in the sheet by...
October 2nd, 2003 07:33 PM
by Biff Go to last post
1 313
autosum by
is it possible to autosum from 2 different sheets
October 2nd, 2003 07:50 PM
by Paul B Go to last post
1 185
Dsum vs SumIf performance by Susan Lammi
I need to do a conditional sum on a column of numbers and have two choices I can see. the condition is the combination of two other cells (adjacent...
October 2nd, 2003 08:06 PM
by Charles Williams Go to last post
1 324
Hyperlinks by Ross
Are you able to create a hyperlink between two workbooks and specify which sheet the hyperlink should go to?
October 2nd, 2003 08:07 PM
by Ross Go to last post
2 131
auto-formatting weekends with colours & automatically inputing holiday in autoformatted cells by eijaz
hi all, this is my first post to this group. i am working in a mortgage loan servicing call-center as a team leader & handle agents under me. i am trying to...
October 2nd, 2003 08:24 PM
by eijaz Go to last post
6 555
Application of "Rank" formula to a table by MY
I have a table in Excel that has column headings from B1 to J1. In Column A (starting A2), I have dates going down. The table is populated with numbers...
October 2nd, 2003 08:55 PM
by Bernd Plumhoff Go to last post
1 218
Template Update Help by ND
I have created a template to use as a form when filling in a database and it works wonderfully when I am adding a new record, however, I am not able to update...
October 2nd, 2003 09:19 PM
by ND Go to last post
1 625
TRIM Macro by Danny
Can somebody help me write a macro to TRIM extra spaces? I tried the example in the built excel help (see below) but it won't work. I need the macro if I...
October 2nd, 2003 10:24 PM
by Danny Go to last post
2 172
Is there a way to NOT reduce fractions? by atom
I have a formula that divides the numbers in two cells. The result is displayed as a fraction. How can I keep the numbers from being reduced. i.e. I DON'T want...
October 2nd, 2003 11:04 PM
by J.E. McGimpsey Go to last post
2 78
How do I calculate in a % (taxes)? by Treg
I recently made a recipt template and I was wondering how I can get a tax total to show up? I just need to know what formula (x 7.75%) to use to get the tax...
October 2nd, 2003 11:06 PM
by treg Go to last post
3 145
Countif Function by Joe Gieder
I'm trying to count the number of cells that are greater than "26 wks". When I use Countif('Priced BOM'! S3:S82,"=26 wks") I also get the cells with 3 wks,...
October 2nd, 2003 11:09 PM
by Joe Gieder Go to last post
2 92
excel Function/macro by Lance Masunaga
Is it possible to run a macro and a function simultaneousely. Example. When you run a macro if a certain cell has a specific data in it then do this, if not...
October 2nd, 2003 11:26 PM
by Jill Go to last post
1 98
worksheet delay response by Alice Thomson
When opening an existing excel file for the first time there is a 30 second delay before any changes are seen or can be used. The delay does not occur in a new...
October 2nd, 2003 11:38 PM
by Jill Go to last post
1 93
Excell Worksheet by tONY
How can i build a clear Button in my worksheet to clear the unprotected cells of the partialy protected page. Do I have to have Marcros incorporated with or...
October 2nd, 2003 11:42 PM
by Jill Go to last post
1 88
Summing marked cells by Sam
I need to include "marked" cells in a formula. Ideally, when a cell is shaded a color or marked in a similar manner, this would cause the cell to be included...
October 2nd, 2003 11:59 PM
by Jill Go to last post
2 261
=IF function by Raffi
I could really use some help with a function in Excel. Example: A1 has the number 5. in cell A2 I want to use a formula to calculate the following. If the...
October 3rd, 2003 12:28 AM
by J.E. McGimpsey Go to last post
2 128
Number days between 2 dates by Kreiss
I'm looking to find a way to tell how many days are between two dates. I found function, "Days 360", but that doesn't give me a true number since it's based...
October 3rd, 2003 01:48 AM
by GB Go to last post
6 553
Bold/Underline in formula by mate
I have the following: ="with effect from November 2003 to the sum of £" &ROUND(E33,2) &"." I need the 'Nov 03' and the result of '&round' to be bold...
October 3rd, 2003 02:24 AM
by GB Go to last post
3 113
Post New Thread


Display Options
Showing threads 861 to 880 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 02:15 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.