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
testing by testypants
does this thing work????
September 17th, 2003 08:52 PM
by Harlan Grove Go to last post
1 397
Formatting (General to Number) by Tom R
Does anyone know if there is a way to change the number formatting from General to Number in one shot? I have an entire column that is in general formatting,...
September 17th, 2003 08:49 PM
by Ken Wright Go to last post
5 1,017
MouseClick as Counter by David Webster
Is there a way to add code so that you add one to every cell you click on within a range? E.g. any cell between say C3 to H20 when I clik it I want it to...
September 17th, 2003 08:45 PM
by Andy Brown Go to last post
1 324
Pivot Table Display by td
I have created a pivot table with the following parameters: Page Area = Customers Row Area = Product Column Area = Month Data Area = Sales $ When I select a...
September 17th, 2003 08:36 PM
by Debra Dalgleish Go to last post
1 275
sumproduct variables by Tony
Hello Group, How do I include multiple cell reference variables in a sumproduct function? For example, if I wanted to include text values I would use...
September 17th, 2003 08:27 PM
by Aladin Akyurek Go to last post
7 436
Multi worksheet data look up by Ray
I am looking for a way to copy data from multi worksheets to another worksheets. I have 50 worksheets of data and what to copy an area of data from any 1 of...
September 17th, 2003 08:02 PM
by Harlan Grove Go to last post
1 518
emailing protected Excel worksheets by R Maule
when attaching a password protected Excel worksheet to an email, the password protection is not transferring. have attempted using Microsoft Outlook with the...
September 17th, 2003 07:59 PM
by Ron de Bruin Go to last post
1 418
sequential counter by David Webster
I have a column of species and a row of plots as follows: PLOT: 1 2 3 4 5 Spp1 Spp2 Spp3 Spp4 Spp5 .... to Spp 150
September 17th, 2003 07:34 PM
by 2rrs Go to last post
4 301
nested functions by Linda
I am trying to create a nested function that returns a value of a bonus figure paid at 5% over a certain amount e.g .total sales over 2000 and 2% at a lower...
September 17th, 2003 07:26 PM
by Nathan Go to last post
2 339
LOOKUP function by Rod
When I use the LOOKUP function with the following argument =LOOKUP(D4,$A$28:$A$47,$B$28:$B$47) where D4=3.6 and the lookup_vector and result_vector looks...
September 17th, 2003 07:19 PM
by Don Guillett Go to last post
3 302
copying worksheets to other workbooks by Roy
I have a workbook with formulas that reference sheets (tabs). I want to copy the formulas to another workbook with the same tab names and have the formulas...
September 17th, 2003 07:18 PM
by Don Guillett Go to last post
1 587
If then formula by Paul B
Have a look at VLOOKUP in help and see if this will do what you want -- Paul B Always backup your data before trying something new Using Excel 97 &...
September 17th, 2003 07:17 PM
by Don Guillett Go to last post
3 334
Deleting Excess Pages by Mai
I made a 1 page document in Excel. When I go to print this one page it prints an excess of 60+pages. How do I get rid of those pages? I know that I can print...
September 17th, 2003 07:06 PM
by Rafael Ortiz Go to last post
1 328
Using multiple IF statements by David
I have to create a column that shows traffic movement data. I'm not really used to Excel and this is the formula I have come up with thus...
September 17th, 2003 07:05 PM
by Ray Go to last post
4 461
histogram by
Im trying to make a histogram, and i can't get it to work at all. I go to tools, data analysis, select histogram, and then i have no idea what to put into the...
September 17th, 2003 06:57 PM
by Tom Go to last post
1 297
Turn off From: Cc: options under Office by Carl
A user using excel and work encountered a spreadsheet that was sent to them added the ability to send from these platforms. How does one remove these options...
September 17th, 2003 06:29 PM
by Carl Go to last post
0 352
using spell check on a protected sheet by Scott
Lauren, Same problem; I've tried every variant of sheet and workbook protection. My searches at microsoft.com KB/sppt yield no solution (nor does this...
September 17th, 2003 06:19 PM
by Scott Go to last post
0 771
If then formula by photohoward1
I am writing a spread sheet to keep track of a racing club. I would like to be able to enter the place of finish in one cell and have the points automatic in...
September 17th, 2003 05:47 PM
by photohoward1 Go to last post
0 246
graphng distributions by leslie
I am graphing standard normal distribution, i.e. bell-shaped curves. How can I shade an area under this curve?
September 17th, 2003 04:11 PM
by Bernie Deitrick Go to last post
1 266
getting max value of unique dates in a range by ibeetb
I have a 2 ranges both with 16 rows. 1 column has dates with 4 dates being repeated 4 times, which make up the 16 rows. The other colum has values...
September 17th, 2003 04:06 PM
by Bernie Deitrick Go to last post
1 326
Post New Thread


Display Options
Showing threads 87601 to 87620 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 11:06 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.