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
fomula required by Keith[_22_]
I'm attempting to get a formula to reflect as a %. A1: $4 (a stock high) A2: $2 (a stock low) A3: $3 (current price) How can I get a...
January 7th, 2010 10:06 AM
by Keith[_22_] Go to last post
6 130
Custom Format Cell with Reference to another sheet by enna49
Hi I know this somehow can be done, but having trouble understanding it. What I have is 2 sheets eg MISC ATB and MONTH ATB In a cell on the MONTH ATB I...
January 7th, 2010 07:13 AM
by enna49 Go to last post
2 116
How can I number rows based on unique values in another column? by Carla
I need to create a number in column A based on the data in column B. Here's an example of the result that I want: Number Product...
January 7th, 2010 07:03 AM
by T. Valko Go to last post
4 171
Multiple Users - Different PC/Locations by teelee
I have a excel spreadsheet that 3 people need to work on, I email it out after I edit it then so on. I'm on my pc and the other 2 people are on their pc's...
January 7th, 2010 06:37 AM
by ryguy7272 Go to last post
2 118
Indirect function by JD
A couple weeks ago I posted on here with two tables that I wanted related. I did get one response but I can't seem to make it work. Here was my original...
January 7th, 2010 04:34 AM
by Herbert Seidenberg Go to last post
2 158
Locking comments by MarkVW
Hello. Is there a way to lock comments in a column. i would like the column to appear red with the word locked in each row. and only see the comment with a...
January 7th, 2010 03:40 AM
by MarkVW Go to last post
0 115
Decision tree by Mickeddie
I used to have a decision tree add-in, but since upgrading to the latest Microsoft version, I cannot find it. Nor can I find out how to re-load it. How can...
January 7th, 2010 12:54 AM
by Mike Middleton Go to last post
2 112
Calculating a date by Hugo[_4_]
I've discovered a pile of mortuary cards and I'm trying to put them in an Excel file. But often is only the date of death and the age mentioned, without the...
January 7th, 2010 12:51 AM
by Hugo[_4_] Go to last post
3 97
text fragment comparison by ChrisM
i must count similar pathways, but to a limited extent: eg: column: RIOASSUDroit Ã* partir de 2010 RIOASSUDroit avant 2010 RIOASSUDroit avant...
January 7th, 2010 12:42 AM
by Ron Rosenfeld Go to last post
2 87
Traspose Column data into Row by Zia
Hi, I want to transpose column data in to row. I have seen many posts (using INDEX or OFFSET functions) but all these solution assume a fixed block of data...
January 7th, 2010 12:40 AM
by Herbert Seidenberg Go to last post
3 118
Lookup Text and Receive Other Text in Return by klmiura
I have two worksheets and I am trying to location Referrals that are in one worksheet and match a Marketer based upon the other worksheet Worksheet...
January 7th, 2010 12:24 AM
by Max Go to last post
3 97
Dynamic chart by Flemming
Hi Maybe you can help me out. I have a classic sales table... Jan Feb Mar etc. David 20 21 23 James 18 22 17 Sam 21 25 20 Jane ...
January 7th, 2010 12:19 AM
by Eva Go to last post
1 71
Match values in more than one column by Richhall[_2_]
Hi I have three columns of data and wish to highlight the matches or change the format if there are any duplicates. i.e A B ...
January 7th, 2010 12:13 AM
by Max Go to last post
6 117
subtracting 28 days from a date by Billrpc
I know this is simple, but I am at a loss...A1 is a given date...A2 needs to be 28 days prior. Formula please? -- Bill RPC
January 7th, 2010 12:10 AM
by Teethless mama Go to last post
3 78
rolling 12 month date filter for pivot table? by Randy Suggs
Is there a way to add a rolling 12 month date filter for 'last 12 months' to a pivot table? I see how to add last year, last month, etc., but I need a way to...
January 6th, 2010 10:46 PM
by Randy Suggs[_2_] Go to last post
2 112
random integer with sum constraint by Karin[_3_]
Hi I want to generate two random integers that fall within a certain range ("min" to "max", e.g. 0 to 10) AND that sum to equal no more than a given value...
January 6th, 2010 10:13 PM
by Lars-Åke Aspelin[_2_] Go to last post
8 86
This should not be so difficult but it is to me dates for medi by bigisle
I"ve been working 2 solid days on trying to just figure out HOW to have two date columns change the way I want them to. I KNOW it must be able to be done in...
January 6th, 2010 10:07 PM
by bigisle Go to last post
9 64
Variance Analysis and Excel by Mur
Cell A1 is 10 and input Cell B1 is 5 another input Cell C2 is 5 a formula A1 - B1 I want to only look at variances that are greater than 25% of cell A1 and i...
January 6th, 2010 09:55 PM
by Fred Smith[_4_] Go to last post
1 93
Extracting text from right to left using MID and FIND by Brenda
First of all I would like to thank you in advance for taking the time to look at this post and providing any help possible. I am a novice trying to learn...
January 6th, 2010 09:26 PM
by Rick Rothstein[_2_] Go to last post
6 96
Fill color by Tomg
When I open a spread sheet, the menu bar shows the fill color as yellow. When I change it to another color or "no fill" and use it, everything is fine. ...
January 6th, 2010 08:56 PM
by Gord Dibben Go to last post
2 104
Post New Thread


Display Options
Showing threads 4081 to 4100 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 05:30 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.