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
Returning multiple cells by bmcgill
I would like to look at cells A1, A2, A3, A4 If the value of C1=A1 then it displays in separate cells the data from Cells D1 thru D5, if C1=A2 displays D6...
August 7th, 2008 08:52 PM
by Lars-Åke Aspelin[_2_] Go to last post
1 110
Calculating towards a target number by Mary
Dear Excel Expert, I am trying to figure out a formula for a prison length. I have a set sentence length which is a number of months (format 00.0), for...
August 7th, 2008 08:33 PM
by Mary Go to last post
2 85
Formula for x & y calculation by K. Carter
I need help building a formula to calculate both the "x" and "y" values for the following equation: x + y = 90 2.15x + 2.4y = 202.35 The solution would be x...
August 7th, 2008 08:07 PM
by Bernie Deitrick Go to last post
5 117
stop macro if cell does not equal zero by BIGBOY1974AA
Is it possible to stop a macro if a cell does not equal zero then post the message cant send until reports are finished
August 7th, 2008 07:02 PM
by Duke Carey Go to last post
1 104
If Function With A Time by Donna
Hello all. I need help with an if function that will result in No Delay if Total Time is less than or equal to 2:30 (two hours, thirty minutes). My total...
August 7th, 2008 06:49 PM
by Donna Go to last post
5 87
Automatic Selection of Multiple Rows by Emmlie
There are times when I select a row in excel that it will automatically select multiple rows. How do I turn this feature off?
August 7th, 2008 06:43 PM
by Peo Sjoblom[_2_] Go to last post
3 97
Excel Worksheet Password Protection by Christina
I have seen in here that someone has asked the question on how to unprotect a worksheet when the password has been lost or forgotten. The answer given is...
August 7th, 2008 06:16 PM
by Peo Sjoblom[_2_] Go to last post
1 96
Subtotal Function is Inconsistent by TKS_Mark
I'm using =SUBTOTAL(9,A8:IU8) on a large row of cells. This large row of cells contains many sum functions. On some spreadsheets, the subtotal only counts...
August 7th, 2008 06:00 PM
by TKS_Mark Go to last post
4 87
Excel 3-D Reference by FirstVette52
I need help with aq 3-D reference error (REF#): ='Sheet1:Sheet5'!B2 Thanks for the help -- FirstVette52
August 7th, 2008 05:52 PM
by Peo Sjoblom[_2_] Go to last post
3 80
Keeping linked sheets relative... help! by Gaijintendo
I am linking to external sheets but as soon as I enter SheetName!A1 it resolves it to something like ='Macintosh:Users:MyName:Desktop:SheetName'!A1 Which is...
August 7th, 2008 05:38 PM
by Spiky Go to last post
2 95
Multiple pivot tables, based on same source data tab; disable refreshon 1st tab? by Pierre
Have created a PT based on the input from a source data tab. Now, I've duplicated the PT onto an additional tab, with the hope that I can enter different dates...
August 7th, 2008 05:35 PM
by Pierre Go to last post
0 101
Add different values that equal 1 on a row by Add sum of different values
I am trying to add how many seat hours per equipment type each person has. Which formula should I use? I've tried several and I get errors. Example: Crane...
August 7th, 2008 04:52 PM
by Sandy Mann Go to last post
2 82
automatically show modified date? by Tacrier
When I save changes to my current worksheet, is it possible have a formula in A2 to display today's date (based on the condition that changes were saved to...
August 7th, 2008 04:52 PM
by Tacrier Go to last post
2 91
Address of last nonzero value by Wigi
Hans, here are some formulas for last cell: http://www.mvps.org/dmcritchie/excel/lastcell.htm -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music
August 7th, 2008 04:30 PM
by Wigi Go to last post
0 92
return values in the table with multiple conditions by cprao
I have a table like this columnA ColumnB Amount A1= 10 0 -1.00 A2= 11 10 2.00 A3= 12 0 ...
August 7th, 2008 04:18 PM
by cprao Go to last post
3 112
look for missing element by SteveDB1
morning all, I have two worksheets. One worksheet is a comprehensive listing of all my components ( it's called sheet A), and the second is a summary of the...
August 7th, 2008 04:01 PM
by SteveDB1 Go to last post
1 71
VLOOKUP by lindle101
I am trying to do a vlookup and when I check my calculation steps it says that 'the cell currently being evaluated contains a constant'. I am not sure about...
August 7th, 2008 03:52 PM
by John C[_2_] Go to last post
5 67
Address of last nonzero value in a range by Ron Coderre
Maybe something like this (in sections for...
August 7th, 2008 03:21 PM
by Ron Coderre Go to last post
0 87
how do i create a scroll option presenting a changeable figure? by VK
I gained a recent document from a client who showed a changable figue within a scroll bar. the way it works is that the scroll bar represents 100% of this...
August 7th, 2008 03:18 PM
by M Kan Go to last post
1 144
Conditional Format based on value of another cell by [email protected]
Hi I have a spreadsheet and need to automatically colour a cell in col A green if the value in col Z of the same row is between 0.8 and 1.1 Conditional...
August 7th, 2008 02:22 PM
by Bob Phillips[_2_] Go to last post
5 90
Post New Thread


Display Options
Showing threads 21941 to 21960 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:32 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.