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
Nesting drop-down menus by Alonso[_2_]
Hi everybody i'm working with nested dropdown menus in column A select a machine in column B choose a product (depends on the machine) in column C pick a...
October 17th, 2008 06:59 AM
by Gav123 Go to last post
1 100
How do use a template for different worksheets in workbook by peggy
I have to create a workbook which includes two worksheets for class. It is to be a budget--1st sheet is start up costs and second is monthly expenses. I...
October 17th, 2008 04:53 AM
by Ashish Mathur[_2_] Go to last post
1 98
Multiple DSUM criteria (MONTH & a numeric value) between worksheet by sarah
Hello. I'm trying to use DSUM to calculate a row of quantities that fit the criteria of a specific month and size. Here's an image explaining what I am...
October 17th, 2008 04:44 AM
by Peo Sjoblom Go to last post
4 256
Date Formulas by kaz
Could someone please help with a formula to work out the difference between two dates and show how many years, months and days there are
October 17th, 2008 03:24 AM
by muddan madhu Go to last post
7 105
dates by rebecca
How can I change the date format 01/01/08 to 010108
October 17th, 2008 02:40 AM
by Rick Rothstein[_2_] Go to last post
6 107
Need help with logic or Vlookup formula by Andrea
I am relatively new to excel and need help with creating a formula. Based on the table below my goal is to take information from column A (or a range of...
October 17th, 2008 02:11 AM
by Sheeloo[_3_] Go to last post
9 124
Excel VBA and Comment boxes by DCPan
Hi, I wrote something that would automatically place the cell content into a comment box, and replace the cell content with the words "See Comments". Now,...
October 17th, 2008 12:40 AM
by Sheeloo[_3_] Go to last post
3 133
Lookup using variable name by Rod
Hello, I have excel range names of: tblCA10 tblCA15 tblCA20 tblCA25 tblCA30 tblCA35
October 17th, 2008 12:09 AM
by Max Go to last post
1 110
Reference left most value in cell by rtwiss via OfficeKB.com
How do i reference left most cell value? IF(Left most cell value in A1 = Left most cell value in B1, true statement, false statement) Ex: A1= 45 I want...
October 16th, 2008 11:20 PM
by Teethless mama Go to last post
3 119
Complex Conditional Formating by Ben A[_2_]
I am trying to create condtional formating to turn a cell red with a complex IF/ LOOKUP Function for the rule. The Function works outside of conditional...
October 16th, 2008 11:05 PM
by Ben A[_2_] Go to last post
6 86
Vlookup type thingy by JockW
Creating a internal phone book for a company. Sheet 1 has the following details: Division Department A employee 1 123456 employee X 123457 employee 3...
October 16th, 2008 10:49 PM
by T. Valko Go to last post
5 92
Allocating remainders by ramtroop
Example--I have ten vendors, each gets a % of a total. The remainder needs to be allocated to the vendor with the highest %. Any way to automate that.
October 16th, 2008 10:35 PM
by Bernard Liengme Go to last post
2 91
function? by RT
Is there a Function for this formula?? =(E4*C4)+(E5*C5)+(E6*C6)+(E7*C7)+(E8*C8)
October 16th, 2008 10:33 PM
by Sheeloo[_3_] Go to last post
2 93
How to Double click a blank cell to enact "ctrl + ;" by Emredrum
I would like to be able to double click a cell to insert the date. I know ctrl + ; will insert it, but is there a way to have the cell read a double click...
(Multi-page thread 1 2)
October 16th, 2008 10:30 PM
by Gord Dibben Go to last post
10 155
Correlation analysis by todd012976459210
HELP! I need to do a correlation analysis of mutiple variables against an observable daily event. Can someone profiicient in Excel and statistics guide me?...
October 16th, 2008 10:23 PM
by todd012976459210 Go to last post
6 96
IF NOT Statement by rtwiss via OfficeKB.com
What am I do wrong here? =IF(NOT(ISNUMBER(J12),ISNUMBER(K12)),"boy","girl") -- Message posted via...
(Multi-page thread 1 2)
October 16th, 2008 10:19 PM
by rtwiss via OfficeKB.com Go to last post
10 225
Run Macro Based On Time by Sabosis
Hello- I have a workbook that send out department stats out every hour to our management team. I need to add something (might be an IF statement) to run a...
October 16th, 2008 09:31 PM
by Sabosis Go to last post
2 81
AND, MAX by PAL
I am working with the formula below. G2 and I2 are dates, or blank. If both are blank, I would like a blank in the field, if one or both have dates, I...
October 16th, 2008 09:18 PM
by T. Valko Go to last post
8 97
IF Statement with two variables by RoadKill
I've gone brain dead on this. Here is my formula, what am I doing wrong? Thanks =IF(H12="Tier 1" & J12="Yes",(150*B12),"None")
October 16th, 2008 09:01 PM
by RoadKill Go to last post
8 109
Insert 5 rows between existing values in a single column 1 by camsd
I have a sheet with over 10,000 rows of existing data, all in a single column. I need to insert 5 rows in between each existing row quickly and easily. ...
October 16th, 2008 08:56 PM
by RagDyer Go to last post
7 129
Post New Thread


Display Options
Showing threads 19001 to 19020 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 07:43 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.