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
Extract dd and mm from text and put that plus current yy in another by robzrob
I've got a workbook which comes from someone else and it's got a cell in it from which I want to get the above. The format of the cell varies. It could be...
February 17th, 2010 11:14 PM
by Fred Smith[_4_] Go to last post
1 76
how do I create a formula to add up time on a time sheet by JR Crawdad
I am creating a weekly time card for our office. I have columns for start and stop times and have successfully found the formula to get each time segment to...
February 17th, 2010 11:10 PM
by Fred Smith[_4_] Go to last post
3 155
SUMIF based on cell shading by IlliniEric
Is it possible to write a SUMIF formula based on cell shading? If so, how? I want to add up cells based on the shading of the cell. Thanks.
February 17th, 2010 11:03 PM
by Gord Dibben Go to last post
1 161
sorting multiple columns by arbe
I have multiple addresses on a work sheet. I need to have all the same zip code # together. How do I sort them by zip code so right name and address ends up...
February 17th, 2010 10:36 PM
by Gord Dibben Go to last post
2 93
February 17th, 2010 10:32 PM
by Fred Smith[_4_] Go to last post
1 110
Ignore "-" by msnyc07
I have a script that generates acronyms from company names. It was set it up to ignore of, and, the, etc. (I didn't code it just spec'd it) If Not...
February 17th, 2010 10:30 PM
by msnyc07 Go to last post
6 94
countif object by ginble07
Is there a way to use a count function for objects? I have a series of textboxes in rows and columns that will be moved around freely. I need to be able to...
February 17th, 2010 10:26 PM
by ginble07 Go to last post
0 94
New free mail add-in for Excel/Outlook 2007-2010 by Ron de Bruin
Posted to more then one newsgroup FYI Today I upload a new version of my Excel Mail add-in for Outlook. If you want to test it you can find it...
February 17th, 2010 09:29 PM
by Ron de Bruin Go to last post
0 83
why do print range erase in Excel when import data from access by MaryD
I have a workbook set up in Excel 2007 that serves as a template for data dumps from Access 2007. In the Excel template, I have set all the print titles and...
February 17th, 2010 09:23 PM
by Duke Carey Go to last post
1 117
HELP!! Formula with different conditions by Teri
Hi there. I'm hoping someone can help me. I'm pulling my hair out trying to figure out how I can take a certain number of hours (for OT banking purposes)...
February 17th, 2010 09:04 PM
by T. Valko Go to last post
5 121
Conditional Formatting for entire row by HeatherJ
I know how to use conditional formatting for a cell, but is there a way to do conditional formatting for an entire row? Example: if cell A18 contains the...
February 17th, 2010 09:03 PM
by T. Valko Go to last post
5 156
highlighting different line in a cell by krv
How do I highlight different lines within the same cell two different colors?
February 17th, 2010 09:00 PM
by Gord Dibben Go to last post
2 99
for loop with if statement by Steve
Morning all. I'm looking to set up an automatic password sheet protection tool and there are only specific elements that I need protected on the worksheets in...
February 17th, 2010 08:56 PM
by Steve Go to last post
1 75
can someone tell me how to deselect "select all" in Excel? by scott
i am trying to deselect "select all" for some rows in Excel. Anyone know where i find this?
February 17th, 2010 08:35 PM
by Gord Dibben Go to last post
3 78
Add total items in from another worksheet? by tb
I need help with a formula for my inventory master list. I have several worksheets, the one I need a total from is the Inventory in Worksheet. Everytime we...
February 17th, 2010 08:29 PM
by tb Go to last post
0 87
ANOVA with 3 factors by Confused Slug
Is it possible to using Excel to perform an ANOVA with 3 (or more) factors? Thanks
February 17th, 2010 08:26 PM
by Mike Middleton Go to last post
1 72
Count distinct days from two groups of days by Colin
Hello, Can anybody help please? I have used Networkdays() to count the working days between two dates. And have had to do this twice. So now have two counts...
February 17th, 2010 08:14 PM
by Colin Go to last post
4 123
CUBEMEMBER by Shairal
Does anyone know if you can use a wildcard with the cubemember function, and if so, how? I am trying to pick up all product IDs that start with KRLMJ129*...
February 17th, 2010 07:33 PM
by Shairal Go to last post
0 77
Creating a dynamic IF statement by Robert Robinson
I have data in two sheets. I want to create an IF statement in the second sheet that has the ability to scan the first sheet for a value. If it finds a match...
February 17th, 2010 06:09 PM
by Luke M Go to last post
2 91
Conditional formatting offset reference by IanC
I have a spreadsheet with a block of 10 rows by 8 columns with conditional formatting with absolute references to row 6. I need to change these to reference...
February 17th, 2010 05:58 PM
by T. Valko Go to last post
3 101
Post New Thread


Display Options
Showing threads 2861 to 2880 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 04:20 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.