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
CONVERT TIME FROM 4:30 TO 4.5 by keeb
I'm tring to convert a time ie. 4:30 to a interger ie. 4.5. can anyone help?
May 27th, 2010 10:21 PM
by Mike H Go to last post
2 285
VLookup by burtlake
Your situation sounds similar to mine. See the question entitled "Two Level Search" - about 7 "posts" below yours. I was able to use the advice prvided (by...
May 27th, 2010 10:20 PM
by burtlake Go to last post
0 263
Countif Formulas by jay
I have two worksheets. I want to feed data from one to the next to tally occurrences of key words in two columns according to month in another...
May 27th, 2010 10:12 PM
by jay Go to last post
2 320
VLookup by Jacob Skaria
Try the below formula in sheet1 say in (cell D1) and copy to the right to retrieve Fees Billed & Hrs Billed. Format the formula cell to display as...
May 27th, 2010 10:12 PM
by Jacob Skaria Go to last post
0 274
How do I get to add up only the values than 0? by Anri
How do I get to add up only the values than 0? Only count: =((Q8)*0.5)+(Q8) .... if larger than 0
May 27th, 2010 10:11 PM
by Jacob Skaria Go to last post
2 413
arquivo excel worksheet by gege
boa noite recebi o arquivo excel worksheet e nao consigo abrir, e quando tento abrir aparece esta mensagem: microsoft excel viewer cannot open files of...
May 27th, 2010 10:06 PM
by gege Go to last post
0 318
IF on a range of cells by Syed Zeeshan Haider[_2_]
Hello Everybody, I am working in Excel 2003 with two lists, dates and prices in columns A and B respectively. I am trying to use IF worksheet function to find...
May 27th, 2010 10:04 PM
by Ms-Exl-Learner Go to last post
2 246
How do I alphabetize the tabs on a spreadsheet with 25 tabs? by Anita
The only way I know is to drag and drop but it's time consuming. Is there an easier way?
May 27th, 2010 10:01 PM
by Anita Go to last post
0 280
Adding an additional forumula to my SUMPRODUCT formula by Mark D
Good afternoon everyone I am sure this is pretty simple but everything I am trying isn't working, Hoping someone can help I have the following formula...
May 27th, 2010 09:53 PM
by Jacob Skaria Go to last post
1 262
One step paste of XLS file name in one of its own cells by Mike H
Hi, Put this formula in a cell. It only works if the workbook has been saved =MID(CELL("filename",A1),1+FIND(" Is there a way to automatically paste the...
May 27th, 2010 09:51 PM
by Mike H Go to last post
0 272
How do I alphabetize the tabs on a spreadsheet with 25 tabs? by Mike H
Hi, Alt+F11 to open vb editor. Right click 'ThisWorkbook' and insert module and paste the code below in and run it Sub Sortem() For x = 1 To...
May 27th, 2010 09:50 PM
by Mike H Go to last post
0 276
create overtime spread sheet by peterbirss222
I wish to have a cumulative hours column and a date column. So the hours are scaled upwards and the column associated with a person and a date to show who did...
May 27th, 2010 09:50 PM
by peterbirss222 Go to last post
0 345
Macro to build table by Victoria612
I think I got it - can someone confirm this is accurate? Sub Macro() Dim lngRow As Long Dim intA As Integer, intB As Integer, intC As Integer, intD As...
May 27th, 2010 09:50 PM
by Dave Peterson Go to last post
1 190
Linking text cells between 2 worksheets by FSt1
hi try your formula like this..... =IF(sheet1!B6="","",sheet1!B6) this would not produce a zero on sheet 2 but would carry data to sheet 2 if data exist on...
May 27th, 2010 09:50 PM
by Malcolm Go to last post
1 240
Calculation for amt. Exceeding $106,800 for SS Income Limit by ryguy7272
I’m trying to think of an easy way to work with the $106,800 cap on SS Income and compare this to other types of taxes, such as FUTA Tax and Medicare Tax. ...
May 27th, 2010 09:50 PM
by Jacob Skaria Go to last post
1 211
Excel - Convert int value secs past midnight into time 53100=2:45 by Mike H
Hi, with your seconds in a1 =A1/(24*60*60) and format as time (hh:mm:ss) -- Mike
May 27th, 2010 09:49 PM
by Mike H Go to last post
0 298
Fill last row down for large selection? by msnyc07
Of found the answer, generously provided by Eduardo if anyone is interested for future reference: Select the cells in the column, starting in the row below...
May 27th, 2010 09:44 PM
by Jacob Skaria Go to last post
1 387
If statement linking data from one sheet to another by Mathew
Jacob: Thanks for the help, but it didn't work I get the #Ref error. "Jacob Skaria" wrote: Try =IF(I530,INDIRECT("'+Agency Reallocation data'!D" &...
May 27th, 2010 09:44 PM
by Jacob Skaria Go to last post
1 283
Truth Table by Victoria612
I stand corrected - is there a way to program a macro that can determine all 72 possible scenarios? "Victoria612" wrote: OK - I have 6 questions, all of...
May 27th, 2010 09:43 PM
by Victoria612 Go to last post
0 236
Find and Replace by vicktina
We are using a scanner to input a barcode number into "Find What" box in find and replace in excel. Is there a way to make it stay highlighted for the next...
May 27th, 2010 09:42 PM
by vicktina Go to last post
0 215
Post New Thread


Display Options
Showing threads 281 to 300 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:52 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.