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
Adding times together by [email protected]
Hi I need to add times together, i.e. 6:30, 5:30, 5:00 etc to get and answer of 17 hours Can someone help me with the formula please. Thanks Yvonne
January 16th, 2005 11:19 PM
by Max Go to last post
2 169
hex to decimal convert by Nadia
Hi Is it possible to have a formula convert a string of hex values to decimal numbers? say put hex values, in column A1- A8 and as soon as you put in values in...
January 16th, 2005 11:36 PM
by Ron Rosenfeld Go to last post
4 201
VLOOKUP by Lori
I can't remember how to use VLookup! I have to worksheets with columns of common data I need to "merge" the two without duplicates. Can someone tell me how to...
January 17th, 2005 06:05 AM
by Norman Jones Go to last post
3 199
2003 update link when Source open by Ausrobbo
I have a similar problem. We have a procedure which opens a (multiple sheet) Excel workbook, then open a Word document with links to the workbook. We rename...
January 17th, 2005 07:25 AM
by Ausrobbo Go to last post
0 450
Lookup List to Index by SSR
Hello, I have a sheet with 2 columns as Below A B 1 Apples 1 2 Oranges 3 3 Bannanas 2 Cells in Column A have data...
January 17th, 2005 10:32 AM
by Bob Phillips Go to last post
2 198
Multiple VLOOKUP by Rody
How do I get to run a multiple VLOOKUP? Thanks
January 17th, 2005 12:05 PM
by Bob Phillips Go to last post
2 225
How to calculate days:Hours:Minutes: by Kurewe
Greetings, I am working on a spreadsheet that performs several calculations on the data that is provided in another spreadsheet. The basic function of my...
(Multi-page thread 1 2 3 ... Last Page)
January 17th, 2005 12:11 PM
by Bob Phillips Go to last post
46 2,585
Alternative window size? by Hans Näslund
I would like to save one of my worksbooks as a full-screeen window, without affecting other workbooks or the standard template. How do I do? Is it at all...
January 17th, 2005 03:26 PM
by Hans Näslund Go to last post
0 312
Pivot tables, external data sources and ODBC links by plato
arg... yeah man im pretty much in the same boat ... all i need to do is change the dsn system name :( did you have any luck? "makrug" wrote: I have a...
January 17th, 2005 06:07 PM
by plato Go to last post
0 374
self-building dropdown list by boris
would like to have a sheet where one of the columns has cells which are a self-building list. I understand the need to have any formula or validation copied...
January 17th, 2005 06:33 PM
by Max Go to last post
1 261
Hiding columns based on user/password by jmatchus
Is there a way to hide columns based on the password entered? I am trying to go from a Paradox table to Excel and in Paradox there was the capability to hide...
January 17th, 2005 07:49 PM
by jmatchus Go to last post
0 129
merge data from multiple columns to single column by triggerthehorse
I have a mailing list that has the street number (column A), street name (column B), and street suffix (column C) in separate columns on each row (1037 rows). ...
January 17th, 2005 08:19 PM
by Gord Dibben Go to last post
2 125
need help w/formula for calculating overtime hours by jv749297
i am trying to create a timesheet that calculates cells automatically when data is entered. I am entering time "in" and "out" two times (first half of day...
January 17th, 2005 08:54 PM
by Bob Phillips Go to last post
1 331
lookup misses the first entry in table by Spunky
If I insert a row with a number less than 074 first, the 074 does as I expect on my spreadsheet. However, if I have it as is below, any lookup to 074 returns...
January 17th, 2005 09:29 PM
by LanceB Go to last post
1 144
How do I SUMIF with two criteria in two different columns? by Tina Winter
Good afternoon everyone. I have a task management table in which three of the many columns indicate the week (Column "A") the work should be done, the person...
January 17th, 2005 09:35 PM
by LanceB Go to last post
1 119
formula to calculate a time sheet by tintin103
just trying to calculate my weekly time sheet. thanks
January 17th, 2005 10:20 PM
by Bob Phillips Go to last post
1 510
formula to calculate a time sheet by tintin103
just trying to calculate my weekly time sheet. thanks
January 17th, 2005 10:45 PM
by Gord Dibben Go to last post
1 417
Insert value of a cell as a filename by Ralph Howarth
Is there a way to insert the value of a cell as a filename for referencing a cell in another workbook? ex: =FileName!$Col&Row where FileName is a...
January 18th, 2005 01:03 AM
by Ralph Howarth Go to last post
0 315
Subtotal results in new column and then sorting subtotals by ArtM
1. Is there a way to do a subtotal and have the results appear in a new column and 2. Is there a way to then sort on those subtotals (high to low)?
January 18th, 2005 01:21 AM
by Ola Go to last post
1 163
Calculating interest on number of days in the period by Ron
What's the formula for calcuting the interest on a loan, based on the number of days in the period? I am using a couple of different "loan...
January 18th, 2005 01:59 AM
by Ron Go to last post
0 295
Post New Thread


Display Options
Showing threads 10001 to 10020 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 08:57 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.