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
Counting by AdamMCW
I have a list of scores 1.1, 3.2, 1.2, 2.4, 1.1, 3, etc... . I need to know how many are between 1 and 2. Is this a countif? I can't seem to figure out how...
September 7th, 2006 11:58 AM
by Roger Govier Go to last post
4 50
Copy Worksheets by adams77
I am creating a worksheet for each month with a formula that calculates the YTD in a column. My problem is when I copy the sheet of the previous month in the...
June 13th, 2006 03:32 PM
by adams77 Go to last post
0 67
January 29th, 2008 02:58 AM
by Gord Dibben Go to last post
1 49
how do i break information into columns after importing by adamsj3
I've imported a file and I need to put the data in columns. The data seems merged.
January 4th, 2008 07:20 PM
by Gary''s Student Go to last post
1 78
If a cell is specified by the user, use formula. by AdamT
I have searched the forums and couldn't find the answer to my question, so here goes. I have a spreadsheet that calculates Bittering Units (beer brewing) by...
August 31st, 2006 06:30 AM
by Arvi Laanemets Go to last post
1 65
Help! by Adamw3
I am trying to make it so that column 'D' in my worksheet gives me the total of column 'A' divided by column 'C' (where not 'Part Change', but only between...
August 12th, 2009 02:04 PM
by Glenn[_6_] Go to last post
3 87
If statement help by Adam[_3_]
Looks like this Adam 1 Smith 2 Johns 6 adam 3 smith 4 johns 7 What i would like to do is if
April 23rd, 2007 03:06 PM
by Dave Peterson Go to last post
1 42
How to search a worksheet for text-value matches? by AdanaDarke
I am using a workload log spreadsheet to enter individual customers names daily as requests come in. To avoid entering customers twice by accident i would...
January 3rd, 2008 07:44 PM
by Gord Dibben Go to last post
2 116
how to taking a .txt email list that are separated with spaces and sort them in to excel cells by [email protected]
please help me to taking a .txt email list that are separated with spaces and sort them in to excel cells
August 3rd, 2007 12:28 AM
by Wigi Go to last post
2 122
need to link without having source workbook open by adbowe
I am creating several documents from one main source document in excel 2003. The match and offset fomula created are working fine, but will only show the...
August 29th, 2006 06:22 PM
by Franz Verga Go to last post
1 76
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
Haw to Randomized available data by Adda
I have 10 columns of data. I wanted to randomized each column so that I will get a new combination of data. Its like permutation but actually applying it to...
April 10th, 2005 09:57 PM
by Ragdyer Go to last post
2 73
Interpolating Yield Curve by [email protected]
Hi, I would like to ask you whether you know an excel addin for interpolation a missing maturity in the yields? For example I have the 5 and 7 years and would...
January 11th, 2008 12:52 PM
by [email protected] Go to last post
3 133
HELP! countif by addicted
I'm trying to do a bit of a survey analysis. Anyways in counting responses this is what i need. I need to run the COUNTIF function for a particular column,...
May 22nd, 2006 01:26 PM
by addicted Go to last post
3 66
Formula Needed to Omit Characters by addie
Is there a formula that would recognize and omit specific characters within a field? Example: Data Field has the following 9 characters "R0502AA01". Only...
February 17th, 2006 05:55 PM
by SteveG Go to last post
6 142
Altering VLookup Formula by addie
How would I alter a v-lookup formula to recognize specific characters within a field? Example: Data Field has the following 9 characters "R0502AA01”. Can...
February 16th, 2006 02:04 AM
by Kevin Vaughn Go to last post
1 135
Summing Up Data Based on Codes by addie
I have a spreadsheet with several rows of data. Each row's data corresponds to a code that appears in the 1st field of the...
February 18th, 2006 12:09 AM
by addie Go to last post
2 89
Summation Formula Needed by addie
I have a spreadsheet with several rows of data. Each row's data corresponds to a code that appears in the 1st field of the...
February 18th, 2006 09:12 AM
by Aladin Akyurek Go to last post
6 72
Is it possible to have a 'query'/filter from a master worksheet t. by addie
I have a master sheet with more than 500 records which I would like to sort into groups. For each group I have to define a report. Therefore I am thinking to...
September 23rd, 2004 10:53 AM
by Arvi Laanemets Go to last post
1 243
adding a search box to a spreadsheet by Adding a search box to a spreadsheet
I have a workbook with 92 tabs containing data and text. i would like to add a search box to my index tab. This search box would allow a user to type in what...
December 1st, 2008 12:19 AM
by Gord Dibben Go to last post
1 51
Post New Thread


Display Options
Showing threads 1241 to 1260 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 11: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.