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
tabs in excel flagged out in webpage NOT by Hansn
When i flag out tabssheets in excel and i make a webpage of the sheet the tabsheets are visible. I don't want them to see. When i choose a subkect on the...
July 11th, 2008 01:43 PM
by Hansn Go to last post
0 57
ideas needed, pls help.. by angel
Suppose I have a spreadsheet with the following data Column A B C D Country Company ...
July 11th, 2008 12:22 PM
by sajay[_2_] Go to last post
2 86
Date Correction by JPS
I have a spreadsheet with 1000+ rows and I need to correct a date column, This column should contain the last day of the month, but often does not. I am in...
July 11th, 2008 11:34 AM
by JPS Go to last post
4 50
how to use my Excel 2003 DTF commands by Ravi Manian
I have recently switched to Office2007 , but find that the icon "Data Transfer from AS/400" is no longer available in Excel. I have hundreds of DTF commands...
July 11th, 2008 09:02 AM
by David Biddulph Go to last post
1 97
Password in Visual basic editor by Tia[_3_]
Hi I have a workbook for time sheet and i have used the following code so i can be able to have the first sheet always displayed and whenever you click on the...
July 11th, 2008 08:40 AM
by Tia[_3_] Go to last post
0 72
Hide a sheet with a variable name by Scott
G'Day I am trying to hide a sheet(s) based on a cell value. I have found an old post thats uses: Private Sub Worksheet_Change(ByVal Target As Range) Dim...
July 11th, 2008 08:21 AM
by Scott Go to last post
4 67
Data Validation lists update orginal cell with list update by [email protected]
Hello, I need some help. I am using a data validation list to help people populate the destination cell with the required value. The data validaton list is...
July 11th, 2008 07:56 AM
by [email protected] Go to last post
3 127
July 11th, 2008 07:14 AM
by Harlan Grove[_2_] Go to last post
2 91
Lookup function ~ weird is it possible? by Daniel Q.
I have a spreadsheet that has information listed downwards with the dates in column A and then locations in row...
July 11th, 2008 07:05 AM
by Max Go to last post
1 69
Excel time calculation by STS
Hello, would like some assistance with a time calculation. Need to calculate the total hours spent for a time from where I have a day and time in Europe as a...
July 11th, 2008 06:26 AM
by T. Valko Go to last post
3 70
Test for normality of data by Rob
I need to test a data set for normal distribution. How do I do this? Also, is there a way to create a graph that will display both the test data set and a...
July 11th, 2008 05:58 AM
by Harlan Grove[_2_] Go to last post
3 97
Two way lookup on a table from user input by Kim
I have a table that lists my different specs in column one. I want a formula that will read the spec that is keyed in by the user and then also read the...
July 11th, 2008 05:36 AM
by T. Valko Go to last post
1 67
Payroll lookup by Treasur2
This is a classic payroll thing. I two columns of names. Coloumn L has a list of all names on the payroll. Column D has a list of the same names, but...
July 11th, 2008 05:29 AM
by T. Valko Go to last post
1 69
Count the Y's in a filtered column that contains Y and N by TommyB
In Column A there could be a date. In Column B there could be another date. Column C has either Tom or Janet in it. Column D says if Column B is greater...
July 11th, 2008 02:43 AM
by Teethless mama Go to last post
1 69
using vlookup by Jack
while I have been a user of Excel for awhile, I have never really used to any of it potianl. Well now is the time to start using some more features of...
July 11th, 2008 02:15 AM
by Mark[_43_] Go to last post
4 77
web query data... missing something by got mike?
first part of the question: it seems to me that the web query works very well for one particular piece of info, but doesn't work well as a regular function...
July 11th, 2008 01:53 AM
by got mike? Go to last post
0 55
Searching Multiple rows using VLOOKUP with wildcard(*,?) lookup va by Tommy
Given data_array: abc 1000 abx 2000 bcd 3000 def 4000 bhg 3200 and lookup_value is b??, how can we obtain result with
July 11th, 2008 01:44 AM
by Tommy Go to last post
3 106
Saving Trace Arrows by JimmyG
Is there a way of saving the worksheet with the trace precedents arrows still visible?
July 11th, 2008 01:05 AM
by JimmyG Go to last post
0 61
If calculations by ClassyCleaning
I need to calculate sales tax from two states with different sales taxes. I want to designate one cell with a T or N and then have my invoice calculate the...
July 11th, 2008 12:23 AM
by Pete_UK Go to last post
3 54
XIRR FUNCTION by Lynndale
USING THE FINANCIAL FUNCTION i AM TRYING TO CALCULATE THE ANNUAL RATE OF RETURN FOR THE LAST QUARTER FOR A FUND. FILLING IN THE ARGUMENTS FOR THE FUNCTION i...
July 11th, 2008 12:03 AM
by Lynndale Go to last post
6 83
Post New Thread


Display Options
Showing threads 23041 to 23060 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:00 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.