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
Date Help by Malcolm
I have linked two columns on a worksheet so that when I type in the date in cell C6 it also appears in cell J6. I entered =$C$6 in J6, and this works except...
May 27th, 2010 11:38 PM
by Fred Smith[_4_] Go to last post
1 131
Truth Table by Victoria612
OK - I have 6 questions, all of which can be answered either yes or no. Is there a way to build a macro that can determine all 36 possible scenarios for...
May 27th, 2010 11:32 PM
by Tom-S[_2_] Go to last post
2 115
YTD % over 12 accumulating figures by Ellie
I have a spreadsheet listing out employees, e.g. as follows: Name Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total YTD% A N Other ...
May 27th, 2010 11:03 PM
by Jacob Skaria Go to last post
1 158
CELL CONTENTS WRITE TO TAB NAME by Pam M[_2_]
I know there is a way to reference a worksheet name in a cell. Is there an automated way to name the sheet based on a cells contents? I have summary sheet...
May 27th, 2010 10:55 PM
by Pam M[_2_] Go to last post
0 153
If statement linking data from one sheet to another by Mathew
I have a spreadsheet with many tabs. I am trying to develop a summery sheet that will ‘auto fill’ certain rows of data and still remain dynamic. What I...
May 27th, 2010 10:49 PM
by Mathew Go to last post
3 213
CELL CONTENTS WRITE TO TAB NAME by Jacob Skaria
Select the sheet tab which you want to work with. Right click the sheet tab and click on 'View Code'. This will launch VBE. Paste the below code to the right...
May 27th, 2010 10:47 PM
by Jacob Skaria Go to last post
0 193
Linking text cells between 2 worksheets by Malcolm
I tried this before but explained my problem so badly I did not get the response I was looking for, so let me try again. My workbook contains sheet 1(the...
May 27th, 2010 10:47 PM
by Malcolm Go to last post
0 288
Concatenate with a specific number of spaces by Derek M[_2_]
Works like a charm, thanks Tim "tim m" wrote: This should work though I'm not sure if it is the most efficient way. Create a new column in the column...
May 27th, 2010 10:46 PM
by Derek M[_2_] Go to last post
0 116
How can I copy the sum of a filtered column into a cell in anothe by ToffeeCoffee
How can I copy the sum of a filtered column into a cell in another worksheet so that when changes are made within the column the change in the sum also...
May 27th, 2010 10:44 PM
by Mike H Go to last post
1 233
Date Math by Microsoft[_18_]
Excel 2007 1 have a start date: 01/01/2009 finish date: 23/06/2010 I want to calculate the length of service between the two dates to the nearest month,...
May 27th, 2010 10:40 PM
by Mike H Go to last post
4 193
Macro to build table by Victoria612
I have 6 questions that may be answered yes or no, and for the sake of keeping everything in integer form, let's assume "1" for yes and "0" for no. Depending...
May 27th, 2010 10:39 PM
by Victoria612 Go to last post
0 225
frustrated excel newbie by FSt1
hi format the cell with the validation to date. if formated as general, you will get the serial date number. Regards FSt1 "TJ" wrote: I am trying to make...
May 27th, 2010 10:39 PM
by FSt1 Go to last post
0 145
Sumproduct Question Working With Start and End Date Range by StonyfieldRob
Having a tough time with this one. Sheet 1 Column A = Start Date, Column B = End Date, Column C = Quantity. Sheet 2 Row A = Start Date, Row B = End Date. I...
May 27th, 2010 10:36 PM
by Tom-S[_2_] Go to last post
1 270
prompting while typing by John
Open office org - while working on excel sheet, prompting of words helps a lot in reducing the time of work. Is microsoft excel having the same function
May 27th, 2010 10:33 PM
by Jacob Skaria Go to last post
2 177
ticking box by deeps-k
how i add ticking box in worksheet (cell)
May 27th, 2010 10:32 PM
by Jacob Skaria Go to last post
1 148
IF AND VLOOKUP formula needed by Carolina
I need to do a formula where I need to determine if the size of C12 or C13 is greater or less than E12 or E13 respectively. Knowing that I need for the...
May 27th, 2010 10:31 PM
by Tom-S[_2_] Go to last post
1 200
Having info in a certain cell EXACTLY same as in cell on anotherpa by OnePuttJames
SIMPLY... I want in my summary tab to have the data from A1-P30 to ALWAYS be the data showing on my first page tab that is in position A1-P30.. Once a week I...
May 27th, 2010 10:30 PM
by Max Go to last post
2 194
Date Help by Eduardo
Hi, use this formula instead =if(C6="","",$C$6) "Malcolm" wrote: I have linked two columns on a worksheet so that when I type in the date in cell C6 it...
May 27th, 2010 10:29 PM
by Malcolm Go to last post
1 156
CONCATANATE by nlogan
How to concatanate two fields. Entered =concatanate(a2,b2). Getting #NAME?
May 27th, 2010 10:29 PM
by Jacob Skaria Go to last post
3 139
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 204
Post New Thread


Display Options
Showing threads 261 to 280 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 10:28 PM.


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