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
Sum with 3 conditions by diepvic
Hi, I have a table as below YTD YTD YTD Name Jan Feb Mar Apr May A 23 34 35 2 3 B ...
April 12th, 2010 05:16 AM
by diepvic Go to last post
9 151
Find 2 highest point to form resistance line by Elton Law[_2_]
Dear expert, Have left a post for finding 2 lowest point for form a support line. Now, would like to find 2 highest point to form a resistance line. Data is...
April 12th, 2010 03:37 AM
by Elton Law[_2_] Go to last post
4 247
Adding dates in columns by Roy
Using 2003, I am entering dates and trying to utilize a formula to calculate the number of cells that fall before a certain date. "Today()-300", calculates...
April 12th, 2010 03:25 AM
by ozgrid.com Go to last post
2 224
April 12th, 2010 03:23 AM
by Rick Rothstein[_2_] Go to last post
1 114
Find 2 lowest point to form a trendline by Elton Law[_2_]
Dear expert, Cell AH67:AH77 contain a series of data. Actaully, they are the results from an array of formula. Sometimes, it has 12 data. Sometimes, the data...
April 11th, 2010 03:54 PM
by Elton Law[_2_] Go to last post
0 141
date Concatenation by gb_S49
Hi, I am trying to date Concatenate 2 cells. One contains text the other date. How can I get the date to display as a date? =T6&" "&U6 returns ESTIMATE 40066
April 11th, 2010 02:54 PM
by Russell Dawson[_2_] Go to last post
6 200
Pivot table field list missing by Dianeg
I'm using 2007 and have created several pivot tables from this particular database but now, suddenly when I create a pivot table from scratch, the field list...
April 11th, 2010 12:13 PM
by Dianeg Go to last post
5 224
Freeze Column by ManhattanRebel
Other than the first column, is there a way to freeze other columns in my excel spread sheet?
April 11th, 2010 12:01 PM
by Roger Govier[_8_] Go to last post
7 234
Delete 3 end row by climate
Hi I want to delete three end row of any sheet. any sheet has different row number. Thank's for any help. your's
April 11th, 2010 11:09 AM
by Jacob Skaria Go to last post
6 112
Unprotect problem by DJohnM
How do I unprotect a worksheet in Excel 2007 when "unprotect sheet" is greyed out? (I have matching problem with protecting.)
April 11th, 2010 09:42 AM
by DJohnM Go to last post
2 124
LOOKUP across a whole table and not just first row or column by Eric_G
I am attempting to look up a particular value in a table and then identify the number in the first column of that table which corresponds to that row. For...
April 11th, 2010 07:17 AM
by Fakhrul Islam Go to last post
5 605
Customize accounting format by Rhett
I've been banging my head on my desk for two days over this problem! I want to customize the accounting format to show 0 as: $ 0.00 (with a $ to...
April 11th, 2010 03:55 AM
by ozgrid.com Go to last post
3 151
separate text and number by raju
dear sir in Cell A1 is "rajulu1234". i want in cell B1 "rajulu" & cell C1 "1234". please help me. thanks advance. raju
April 11th, 2010 03:52 AM
by ozgrid.com Go to last post
4 102
Summing based on dates by Mike
I go running and have a mileage log. I have a list of non-continuous dates in column A (i.e. I don't run every day), and mileage figures in column B. On a...
April 11th, 2010 02:46 AM
by T. Valko Go to last post
3 102
Countif using cell refences by Gnealeuk
i would like to add a formula into my spreadsheet that counts if a date in a previous cell appears, but the date is constantly being changed so therefore i...
April 11th, 2010 02:26 AM
by Fred Smith[_4_] Go to last post
4 99
Summing based on dates by ajnmxx
I go running and have a mileage log. I have a list of non-continuous dates in column A (i.e. I don't run every day), and mileage figures in column B. On a...
April 11th, 2010 02:08 AM
by JLatham Go to last post
2 91
Searching based on text by EJ Hill
I am building an Excel to recall stats for TV sports. There are three workbooks, Home, Away and League. The league sheet has all of last season's stats. In...
April 11th, 2010 01:49 AM
by Dave Peterson Go to last post
7 131
Macro - onAction arguments by version83[_2_]
Hello. I have this code: Private Sub Workbook_SheetBeforeRightClick(ByVal Sh As Object, ByVal Target As Range, Cancel As...
April 10th, 2010 09:59 PM
by Dave Peterson Go to last post
2 98
Excel 2003 formula by Ginger
I'm trying to make a formula for a list to check and strike out another on 3 sheets. Only 2 are using the info, sheet 3 has various colums to check. Sheet...
April 10th, 2010 08:06 PM
by Don Guillett[_2_] Go to last post
6 118
Running total based upon current date by ucastores
I have cells with dollar values from formulas and i am trying to place the total of all those values in another cell based upon the current date backwards. ...
April 10th, 2010 04:48 PM
by Don Guillett[_2_] Go to last post
5 95
Post New Thread


Display Options
Showing threads 1381 to 1400 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 03:30 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.