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
Look Up by Youngy5
Hi I want to know if i can combine the following two formulas into one. I have two spreadsheets in the same work book. I want column B of spreadsheet 2 to...
June 17th, 2009 09:31 AM
by Pete_UK Go to last post
2 71
shared excel workbook by fi.or.jp.de
Hi All, Is there any vba code to know whether the active workbook is shared or not ? like this ..... if activeworkbook is shared then ...
June 17th, 2009 08:17 AM
by fi.or.jp.de Go to last post
0 91
ISBLANK and OR Function by Jacob Skaria
Try the below array formula =IF(COUNTIF($S$5:$BY$5,"0")=COLUMNS($S$5:$BY$5),"None",INDEX($S$4:$BY$4,MATCH(0,VALUE($S$5:$BY$5),0))) If this post helps click...
June 17th, 2009 08:01 AM
by Jacob Skaria Go to last post
0 85
captcure close application event by suru
Hi, I am new to VBA. Can anyone tell me how to capture Close Application (i.e. close all workbooks) event in Microsoft Excel using VBA? I know that, when i...
June 17th, 2009 07:10 AM
by suru Go to last post
2 98
sumproduct help by kristap
First I want to say thank you for all the help everyone is here. Now for my question. Still helping my husband do his spreadsheet for work with all his...
(Multi-page thread 1 2)
June 17th, 2009 06:28 AM
by T. Valko Go to last post
12 188
how do i format a cell to use text and formulas by brianDY
heres what im trying to do .. i want to create a note template that would be something simillar to this: sally sold 18 units of seashells I want the 18 part...
June 17th, 2009 06:10 AM
by Jacob Skaria Go to last post
3 124
Cypher by Bullocks
Good day, No, I'm not James Bond nor am I a criminal trying to hack into the CIA... Just wanted a hand with a simple cypher if anyone can help. I want to be...
June 17th, 2009 05:12 AM
by Rick Rothstein[_2_] Go to last post
3 114
Excel 2007 - Pivot Table and Calculated fields? by Wanda
For All: Thanks in advance for all assistance! I have a spreadsheet listing information of all the loans on our books, one loan per line. Some of the data...
June 17th, 2009 04:33 AM
by Shane Devenshire[_3_] Go to last post
1 116
Can one change shape properties conditionally? by Bob Arnett
Is it possible to have a shape's properties change conditionally based on the value of certaiun cells as is possible with conditional formatting of cells?
June 17th, 2009 04:14 AM
by Shane Devenshire[_3_] Go to last post
1 93
Range Names by
How can I create a range name that can only be used for a particular worksheet, instead of the entire workbook?
June 17th, 2009 04:07 AM
by Harlan Grove[_2_] Go to last post
2 106
ISBLANK and OR Function by Shane Devenshire[_3_]
Hi, Something the following array formula: =IF(COUNTA(S5:BY5),INDEX($S$4:$BY$4,1,MATCH(TRUE,(S5:BY5=0)+(S5:BY5="")0,)),"None!") Array - you need to enter...
June 17th, 2009 04:01 AM
by Shane Devenshire[_3_] Go to last post
0 95
Data validation by VLOOKUP fORMULA
Any one pls help me....? I am having a data validation rule in sheet1, data taking from sheet2 using a drop down menu. My problem is that I am entering the...
June 17th, 2009 03:03 AM
by Ashish Mathur[_2_] Go to last post
2 123
yes/ No on multiple sheet by Muskrat24
I am trying to make a spread sheet so if for example on sheet 1 I have A B C D 1 Big $5 ...
June 17th, 2009 02:50 AM
by Ashish Mathur[_2_] Go to last post
3 89
Range Name by
How can I create a range name that is only used for a particular worksheet, rather than the whole workbook?
June 17th, 2009 02:07 AM
by Dave Peterson Go to last post
1 94
del certain rows based on word search by Robert
Hello, I import about 50 pages of data from another program that leaves page headers which consist of 10 rows of junk. In between these rows of headers,...
June 17th, 2009 01:46 AM
by Robert Go to last post
2 83
Countif function question by stevestr
I have a list of birth dates in column A. I want to provide a list of age ranges in a summary next to the column. For example I would like to create a...
June 17th, 2009 01:45 AM
by smartin Go to last post
2 101
how to calculate x months from today by Gene
Excel 2003: I have a "date" in a cell (eg: 6/16/09), and want to calculate the date which is 6 months from now? The issue I'm having is that some months are...
June 17th, 2009 12:52 AM
by Ron Rosenfeld Go to last post
6 222
IF Dates by Talladega
Hi, I have a column filled with dates. I need to write a formula to show if the date in column a is after 12/31/06. If it is, then is shows the date of...
June 17th, 2009 12:50 AM
by JoeU2004 Go to last post
1 106
Grouping Data by Humble09
I have excel 2007 and want to group the list in the 'KEYS' column so that it reference the name of the person who has the keys. LAST NAME FIRST...
June 17th, 2009 12:25 AM
by smartin Go to last post
1 84
Internal Rate of Return (IRR) by [email protected]
IRR function is unable to determine below cash flows. 0 -868055555.6 -156250000 -156250000 -166666666.7 -90617472.63
June 16th, 2009 10:58 PM
by Fred Smith[_4_] Go to last post
2 141
Post New Thread


Display Options
Showing threads 10041 to 10060 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:24 AM.


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