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
Internal Rate of Return (IRR) by geek@smart
IRR function is unable to determine below cash flows. 0 -868055555.6 -156250000 -156250000 -166666666.7 -90617472.63
June 16th, 2009 10:58 PM
by Fred Smith[_4_] Go to last post
2 225
problem sorting by ty
I can not get the following to sort correctly, 1 7 3 22 x 8 10 x 17 8 x 11 when I sort these they do as follows 1 3
June 16th, 2009 10:57 PM
by Gord Dibben Go to last post
2 213
Separating data in the same cell by Jor
I'm needing to separate some data in columns. Here is a sample: Thomas, Nehemiah JR 1,837.05 ; Tiller, Tanika 2,163.72 ; Tobin, Terri 1,182.66 ; That is all...
June 16th, 2009 10:57 PM
by Don Guillett Go to last post
1 145
Excel comments by zonegrise
Hi, Is possible to change the default font type in Excel comments? (not just the size but the font itself)
June 16th, 2009 10:51 PM
by Gord Dibben Go to last post
1 223
Nested IF by EZ[_2_]
I have a simple quesion about nested IF formula. I need to look up 3 values each in a range, and if all matches show "Y" for yes otherwise "N" for no. My...
June 16th, 2009 10:03 PM
by EZ[_2_] Go to last post
5 163
count if by scooter
I am looking to count the number of times a value(ie "3") appears in one column only if the column next to it has a different specific value(ie "bob")....
June 16th, 2009 09:51 PM
by T. Valko Go to last post
1 153
Need Formula to Know Percent of a row of Pass/Fail data by Moriah
Please Help! :o) I'm drawing a blank on how to create a formula that will give you the percent passing on a row of data that has either pass, fail or a blank...
June 16th, 2009 09:03 PM
by Mike H Go to last post
3 138
How can I pull Cell value from Detail worksheet into Summary sheet? by John Kotuby[_3_]
Hi all, I am inexperienced in using Excel but have been assigned a task which requires designing a Workbook containing formulas. Our little company cannot...
June 16th, 2009 08:50 PM
by John Kotuby[_3_] Go to last post
2 137
2007 Defined Names Is Locked! by D@SE
Running 2007 Vista, opened one of my programs of 2003 in compatibility mode, went to Formulas, to Defined Names but it appears that it is locked. Defined...
June 16th, 2009 08:36 PM
by D@SE Go to last post
2 120
Embedding the value of a cell in a formula by Len
I would like to have the contents of a cell be part of a formula. For example: In one cell I have the year: 2009 In the other a formula references another...
June 16th, 2009 08:21 PM
by Dave Peterson Go to last post
5 152
Spec. Sheet by Muskrat24
I am using excel to create a estimate product list and a spec. sheet of the products selected. on sheet 1 named "Estimate Template" I have the choice such as...
June 16th, 2009 08:16 PM
by Muskrat24 Go to last post
8 133
using vlookup and hyperlink by MJ
I am using VLookup in column “D” that replicates a number from column “B”. This works fine. What I would like to do is type the number into “B”...
June 16th, 2009 08:16 PM
by MJ Go to last post
6 123
Excel 2003: Count total days elapsed by watermt
I need to count the total number of days (counting all days of the week) elapsed between process 1 through 12. Using the m/d/yyyy hh:mm cell formatting, not...
(Multi-page thread 1 2)
June 16th, 2009 08:12 PM
by Ron Rosenfeld Go to last post
12 348
Determie Trend by John Smith
im looking for a function to determine the trend of sales. i have 24 months of sales in columns b:y. All i want to do is determine if sales are trending up...
June 16th, 2009 08:02 PM
by Mike Middleton[_2_] Go to last post
2 127
how to format large word paragraphs into an excel file by dingbat
monthly I am responsible to create a 7 page operational reports listing expenses and savings for my boss. I have two large ten paragraphs in different...
June 16th, 2009 07:14 PM
by Gord Dibben Go to last post
1 119
Vlook up problem by Sarahneedshelp
Hi, I am trying to do a simple vlookup which i have used lots before but this is this first time with using excel 2007 and something seems to be going...
June 16th, 2009 07:09 PM
by Gord Dibben Go to last post
3 122
How do I automate the numbering of a purchase order form. by Mike Riley
I am setting up a purchase order form from a template. I would like the purchase order number to be sequential and automatic each time I acces the form to...
June 16th, 2009 06:51 PM
by Bassman62 Go to last post
2 153
sorting problem 10 comes before 8 by ty
When sorting a list in a column where some are single digits and some are such as : 1 3 8 8 x 12 10 x 10 they sort as follows 1 3
June 16th, 2009 06:51 PM
by Marcelo Go to last post
2 140
Last Date Modified by snickers22
I need help in setting up a cell to reflect the Last Date Modified of a Word Document. I did try Google but I don't fully understand the code that they are...
June 16th, 2009 06:11 PM
by Jacob Skaria Go to last post
2 93
Excell 2007 Pivot Table Calculation changes decimal places by FStJ
I have a file that contains a table with source data built to 2 decimal points. When I compare values across a defined type, the source data with multiple...
June 16th, 2009 05:59 PM
by FStJ Go to last post
2 115
Post New Thread


Display Options
Showing threads 10061 to 10080 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 04:59 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.