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
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
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
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
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
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
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
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
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 11:13 PM
by Bob Phillips Go to last post
1 179
"Conditional" summing by Aladin Akyurek
In B2 on the destination sheet enter & copy down: =SUMIF(Sheet1!A:A,A2,Sheet1!B:B) Replace Sheet1 with the name of your source sheet. Gilbert De Ceulaer...
January 16th, 2005 08:46 PM
by Aladin Akyurek Go to last post
0 135
Formula help by DEEKABEE
I want to sum a cell that contains a formula with another cell that contains a formula. How do I write a formula that will show the rersult?
January 16th, 2005 05:01 PM
by brupp24_6 Go to last post
3 144
Need formula for sheet & cell reference by MPH
Help Have a list of sheet names and want to create a formula to use sheet name as a reference in a formula. Have tried "Indirect" but haven't succeeded with...
January 16th, 2005 04:39 PM
by MPH Go to last post
0 159
How To Suppres #N/A Values by John
I've finally worked out the formula to work, which is below =IF(ISNA(MATCH(A2,StaffNo,0)),"Crew",INDEX(StaffGrade,MATCH(A2,StaffNo,0)))" However I am now...
January 16th, 2005 04:25 PM
by Bob Phillips Go to last post
2 155
Several Dates -Verify by zeek
Greetings, I have 6 cells A1 - A6 with dates. Approximately 23000 Rows. They should be the same, however, fat-fingers are involved making inputs. What can...
January 16th, 2005 02:31 PM
by Ola Go to last post
4 169
Autosum ignores cell values by D
I have inherited a complex spreadsheet and have encountered the following problem: I am trying to add up a row and although the formula is correct, the...
January 16th, 2005 01:59 PM
by D Go to last post
4 138
Edit Hyperlinks by yazz22
I have an excel sheet with around 2000 hyperlinks pointing to files on our company's internal server. The location of the files has to be changed (new network...
January 15th, 2005 01:40 PM
by Dave Peterson Go to last post
1 119
#VALUE ! errorr for links to other workbook by Janez Banez
In one cell of my first workbook I have a link to the cells of the other workbook. If the second workbook is open, then the link formula...
January 15th, 2005 12:42 PM
by Arvi Laanemets Go to last post
1 351
Help adding text values by Texas-DC_271
I have a row of cells that I need to add. The row of cells do not contain a number but rather a text value. I have created a table linking my text values to...
January 15th, 2005 09:29 AM
by Aladin Akyurek Go to last post
5 539
countif by Becky
hi I need help. In column A I have male=1, female=2. In column E I have less than 5 yrs=1, two-5yrs=2 and over 5 yrs=3. How do I find out how many males...
January 15th, 2005 06:51 AM
by Biff Go to last post
1 126
How do I display the h:mm minutes in hundreds? by dpackwood
My company uses a time clock that uses hundredths of an hour rather than minutes. Is there a way to display the h:mm in hundreths rather than minutes without...
January 15th, 2005 04:54 AM
by Peo Sjoblom Go to last post
1 137
can i make a formula to search keywords in a excel workbook? by gorillayam
i would like to have one spot in the workbook where you can plug in a word and be directed to the certain spot. Similar to a word search through Ctrl + f, I...
January 15th, 2005 03:25 AM
by gorillayam Go to last post
0 309
Post New Thread


Display Options
Showing threads 77781 to 77800 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 01:22 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.