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 Reverse Sort Order Last Post Replies Views
help with formulas by Bradly
I have a list of applications that have gone overdue. Here is a sample of my list: Program Code Case # Delay Code P60 401133012 P60 ...
February 3rd, 2010 03:05 AM
by Ashish Mathur[_2_] Go to last post
2 141
Office 2007 Compatibility Pack issue? by bradmo
Setup: - Managed code UDF, isolated via COM shim - Office 2003 with Office 2007 Compatibility Pack installed - Workbook created in Office 2007, uses functions...
February 25th, 2008 04:01 PM
by bradmo Go to last post
1 77
Pull in a colum of financial data based on the month by Bradon
I am creating summary reports that compare one financial period to another. The Budget, Prior Period and Current year are in tables and there is a column...
September 15th, 2006 07:37 AM
by Biff Go to last post
1 79
SUMIF or IF Function? by BradP
I am creating a spredsheet to calculate our sales employees' bonuses. Their bonus is a different % depending on what type of job it is and who the sale person...
March 4th, 2006 02:44 PM
by BradP Go to last post
5 84
Other Sum Question by BradP
I am trying to come up with total to complete by Plant Division. All the data is on across 1 Row. Ex. Job /Paint/Division /Detail /Division /Inspection...
March 6th, 2006 04:43 PM
by Domenic Go to last post
3 75
Common Numbers Formula by bradrob
I wonder if anyone has tried this before i have a large spreadsheet of numbers which i need to find the most common numbers that appear in the tabel so i am...
November 28th, 2005 10:00 AM
by bradrob Go to last post
4 100
lookup for worksheet by Bradrok
Each worksheet is named for a month plus a data sheet and a roll-up sheet. each month is just data with expenses of each project. In the Roll-Up sheet I...
April 2nd, 2008 11:04 PM
by sahafi Go to last post
1 96
Countif with multiple criteria by bradsalmon
Hi all, I'm looking to try and include more than one criteria in a countif statement. I've seen the examples of adding to separate countif statements together...
May 2nd, 2008 05:00 PM
by Dave Peterson Go to last post
5 69
Issue sorting by date by bradsdad25
I have a user who has a sheet that has dates sorting like this, what can I do to change it to sort from 1/1/96 thru my last date? I've tried formatting the...
January 29th, 2007 11:27 PM
by Gord Dibben Go to last post
4 73
CONVERTING MINUTES AND SECONDS TO MINUTES ONLY by bradsmih
Hi, I have a column displaying time in hours:minutes:seconds. I have used the CONVERT function to change hours:minutes:seconds to minutes:seconds, but I need...
May 24th, 2004 04:00 PM
by bradsmih Go to last post
3 341
compare cells in column to criteria, then average next column cell by Bradwin
I have a spreadsheet that has two columns. I want to search through the first column for a specific value, and if the value is met, average the value in the...
July 21st, 2008 08:37 PM
by Bradwin Go to last post
2 94
How do I write the proper Formula for the following? by Brady D
Here are the paramaters I am trying to write a funtion for using Excel 2007: If C3=0, then final value will be C58/2 If C58=0, then final value will be...
June 14th, 2008 10:42 AM
by Per Jessen Go to last post
1 90
i need help creating a function that will extract words from a string of text by [email protected]
i have a very long column in Excel that has the following type of information in each cell: Bosch|Dish|Dishwasher|Bosch Dishwasher I'm trying to use FIND,...
July 20th, 2007 10:51 PM
by Harlan Grove Go to last post
4 71
Value of String used in Calculation? by Brad[_5_]
I have a basic formula (using basic math operators, no excel calls) that is being impacted by a 'general text' value in a field. So, if my formula is...
January 25th, 2008 09:17 PM
by Bernard Liengme Go to last post
1 109
List ? - How do I make information in one cell determine list to u by Brad_A
For example, if I have an option of putting a-z in cell A1... in cell B1, I want to pull a list that is specialized based on the information in A1 (A List, B...
January 18th, 2005 05:10 PM
by Jason Morin Go to last post
1 239
Concatenate Doesn't Work for this by [email protected]
On a labor time spreadsheet, The date is in one cell and the time is shown in successive cells for each record. I need to be able to merge the date...
September 11th, 2006 08:23 PM
by General Specific Go to last post
3 152
Lookup a value between two numbers by [email protected]
If you have two values that equals a certain value, now let says the value that you have falls in between these two values, how do you get excel to reconize...
April 20th, 2006 04:42 PM
by Toppers Go to last post
3 97
Two cell Comparison with three different Criteria by [email protected]
=(IF(OR('Calculation-Part 46 & 48 Viols.'!O17="No Likelihood",'Calculation-Part 46 & 48 Viols.'!O17="Unlikely"),60,VLOOKUP('Calculation-Part 46 &...
December 28th, 2005 04:33 PM
by [email protected] Go to last post
8 127
reference to a sheet by Braga Luiz
I want to make a way to get a value from a especific sheet=20 that changes with year. Lets say I have a file=20 (spreadsheet) with four sheets (2005,2004,...
August 12th, 2004 05:48 PM
by Frank Kabel Go to last post
1 252
assigning a value to a cell by Braheem
Ok here is my senario: I have a student roster with NAMES, NUMBERS, CODES, ETC. I would like to assign the number 1 to each cell in the NAME column that has...
September 13th, 2006 04:42 AM
by Baraki0568 Go to last post
3 82
Post New Thread


Display Options
Showing threads 10001 to 10020 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 07:53 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.