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
edate missing - still stumped by Den
Thanks to the two helpful responses on how to get the EDATE function. I do remember vaguely that that is where I had gotten it from before. BUT NOW, how do...
August 3rd, 2008 08:30 PM
by Den Go to last post
3 91
find and add vaules by MLT
Is this possible? Sheet 1 Column A = list of part numbers on each purchase order ( a part number will show up many times) Column H = In stock ready to...
August 3rd, 2008 07:14 PM
by T. Valko Go to last post
1 93
Conditional Formatting in XL2007 by Steve Haack
I have a table of numbers and I want to put a conditional formatting rule on each column to highlight the lowest number in the column (there is a built in...
August 3rd, 2008 05:27 PM
by T. Valko Go to last post
3 196
edate missing by Den
I have reloaded Excel 2003, but it does not contain several of the functions (eg EDATE) that I have used in previously saved worksheets. I believe that...
August 3rd, 2008 04:38 PM
by Mike H Go to last post
4 100
Lock after entering by bgkgmg
Cell B2 has the formula SUM(A1,A3). After entering data in A1 and A3 the sum appears in B2. I would like to lock only B2 after data entry so it never...
August 3rd, 2008 03:41 PM
by Gary''s Student Go to last post
1 145
Subject: how to convert 112" to 9'4" with a formula in Excel by Mike H
Try =INT(A1/12)&"'"&"-"&MOD(A1,12)&"""" Remeber to put the question in the body of your message because some of us can't answer if you don't Mike
August 3rd, 2008 03:22 PM
by ryguy7272 Go to last post
2 137
How do I append 20 worksheets in single sheet. by Rahul
Dear Team, I am having 20 worksheets which contains my daily reports. I need to all these worksheets into one singlw worksheet. Means append one by one. If...
August 3rd, 2008 03:08 PM
by ryguy7272 Go to last post
2 101
Can a page number be displayed in a cell? by jdwyer
I am trying to lookup a value in a different sheet, and insead of having excel return specific values within that sheet, I would like for it to return the...
August 3rd, 2008 02:55 PM
by ryguy7272 Go to last post
1 102
filter in a filter by Erik
Is there any way to run more than one filter from the drop down menu? I have a large pivot table and am trying to create a filter, or set of filters to...
August 3rd, 2008 02:48 PM
by ryguy7272 Go to last post
1 64
Using the if function in a formula, by Nick
Im trying to create an IF forumla to tell excel to go to a different sheet in my workbook if a cell value = 1. How would I do this??
August 3rd, 2008 12:24 PM
by Mike H Go to last post
1 80
how do i allign worksheet of excel to left. by shahrukh
i am having a problem with worksheet, that is it is starting from right side not left side although my default language is English.
August 3rd, 2008 11:43 AM
by Roger Govier[_3_] Go to last post
2 85
SUM COUNTIF problem by AD Carvajal
In the following spreadsheet, I need to count the number of times "y" appears in the Guest column when B appears in the Site column. Is there any way to do...
August 3rd, 2008 06:23 AM
by T. Valko Go to last post
1 123
SumProduct CountIF issue by JimG
I am trying to count the number of times the value "F" appears in column G, if the value "HCSO" appears on the same row in column J. And I need it to...
August 3rd, 2008 06:20 AM
by T. Valko Go to last post
5 113
Pivot Table with source spread across multiple worksheets by Joe Mac
All... I've got a very large data set carrying details across several worksheets... Ideally, I'd like to be able to perform a single Pivot Table looking at...
August 3rd, 2008 05:39 AM
by ryguy7272 Go to last post
1 93
Vacation Tracking by NewAccessUser
I have 4 different groups that accrue vacation at various rates. I have set up a table with each of these groups in one worksheet. In a separate worksheet I...
August 3rd, 2008 05:21 AM
by ryguy7272 Go to last post
1 64
How do I use the SumIF function with a criteria of a cell color? by Infernoo1
Hi, I am trying to use the SumIF function and use a criteria based on the color of the cells. I see I can sort and filter based on cell color, but cannot...
August 3rd, 2008 05:03 AM
by ryguy7272 Go to last post
3 119
Chart and date data by Xaraam
Hey!! I’ve been having some troubles with Excel 2003 (SP2) chart. I’ve to do a chart which the x axis is date type data and in which the same date has...
August 3rd, 2008 01:14 AM
by Xaraam Go to last post
4 91
Copying and updating formulas by dimitry
I have a workbook with mutiple sheets, each corresponding to a date. I use a formula which is the actual stock, based on the remainig of the previous. I...
August 3rd, 2008 01:07 AM
by Southern Kiwi Go to last post
1 77
Copying and updating formulas by dimitry
I have a workbook with mutiple sheets, each corresponding to a date. I use a formula which is the actual stock, based on the remainig of the previous. I...
August 3rd, 2008 12:28 AM
by Gord Dibben Go to last post
2 106
Copying and adjusting formulas by dimitry
I have a workbook made of a lot of consecutive sheets( each one a date). I use a formula meaning my actual stock is the remaining o the previous. I am...
August 3rd, 2008 12:27 AM
by Gord Dibben Go to last post
1 76
Post New Thread


Display Options
Showing threads 22101 to 22120 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 05:26 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.