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 : New Users Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Conditional Formating by word(s) by Michaelcip
Hello, I have 2003, I'm trying to color cells that have specific words w/in the cell. I want to count words like "*broke*" and "broken*" as the same to get...
May 27th, 2010 08:53 PM
by Michaelcip Go to last post
2 344
How to insert static time using a laptop? by D Pickens
New to this. Sorry if very simple question. I'm using a laptop and the suggested method of inserting static date and time of hitting CNTL+ doesn't work. ...
May 26th, 2010 01:48 AM
by Stan Brown Go to last post
4 412
New To Formulas - Help please by kirstikate
This is probably very easy, but im having trouble - I want to find a formula that does the following IF H49 + G49 = F49 and F49=I49 then True If it...
May 25th, 2010 09:05 PM
by Brad Go to last post
6 243
Conditional Formatting by John Calder
Hi I run Excel 2K Conditional Formatting in Excel 2K only allows three conditions to be applied. I need 8 conditions. What I have is 8 check boxes that...
May 25th, 2010 02:07 AM
by John Calder Go to last post
8 326
May 25th, 2010 01:08 AM
by Bernard Liengme Go to last post
1 308
How do I calculate monthly gains/losses in excel by ragingriver30
For a family budget how would I calculate monthly gains/losses in Excel?
May 23rd, 2010 01:51 PM
by John Go to last post
2 566
Excel format conversion by Aaron H
Hi guys, is there a way to convert the following 123456789 to 123-456-789 or abcdefghi to abc-def-ghi I need to convert a long list of serial numbers so I can...
May 22nd, 2010 10:32 PM
by Rick Rothstein[_2_] Go to last post
9 275
AND - OR by RST Engineering
Is it just me, or are the AND and OR functions reversed logically? Is there a tutorial somewhere on how to use them? The help files in Excel are their usual...
May 22nd, 2010 01:44 AM
by John Go to last post
5 373
Formula returned in vlookup function by 87vette
I've used vlookup for a while now in the office 2003. Just converted to office 2007. Now when I do a vlookup I get the formula displayed in my current cell...
May 21st, 2010 06:34 PM
by 87vette Go to last post
2 259
I would like to convert my dollar totals into a bar chart format by shirleyweston
I am attempting this for the first time and would appreciate help. Thank you.
May 21st, 2010 05:15 PM
by trip_to_tokyo[_3_] Go to last post
1 280
Continued Headers on successive pages in an Excel document by moon
Hi, I am using Excel 2007. Headers on my first page (in Columns A3, B3, C3, and D3) are as follows: Date Test 1 Test 2 Daily Average I would like...
May 20th, 2010 11:52 PM
by moon Go to last post
3 295
Reminder - Microsoft Responds to the Evolution of Community by [email protected]
Microsoft Office Evolves Community as Part of Office 2010 Launch: As you know, this is a big year for Microsoft as we are launching the latest version of...
May 20th, 2010 04:13 PM
by [email protected] Go to last post
0 271
formula to convert 15 minute to hourly data by Luke M[_4_]
This formula should work: =AVERAGE(OFFSET($B$2,(ROW(A1)-1)*3,,4)) this averages range B2:B5 copying down will automatically change it...
May 20th, 2010 04:12 PM
by Luke M[_4_] Go to last post
0 249
Calculation by KTC53
In one colum I have different years eg. 2009, 1979, etc.. In the next column I have 2010. What I'm trying to do is subtract from each colum to show how...
May 20th, 2010 01:13 AM
by ozgrid.com Go to last post
2 301
formula to convert 15 minute to hourly data by Emily
I need a formula to convert 15 minute timestep data to hourly average (an average of the four 15 minute data points for the hour). My spreadsheet looks like...
May 20th, 2010 12:18 AM
by penny Go to last post
4 585
spreadsheet switches to bold involuntarily messing up figures by lovely lavender lady
This is Microsoft Office 2003. I'm typing out end-of-year audit for accountant. sometimes when I type in a number in the column,it changes to bold...
May 19th, 2010 10:20 PM
by tim m Go to last post
1 286
Sorting by surname when first name and surname are in the same cel by Louise
I have both first name and surname in one cell, ie. Mary Byrne and want to sort my list of names by surname first. Is it possible to divide the cells into...
May 19th, 2010 12:36 PM
by Louise Go to last post
2 243
Find and Replace by bio
Could you please elaborate what is the function of Control Find and Replace. Especially when using it to replace a formula to a new coloum
May 19th, 2010 04:46 AM
by ozgrid.com Go to last post
1 253
create text effects in excel by panda
MS Word allows you to go to FONT, TEST EFFECTS and make the text "blink" on and off. Can you do the same in MS Excel?
May 19th, 2010 12:17 AM
by Gord Dibben Go to last post
1 215
Pivot tables by gls858
I have a pivot table. The columns are month and rows are sales people. I want to display the grand total for the current month from the pivot table in another...
May 18th, 2010 09:43 PM
by gls858 Go to last post
2 202
Post New Thread


Display Options
Showing threads 41 to 60 of 13737
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 04:57 PM.


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