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
Average days between dates by mckzach
Greetings all, I am working with two columns (ranges) of dates, although there are many blank rows interspersed in both ranges. I simply need to calculate...
May 22nd, 2009 02:46 PM
by Domenic[_2_] Go to last post
3 113
Answer an Outlook Express message box by ozhunter
I have some VBL code that copies a specific worksheet from a workbook then emails it. Is it possible to alter the code to answer an Outlook Express message...
May 22nd, 2009 02:35 PM
by Ron de Bruin Go to last post
1 105
How to count letter B based on data in other columns by Mero
Hello...I did ask the below question 3 days ago and I got answer from you. Now I need to add something to my below question In the below formula you gave me,...
May 22nd, 2009 02:24 PM
by Mero Go to last post
6 102
Macro auto fill formula by Erin
Having a quirky issue I've set up a macro that runs fine on my system but isn't working on a co-worker's system (and it had been working fine for a couple of...
May 22nd, 2009 01:04 PM
by Don Guillett Go to last post
4 97
External xls reference error by Fluke[_2_]
I've got this formula: =SUMPRODUCT(--('I:\IWS KPI\Sheet1'!$B$2:$B$10000="IWS"),--('I:\IWS KPI\Sheet1'!$C$2:$C$10000=Sheet2!B2),--('I:\IWS...
May 22nd, 2009 10:14 AM
by Fluke[_2_] Go to last post
1 101
Help in calculating tax % for Co2 emissions? by Riki
I'm trying to calculate degree of tax for car CO2 emissions. There are several conditions I need to take into account. 1. Fuel type (D=diesel, G=gasoline) -...
May 22nd, 2009 09:18 AM
by Riki Go to last post
3 121
Function isn't recalculating by Chris
Hi guys, I have a function running in my workbook and it won't recalculate automatically. I have an idea this is because it's being used 365 times on one...
May 22nd, 2009 09:06 AM
by Rick Rothstein[_2_] Go to last post
2 90
Lookup help needed by Guntars
For example I got this simple table: ___________one___two___three Name 1______X___________X_ Name 2______X_____X_______ Name 3____________X_______ Name...
May 22nd, 2009 07:08 AM
by Jacob Skaria Go to last post
1 85
Email code by ozhunter
I have the following VBA code that works, but I would like to avoid having to click the OE message box that asks if you want to send the email when you run...
May 22nd, 2009 06:04 AM
by Jacob Skaria Go to last post
1 125
Lookup help needed by Guntars
For example I got this simple table: ___________one___two___three Name 1______X___________X_ Name 2______X_____X_______ Name 3____________X_______ Name...
May 22nd, 2009 05:27 AM
by Teethless mama Go to last post
3 68
copy a protected worksheet by cat
We are trying to protect a boilerplate worksheet however, be able to copy/paste certain columns to a new sheet without someone having the ability to...
May 22nd, 2009 03:47 AM
by [email protected] Go to last post
3 98
Sumproducct question by DocBrown
Can anyone help with a sumproduct question? I would like to sum the values in range $N$16:$N$200 if the value in column E of the row is not a capital letter...
May 22nd, 2009 03:21 AM
by Teethless mama Go to last post
4 89
square root by Mitch Easterby
I was just wondering how to do root 2 + root 2 in the same equation?
May 22nd, 2009 03:00 AM
by Teethless mama Go to last post
6 75
Transfer a name from one cell to another but leave clear if clear? by Scoober
Hi, I am trying to find the formula that allows me to copy a name from one cell to another, but if the original cell is empty then the corresponding cell is...
May 22nd, 2009 02:55 AM
by Teethless mama Go to last post
3 74
Problems by Kay
Maybe I am not explaining properly what I need. This is what I need. I am doing a timesheet and have a cell with the start date (Month, day and Year) I am...
May 22nd, 2009 02:37 AM
by Kay Go to last post
2 81
Unknown error in function, and how to return value? by Chris
Hi all, I've been working on this sheet for a bit, and I'm stuck at this point, where I have a worksheet created like a calendar. My goal is to have a...
May 22nd, 2009 01:59 AM
by Chris Go to last post
3 79
populate duplicate data into a spreadsheet by Toni Marie
Is there a way to populate duplicate inventory data into a spreadsheet without typing it? For example... Qty 10 blouses @ 9.99 2 Sm, 4 Med, 4 Lg Is there a...
May 22nd, 2009 01:51 AM
by Joel Go to last post
2 105
Need help with a chart in Excel by NEHicks
I have an excel database that has entries by date with a time associated with each entry. I need to create a monthly line chart that shows the number of...
May 22nd, 2009 12:05 AM
by smartin Go to last post
1 93
FREQUENCY Formula Question by Shaun M
Hi all, perhaps one of you guys can help me here... I have a list of about 6000 phone numbers that I need to evaluate for a call center report. These are...
May 21st, 2009 11:55 PM
by T. Valko Go to last post
2 98
Macro repeat by decimal
How do you make a macro repeat over and over until you tell it to stop. In lotus you could make it loop back on itself until you hit ctrl somehting to...
May 21st, 2009 11:53 PM
by Sheeloo Go to last post
2 79
Post New Thread


Display Options
Showing threads 10821 to 10840 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:10 AM.


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