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
Conditional formatting by Versateo
When using the conditional formatting dialog box, if you want more than one condition to apply, you click the ADD button. However, you can only do this twice,...
January 16th, 2005 10:13 PM
by Bob Phillips Go to last post
1 104
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 10:19 PM
by Max Go to last post
2 101
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 10:36 PM
by Ron Rosenfeld Go to last post
4 124
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 05:05 AM
by Norman Jones Go to last post
3 123
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 06:25 AM
by Ausrobbo Go to last post
0 168
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 09:32 AM
by Bob Phillips Go to last post
2 87
Multiple VLOOKUP by Rody
How do I get to run a multiple VLOOKUP? Thanks
January 17th, 2005 11:05 AM
by Bob Phillips Go to last post
2 114
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 11:11 AM
by Bob Phillips Go to last post
46 975
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 02:26 PM
by Hans Näslund Go to last post
0 120
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 05:07 PM
by plato Go to last post
0 111
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 05:33 PM
by Max Go to last post
1 112
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 06:49 PM
by jmatchus Go to last post
0 73
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 07:19 PM
by Gord Dibben Go to last post
2 71
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 07:54 PM
by Bob Phillips Go to last post
1 113
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 08:29 PM
by LanceB Go to last post
1 85
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 08:35 PM
by LanceB Go to last post
1 59
formula to calculate a time sheet by tintin103
just trying to calculate my weekly time sheet. thanks
January 17th, 2005 09:20 PM
by Bob Phillips Go to last post
1 127
formula to calculate a time sheet by tintin103
just trying to calculate my weekly time sheet. thanks
January 17th, 2005 09:45 PM
by Gord Dibben Go to last post
1 129
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 12:03 AM
by Ralph Howarth Go to last post
0 128
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 12:21 AM
by Ola Go to last post
1 102
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 11:51 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright ©2004-2018 OfficeFrustration.
The comments are property of their posters.