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
Check if date is between two dates, then sum only those rows by streetcar
I have tab1 with begin date in column A, end date in column B. Basically they are weeks, Mon-Sun (e.g. 01/04/2010 and 01/10/2010 in A/B resp.). Tab2 has data...
February 16th, 2010 01:19 PM
by Max Go to last post
2 96
how do i calculate a % by blue
i need to calculate a % i need to give a percentage to a mark of 67/70 and make it 30% of the total i need help
February 16th, 2010 10:27 AM
by Joe User[_2_] Go to last post
2 76
Sum Days into Weeks by Toll Jenny
I would like to save myself a whole lot of work please... I have two spreadsheets, one has all the days of the year across the columns, and the next has all...
February 16th, 2010 05:41 AM
by T. Valko Go to last post
1 85
How do I separate a name into 2 columns from Surname, christian n. by Phil B[_3_]
I have a list of names in the format "surname, christian name" and want to separate the two names so I have the surname and christian names in different...
February 16th, 2010 03:56 AM
by Teethless mama Go to last post
1 78
Date function question by Jim Peterson
Hi everyone and thanks for any help you might have. It seems like one of you always has the answer I need! I'm running XP Pro and Office 2007 Pro. In my...
February 16th, 2010 03:06 AM
by T. Valko Go to last post
5 142
Countif query by Keith[_22_]
Take 2 - I don't think my first request got sent. I am attempting to count the number of cells in AB2:AB26 that have a number less thn zero. I have...
February 16th, 2010 02:43 AM
by Ashish Mathur[_2_] Go to last post
2 108
cell with formula is not automatically updating - Excel Office 200 by Robert C[_2_]
I have an excel file, one column has 200 cells with same formula. I have been using it for a year, data automatically updates. However, recently, after the...
February 16th, 2010 02:41 AM
by Ashish Mathur[_2_] Go to last post
2 168
Complex conditions using SUMIF by Booweezie
Hi Smart Folk: I need to analyze employee date and am having problems. Here's my data: Employee Number Status ...
February 16th, 2010 01:14 AM
by Dana DeLouis[_3_] Go to last post
8 208
*****PLEASE******* FIX AUTOMATIC CALCULATION by msnyc07
I won't bother ranting again since I'll be accused of not knowing what I am doing. 1) Set my sheet in Formulas Menu to Manual Calculation (which should...
February 16th, 2010 12:40 AM
by Charles Williams Go to last post
1 113
Sorting with sumif function by ram
HI, I have a worksheet with 5 columns of data and 100 rows. in one of the columns I have a sumif formula. When I try to sort the data the cell reference in...
February 15th, 2010 11:53 PM
by Eva Go to last post
1 75
Date formula by MAX
Hello I need a formula that add 13 days to a given date. Example of this is that I have a date in cell F10 (01/02/10) and I want cell F11 to appear as...
February 15th, 2010 11:19 PM
by Eva Go to last post
2 80
Macro - filter - show all data by Eva
Hi I have the spreadsheet with the macro that does number of things, but I am not using it - only somebody else. The problem is that this person uses it then...
February 15th, 2010 11:07 PM
by Eva Go to last post
2 75
Excel Functions Problem by Confused
What function do you use to get the value of one cell to be 50 for every 1000 value of another cell?
February 15th, 2010 10:55 PM
by Billy Liddel Go to last post
3 81
Help Please by Spikey
Every Saturday I record the readings from my Electricity & Gas meters in a spreadsheet which I use to calculate that weeks usage. Week 1 reading for Gas goes...
February 15th, 2010 10:07 PM
by Don Guillett[_2_] Go to last post
6 63
Finding Duplicate Entries by Elliot
Hi, I need to find duplicate data from the data table below. There are 2 columns : one consists of students and the other is an individual class number. The...
February 15th, 2010 09:45 PM
by Elliot Go to last post
3 97
Are PercentRank and Rankperc the same function? by renehug
Hello! We are using the rankperc function of the analysis toolpak (Application.Run "ATPVBAEN.XLA!Rankperc"...). Just today I read that a lot of the ATP...
February 15th, 2010 09:18 PM
by Mike Middleton Go to last post
1 71
Search If on text string by bob
B2 through B6 contain a string consisting of last names: B2 - Jamison, Gooden, Blatche, Foye, Miller B3 - Butler, Jamison, Blatche, Foye, Miller B4 - Butler,...
February 15th, 2010 07:49 PM
by T. Valko Go to last post
3 62
Matching names and inserting spaces by ILunacy
Thank You! This was very helpful! I have a new question that goes along with this. Is there a way to expand on the cell selection? Besides the names in...
February 15th, 2010 07:15 PM
by ILunacy Go to last post
0 64
Arrey Formula by Eva
Hi Does arrey formula saves file size or it makes even bigger? Ewa -- Greatly appreciated Eva
February 15th, 2010 06:59 PM
by Eva Go to last post
2 58
Check Boxes by CAL
I have a listing of names with several columns with checkboxes (using control toolbox). I linked the check box to the cell using a range (F:F) and then...
February 15th, 2010 06:54 PM
by Luke M Go to last post
1 80
Post New Thread


Display Options
Showing threads 2921 to 2940 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:35 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.