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
producing a report via a keyword - filtering and macros not suitab by UKMAN[_2_]
help needed please........ I am not a formula expert so bear with me please. I know filtering is available but I am trying to save effort as data goes into a...
June 1st, 2010 10:58 PM
by Steve Dunn Go to last post
1 796
Remove columns containing all zeros by Nora_GG
How can I create a macro or conditional formula to remove columns containing all zeros
June 1st, 2010 10:44 PM
by Nora_GG[_2_] Go to last post
2 790
Calculate the number of seconds between two times by Budda Belly
I need to calculate how many seconds are between two times, e.g. 8:08 AM start time and 8:44 AM stop time so I can use the result in a formula. The start and...
June 1st, 2010 10:06 PM
by Roger Govier[_8_] Go to last post
2 890
modifying T. Valko ws function by Steve
Howdee all. I received some help from T. Valko back in January on a complicated worksheet function. It's been working really great, and today I found that I...
June 1st, 2010 09:30 PM
by Steve Go to last post
5 1,120
IF formula question by charlie
I need to write a formual for the following: IF J1=R and L1= 3221 OR 3223 then N1 should be FALSE J1 could be either R or C and L1 could be any numer of...
June 1st, 2010 08:53 PM
by Lars-Åke Aspelin[_4_] Go to last post
3 830
How to know if a worksheet was unlocked by Mathieu936
Hi! I have a worksheet containing many formulas. This worksheet is locked without any password. Is there a way to see if somebody unlocked the worksheet to...
June 1st, 2010 07:30 PM
by Dave Peterson Go to last post
8 982
why is the feature "share workbook" unavailable to use by Share Workbook
I am trying to share a work book but the feature is grayed out, not sure why - pls explain
June 1st, 2010 07:15 PM
by Share Workbook Go to last post
0 793
HLookup? by wagz
I have a sheet that is comparing vendor's pricing. I am using the MIN to find the cheapest cost, but now I want to find out which vendor it is based on the...
June 1st, 2010 07:07 PM
by Roger Govier[_8_] Go to last post
2 930
How do I save a header? by Global10
I need to permanently save a header and it will never save once I open up a new file. Any suggestions?
June 1st, 2010 05:28 PM
by Gord Dibben Go to last post
2 800
V-Lookup variation query by njcr83
Hi, I am having an issue with comparing columns of values. Basically I have a table similar to the below except with a couple of thousand lines. Either the...
June 1st, 2010 04:41 PM
by Glenn Go to last post
2 840
Interpolation? by Mel
What fx to use for the following scenario: Month-End Dates (for many years) in column A A dollar Amount for each Quarter End in Column B (correlating to the...
June 1st, 2010 04:09 PM
by Steve Dunn Go to last post
1 738
Conditional formula with text and number in cell by RichM
Hello, Can a conditional formula be written to convert a cell with text and a number to a cellw ith just a number? I have a cell with the number 10 and the...
June 1st, 2010 03:22 PM
by Steve Dunn Go to last post
7 882
How does a function provide a blank cell as a result by Rene B.
Within an IF function, I would like to have the cell left blank given a certain logical result. The purpose is to have a result, that does not show up as a...
June 1st, 2010 03:06 PM
by Anand[_5_] Go to last post
2 773
Reference(s) to worksheets for building graphs by PvZ
In my workbook I have multiple sheets. I have a summary sheet, called: Graphs, consisting of (only) graphs, build from the data from the various sheets. These...
June 1st, 2010 01:08 PM
by PvZ Go to last post
4 804
Address must be 18 characters long by Derek M[_2_]
Hi all again I need the address to be 18 characters long i.e. if the address is over 18 characters then chop it, if its under, then add spaces Is this...
June 1st, 2010 01:06 PM
by Derek M[_2_] Go to last post
3 735
Difference between two date/time values by Raj[_4_]
Hi, Cell A1 has 21-04-10 07:00 PM Cell A2 has 06-06-10 07:52 AM (the dates are in the dd-mm-yy format) Cell A3 has the formula =A2-A1 for showing the...
June 1st, 2010 12:58 PM
by Raj[_4_] Go to last post
6 785
Sumproduct formula help (possible Index????) by Mark D
Morning all I am stuck with a forumula that I hope someone will be able to help with. It's quite long winded the way I am doing it but am hoping that it may...
June 1st, 2010 12:55 PM
by Jacob Skaria Go to last post
7 735
Can't rework the formula by Malcolm
Yesterday I was given a solution to a problem I had when copying text from cells in the source sheet to the destination sheet. The formula: =IF(OR('Hskp...
June 1st, 2010 02:53 AM
by T. Valko Go to last post
7 808
If OR formula by Susan
I am trying to write a formula that will first look at the value in C3 which is identified by either 1 or 99. Then depending on either of these two numbers,...
June 1st, 2010 02:51 AM
by T. Valko Go to last post
1 740
View Message when Mouse Hovers over Cell. (Not the Comments Feild) by Kev - Radio Man
Hi, I am interested if there is a way to have a message become visible when the mouse is hovered over a cell. I am currently using 2007. In this problem I...
June 1st, 2010 01:02 AM
by Kev - Radio Man Go to last post
2 960
Post New Thread


Display Options
Showing threads 141 to 160 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:43 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.