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
subtotal function using criteria by dbroc
I'm trying to use the subtotal function to total figures in a list based on a technician's name. For example, use the subtotal function instead of the...
January 10th, 2010 02:46 AM
by Ashish Mathur[_2_] Go to last post
5 106
auto sum by Pat
I added a row under the coloumn I want to add. I used the auto sum key, and all it does is show the formula, not the actual totals. What am I doing wrong?
January 10th, 2010 02:42 AM
by Ashish Mathur[_2_] Go to last post
2 146
hyperlinking email addresses by CharlesZ
I have a list of email addresses that have hidden text before the first letter of the email address. I tried all the functionalities to get rid of this...
January 9th, 2010 10:54 PM
by Gord Dibben Go to last post
1 127
When copying dates, they change by 4 yrs & 1 day, why? by CAMiller
When copying & pasting dates in a few of my worksheets, they change to one day and four years backwards, ie: 07/15/1979 changes to 07/14/1975. Can anyone...
January 9th, 2010 10:30 PM
by J Cooper Go to last post
5 86
Array - conditionally sum the 1st occurence in non-contiguous rang by Christi
I'm trying to summarize the number of people who attended any class, by supervisor. Data for 3,000 employees is on one sheet and the summary on another. ...
January 9th, 2010 08:25 PM
by Herbert Seidenberg Go to last post
1 190
How to average values based on time period by Peters48
I have a table with several columns: two of which are labeled Date and Value. I want to extract the average from the Value column based on a date criteria. ...
January 9th, 2010 07:36 PM
by T. Valko Go to last post
6 115
How to return a range of values in a drop-down. by Joe
Is there a way to have Excel return a range of values in a drop down in one cell based on input from another cell. As an example: Cell A1 has the text "PVC...
January 9th, 2010 07:32 PM
by T. Valko Go to last post
7 179
January 9th, 2010 07:18 PM
by Otto Moehrbach[_2_] Go to last post
1 129
6 Day working week (friday holiday) by Dan Johns
Hieveryone, I am an excell novice trying to put together a project calculation sheet. I need to calculate total days between 2 dates excluding each and every...
January 9th, 2010 07:01 PM
by Roger Govier[_3_] Go to last post
2 170
formula for local time and GMT? by hsg
I would like to display time in LOCAL time as well as GMT. Whenever LOCAL time is entered in A1, B1 should automatically display GMT. Both cells to use format...
January 9th, 2010 06:53 PM
by Roger Govier[_3_] Go to last post
1 153
Fill Handle by Leeba
I need Excel 2007 to do the following: 23493-A 23493-B 23493-C I entered the alphabet as a new list. It works alone, but when I put a number and dash before...
January 9th, 2010 06:22 PM
by Teethless mama Go to last post
6 149
Can I increase the view of a drop down list beyond 8 in Excel? by dustinhess@jore
I created a drop down list from a group of more than 8 items (12 items). When the drop down list arrow is clicked, Excel shows the first eight than has the...
January 9th, 2010 06:09 PM
by T. Valko Go to last post
2 122
@which function to use when by Sandeep Lohchab
Sir, I have a row in excel with cells containing 88.23, 89.01, 72.39, 54.52 and I want to know which fuction/formula to use for making these as 88.25,...
January 9th, 2010 11:56 AM
by Roger Govier[_3_] Go to last post
5 110
Arranging words in a column in dictionary wise order by Zubair
Hi, I have a table of contact list in which person's employer name is entered. What i want is to use that employer name (from input column) and arrange...
January 9th, 2010 09:40 AM
by Ashish Mathur[_2_] Go to last post
4 119
VLookup with multiple conditions by mr tom
Hi, Happy New Year, all. I need to lookup based on both of two conditions being satisfied. We have a number of financial advisers in regional offices, and...
January 9th, 2010 08:58 AM
by anthony alvarez Go to last post
9 97
January 9th, 2010 08:54 AM
by Ashish Mathur[_2_] Go to last post
1 72
How To Protect Sheet For SHIV by trip_to_tokyo[_3_]
SHIV I cannot reply to your posting but this is what you need to do:- To lock all the cells in a Worksheet in EXCEL 2007 take the following action:- 1. Hit...
January 9th, 2010 06:39 AM
by trip_to_tokyo[_3_] Go to last post
0 119
Two types of Data Validation in a cell? by Lakeville
I want to ensure that the data in a cell is either a capitalized Y or a capitalized N. I understand how to do the data validation of a list with Y & N. And I...
January 9th, 2010 06:27 AM
by T. Valko Go to last post
8 106
Excel 2007: Vlookup - Results without #N/A by ocean mist[_2_]
in my results column, I have a series of #N/A where there is no result. Is there anyway to have that left blank unless there IS a value to return?
January 9th, 2010 02:37 AM
by T. Valko Go to last post
4 144
Vertical page breaks - one per column by Staceyglow
I have a spreadsheet that is 40 columns wide, and except for the 1st column (which will be repeated at the left), I want a page break after each column. Is...
January 9th, 2010 12:35 AM
by Gord Dibben Go to last post
1 126
Post New Thread


Display Options
Showing threads 4021 to 4040 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 02:21 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.