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 Reverse Sort Order Last Post Replies Views
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 184
Summing Filtered Rows by
Ok, I've filtered my spreadsheet using AutoFilter and selecting one of the availble cell contents as a criteria. Now that I've got a table that shows only the...
March 29th, 2004 09:22 PM
by Frank Kabel Go to last post
4 144
Formula by
agian you can use the vba function: "Worksheet_Change" each use you change CELL this function will be activated and put in the target cell the output. For...
April 21st, 2004 07:22 AM
by Go to last post
0 78
copy & paste from other worksheet - but not allow to cut by
I have a formatted area I try to keep right formatted! I have tried to use conditional formatting, but when you paste a cell from an other worksheet, that...
April 28th, 2004 03:42 PM
by Go to last post
0 779
Find the 5 max values in a column? by
Any one know of a way to: On a column: Formated as numeric Return the Max(thats the easy part and the "max" function will do that), and the next 4 values (ie...
May 11th, 2004 07:15 PM
by Aladin Akyurek Go to last post
3 229
VLOOKUP by
Randy wrote: in the range that contains the lookup value, there are multiple or duplicate entries, is there a function or formula that gives all...
July 8th, 2004 06:00 AM
by Alan Beban Go to last post
1 125
formula help by
i need some help please. I know a little bit about excel, but im having some trouble combining formulas. this is what is in cell...
July 8th, 2004 10:21 PM
by Go to last post
4 96
serach multiple worksheets within a workbook by
Is it possible to search for information in multiple worksheets within a workbook at the same time rather going into the individual tabs and using...
July 12th, 2004 06:29 AM
by bigt Go to last post
2 292
Q: locking some, but not all, properties of a cell by
Folks, Is there a way of locking the format of a cell, but not the contents? We have a shared yearly planner type spreadsheet in which cells are coloured to...
July 12th, 2004 04:35 PM
by MikeC Go to last post
2 105
Is anyone bright enough to help? by
Let me clarify. I am trying to transfer data from an excel 2002 cell to a specific place in a word 2002 document. I am not trying to cut/copy and paste. I...
March 12th, 2004 03:13 AM
by JulieD Go to last post
5 208
Got me stumped by
I have an Excel Report that was generated by ODBC. I was asked to customize the report so that company numbers on one sheet would look up into another sheet...
March 11th, 2004 07:21 PM
by CMG Go to last post
2 103
simple function by
Hi, I have a simple function to figure out but without much experience. I hope someone will answer. Let's say I have two columns A & B. I want a formula...
October 15th, 2003 08:40 PM
by Go to last post
7 117
enter a null or "blank" value in a cell by
How do I get an Excel Function to place a NULL value in a cell vs. a blank or space. Here an example: Cell A1 contains the number 11, when I enter the formula...
October 16th, 2003 08:48 PM
by Harlan Grove Go to last post
1 479
Blanks vs. Null values in Functions by
How do I get an Excel Function to place a NULL value in a cell vs. a blank or space. An example: Cell A1 contains the number 11, when I enter the formula...
October 17th, 2003 12:02 PM
by Paul Go to last post
1 528
Random Number Generator - Help! by
Any and all help is appreciated. Starting in Cell B7, I have a list of names. In E7 is a sequential number (starting at 1) that is associated with each name....
November 3rd, 2003 04:36 PM
by Arvi Laanemets Go to last post
3 297
workdays by
i searched the archives but and I know its there but couldent find it. I need to only include only workdays in my formula (m-f)
December 16th, 2003 09:28 PM
by Go to last post
1 94
Cell Format by
Thanks again. Any idea what this one is doing and how to fix it? I insert 90014E04 and Excel converts it to a scientific number 9.00E+08 Any idea what the...
March 9th, 2004 12:01 AM
by Frank Kabel Go to last post
1 378
formula not calculating correctly by
The formula in the third column is =L8/M8. I have the third column formatted as Percentage with no decimal positions. As you can see the cells with an...
March 9th, 2004 01:18 PM
by Jerry W. Lewis Go to last post
3 219
AUTO ADDITION by
I AM LOOKING FOR A WAY TO HAVE EXCEL AUTOMATICALLY DO SOME MATH FOR ME. FOR EXAMPLE, IF I TYPE 25 IN CELL B4, I WANT IT TO AUTOMATICALLY ADD 25 TO IT. ANY...
March 11th, 2004 07:07 PM
by Bernie Deitrick Go to last post
4 129
Automaiticly move from one cell to the next by
Need to automatically move from one cell to the next after entering data in a cell. Using a worksheet to scan in receipts as the are being offloaded from a...
September 30th, 2004 02:03 PM
by Bob Lounsbury Go to last post
3 123
Post New Thread


Display Options
Showing threads 241 to 260 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 10:29 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.