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
Searching String for phrases/multiple text strings by Altair1972m
I have a column of Vendor Comments on the Outreach effort such as "Client's case is closed" "Client lacks transportation" "Client is 8 months...
May 16th, 2009 10:44 AM
by Greg Lovern Go to last post
4 180
how do i select which data to use depending on the date? by RJinNZ
I need a function that will let me work out how much of an amount to cover certain date ranges. I would like to be able to enter any two date ranges eg...
May 16th, 2009 07:44 AM
by RJinNZ Go to last post
0 136
Transferring only certain rows to seperate worksheet by JRD
Is there a function in excel 2007 and 2003 for picking only certain rows / cells from a worksheet and copying them to a seperate worksheet in the same...
May 16th, 2009 05:36 AM
by Ashish Mathur[_2_] Go to last post
5 128
using multiply if function by lbreger
I need to create a formula using this information. Lets say cell G3 is an age 28.4 Than I need in another cell If G3 is 30 = 1.25 30-40 =1.0 ...
May 16th, 2009 05:20 AM
by Ashish Mathur[_2_] Go to last post
4 134
sorting by teh_chucksta
how can i sort a column with numbers and text, in descending order, where the text falls to the bottom and not the top? thanks, charlie
May 16th, 2009 05:13 AM
by Ashish Mathur[_2_] Go to last post
2 117
Define variable range input for SUM() function by JeffC
Hi, I need to be able to sum a range that will vary in size depending upon the month. For instance, if the month is march, then I would like the SUM...
May 16th, 2009 03:54 AM
by T. Valko Go to last post
4 111
matching 2 worksheets by melody_ph
I have been reading the blogs but couldn't really find what I'm looking for. I have 2 sheets. One is our ledger that has 3 columns as follows: A - Date B -...
May 16th, 2009 02:35 AM
by OssieMac Go to last post
1 99
Why do people use =+A2 or =+d3? What does the "+" reference? by Chris 21222222
Any information would be greatly appreciated.
May 16th, 2009 12:06 AM
by JoeU2004 Go to last post
4 118
Formula assistance for gymnastic scoresheet by Lisa W
I am trying to develop a score sheet for a gymnastics competition and need help with the formulas. In one part of the sheet there are four judges for a...
May 15th, 2009 11:49 PM
by Pete_UK Go to last post
2 81
Define Name - same name for multiple cells on multiple sheets by Thomas
Hi community: I've been searching for a while to find an answer to my problem but couldn't, so here it is: A B 1 1001 Food Sales Lunch 2 ...
May 15th, 2009 10:48 PM
by RagDyer Go to last post
3 97
='[master workbook.xls]3108'!K25 trying to use value of cell for 3 by djames2007
This may be confusing but we have a detail workbook for each job (3107,3108, 3109, ...) each detail workbook has cells tied to the master workbook (the 3108...
May 15th, 2009 10:46 PM
by Dave Peterson Go to last post
8 166
Estimating Stock Trading Range From Historical Volatility by carl
I have a list of stocks and their historical volatilities. Is there a formula that can be used in excel which could estimate the trading range of the stock...
May 15th, 2009 09:28 PM
by Don Guillett Go to last post
3 91
Help with SUMPRODUCT by Alex Mackenzie
I admit I do not fully understand SUMPRODUCT; I am trying to follow the variious samples I have found. Data: Whs Reasons Returns 1 1 ...
May 15th, 2009 08:17 PM
by Dave Peterson Go to last post
7 97
is there an AND logical ? by 0nanman
i want to check multiple cells with something like: IF CellA=1 AND IF CellB=CellC,1
May 15th, 2009 08:07 PM
by Rick Rothstein[_2_] Go to last post
7 93
is there an AND logical ? by Don Guillett
You're right. I had to type in and function -- Don Guillett Microsoft MVP Excel SalesAid Software "Don Guillett"...
May 15th, 2009 08:05 PM
by Glenn[_6_] Go to last post
2 87
importing data from a txt file by rrlogan
The software my company is using creates 2 rows of data for each sku which I can create as a txt file to import into excel 2003. LIke this: Sku ...
May 15th, 2009 07:37 PM
by Bernard Liengme[_2_] Go to last post
1 112
Finding the current year by BrittaniMV
I am trying to determine the current year at a given date. For example, if my beginning date is 1/1/2000, as of 12/31/2002 this date in time would be in...
May 15th, 2009 07:34 PM
by Bernard Liengme[_2_] Go to last post
3 150
Excel formulas become cell contents by DJLT
I am experiencing a problem in Excel. When I enter a formula (any formula) in certain cells the formula remains visible in the cell as the cell content. ...
May 15th, 2009 07:12 PM
by Jacob Skaria Go to last post
3 121
How can I ge tmy sum to show the + sign for positive sums? by Karie
I am summing up two cells and want the + sign to show for the positive sums and the - sign to show for the - signs....anyone know how this is possible?
May 15th, 2009 06:52 PM
by Jacob Skaria Go to last post
2 98
replacing zeros with blanks but leaving dates alone by Evil with a K[_2_]
Ok here is the problem; I have a column that displays a date if no date exists then a zero is placed in it. What I am trying to do is to clear (display...
May 15th, 2009 06:48 PM
by Rick Rothstein[_2_] Go to last post
3 273
Post New Thread


Display Options
Showing threads 11021 to 11040 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 01:08 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.