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
Use DocProps in a change declaration by chris w
Below is a change declaration I have in a sheet, is it possible to have a similar change declaration using docProps in another cell? So when the change is...
January 22nd, 2005 12:35 AM
by Bob Phillips Go to last post
7 245
getting a percentage by Mikewoodmsw
I want to convert a test score to a percentage, however the fraction may change e.g. column E displays scores which are out of 14. How do I have...
January 22nd, 2005 01:07 AM
by Gord Dibben Go to last post
3 104
VLookup? Or something else by JICDB
I have a workbook with two tabs(worksheets) on it. The first contains a copied 6 column database from an external source. In the second worksheet I want to...
January 22nd, 2005 03:19 AM
by Peo Sjoblom Go to last post
5 112
Question
Time In Decimals by Superslinky
Can anyone help me do this? D1-B1-C1=8.5 hours for the day. How do I format the cells so that excel knows that 0.5 = 1/2 hour. As I have it right now I get a...
January 22nd, 2005 09:41 AM
by Ravinder S. Mahoon Go to last post
7 203
automatically resorting of new entries by mircea
i have a sheet with a list i add a new row and after that i need to automatically re-sort list for including that row at his alphabetically position but keep...
January 22nd, 2005 01:16 PM
by mircea Go to last post
0 87
copy a sheet in same workbook temporary block excel by mircea
maybe is a bug when i copy a sheet in same workbook i observed a temporary block XP Excel program and nothing happend when i try to close Excel, he say that if...
January 22nd, 2005 01:23 PM
by mircea Go to last post
0 404
Order ranking. Any suggestions? by gb_S49
I want to rank / rate the top 20 cells contents in order. ie if i use (=max(A:A)it will give me the maximum (highest) value. likewise unsing min. Is there a...
January 22nd, 2005 01:55 PM
by Aladin Akyurek Go to last post
4 101
Find (Ctrl +F) not searching all open sheets by Caroline
I have Excel 2003 and would like to search (Ctrl+F)through all open sheets at one time. A coworker can do this. Is there a patch?
January 22nd, 2005 06:45 PM
by Gord Dibben Go to last post
2 131
Counting days worked by anonymous person
I am working with a client that has an old accounting system. I can get the data over to excel, spend some time reformatting it and get a good sheet to work...
January 22nd, 2005 08:29 PM
by anonymous person Go to last post
3 229
SUMPRODUCT HELP by JHL
Hello, I have the following formula: =SUMPRODUCT(--(A4='RRBB804 wKLY 011505'!$A$2:$A$1332),--($C$2='RRBB804 wKLY 011505'!$C$2:$C$1332),--('RRBB804...
January 23rd, 2005 12:09 AM
by Max Go to last post
3 79
Comparison Function by Michael
Hi Folks - I have the follwoing data: Col A Col B Col C 45 50 Increase 60 75 Increase 65 ...
January 23rd, 2005 12:42 AM
by Harlan Grove Go to last post
6 102
What is the formula to sum the last ten entries in a row in an Ex. by Pat
I am trying to calculate a running average of the last 10 items I place in a row. Is there an easy way to do this?
January 23rd, 2005 02:53 AM
by Rob van Gelder Go to last post
3 113
removing duplicates testing in 2 coloms by Warzel
I want to remove duplicates from a sheet testing for values in two coloms in the first colom are hunderds of firstnames in the second colom hunderds of...
January 23rd, 2005 12:39 PM
by Ola Go to last post
3 240
=Cell( , ) by Steven
I cannot get this function to work when using a VLookup. My formula is =Cell("contents",VLOOKUP(D5,D8:E10,2,0)) where the VLookup returns an A1 or B1 or C1...
January 23rd, 2005 04:13 PM
by Tushar Mehta Go to last post
5 99
How do I graph normal probability distributions in excel? by erika_323
To anyone that will listen...I need serious help with excel and graphing. I am taking statistics, and our instructor wants us to graph normal...
January 23rd, 2005 04:22 PM
by Tushar Mehta Go to last post
1 220
Excel 97 - Adding Every 8th Row - Formula should work, but doesn't by Damaeus
Here's a formula I found online to add every 7th row: =SUMPRODUCT(--(MOD(ROW(A1:A300)-1,7)=0),A1:A300) I've modified it, of course, to fit the cells I'm...
(Multi-page thread 1 2)
January 23rd, 2005 05:52 PM
by Tushar Mehta Go to last post
12 201
Office 2003 Purchaser can't add in the add in's. Why? by David R. Steele
I'm an Office 2003 Purchaser, and I love Excel. The problem is that I cannot add-in each of the available add-ins. I don't know why. I have certification...
January 23rd, 2005 09:49 PM
by Ken Wright Go to last post
3 101
# of Functions per cell by SUB-ZERO
Hi Is there any way to change the number of functions allowed in each cell? I have a spreadsheet and I need it to handle more functions than 7. 10-15...
January 23rd, 2005 11:35 PM
by Harlan Grove Go to last post
3 403
Counting for two criteria - brain drain by seve
Any help would be greatly appreciated. I need to count the number of dates in column C for each rep (column A) for each Equipment type (column C). A B ...
January 24th, 2005 12:29 AM
by Ola Go to last post
2 95
combining VLOOKUP and IF by z.entropic
I'm trying to get around the problem of VLOOKUP looking up only the first found match. Here's and example: Each row in the first worksheet has a unique value...
January 24th, 2005 01:05 AM
by Bob Phillips Go to last post
4 98
Post New Thread


Display Options
Showing threads 10121 to 10140 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:47 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.