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
Show matching data in several worksheets by Steve
If I have a workbook with 7 sheets in it, e.g. violet,indigo,blue,green,yellow,orange and red. And data is in the A column of each sheet. E.g....
April 26th, 2010 05:16 PM
by Max Go to last post
4 332
Fill/Extend Series adding decimal points to some numbers by awalker
Hi, I set up a worksheet for a Lookup Function that contains numbers increasing by 0.1 from 100.0 to 50.0. I used the drag and fill to set up the numbers. ...
April 26th, 2010 05:06 PM
by Pete_UK Go to last post
1 640
limit comments to only 600 words by Tim
I have created a text box but I want the text length to be equal to or less than 600 words. How do I do that in Excel 2003 please
April 26th, 2010 04:05 PM
by Gary Brown[_6_] Go to last post
2 639
11 months and 1 day from a given date by pk
How can I calculate 11 months and 1 day from a given date using an excel 2003 function?
April 26th, 2010 04:01 PM
by Ashish Mathur[_2_] Go to last post
5 720
Count first and last characters by Elton Law[_2_]
Dear Expert, I have got a file which have a system generated field below. (15 rows) First character must be either "T", "F", "U". Last character must be...
April 26th, 2010 03:56 PM
by Ashish Mathur[_2_] Go to last post
3 819
copying a formula down wards by UKMAN
=INDEX(Proj_code,MATCH(AQ$6,F$7:F$198,0)) the above formula works in that it shows the first match. As there could be mulitpule records what do I need to do...
(Multi-page thread 1 2)
April 26th, 2010 03:41 PM
by Ashish Mathur[_2_] Go to last post
10 1,468
Help Needed with Dynamic CountIF by Steve
Hello All. I have a sheet like this on a tab called Summary: Month: Jan'10 (This is a drop down list showing all months) Sales Person New Clients Sec Lead...
April 26th, 2010 03:01 PM
by Steve Go to last post
4 711
Change a cells value with a function by Ryan H[_2_]
Here is my function contained in O74. C70 has "Water Heater" in it and I73="2". Why doesn't N74 have FALSE in it? Also, is there a way to control a Forms...
April 26th, 2010 01:31 PM
by Ryan H[_2_] Go to last post
4 750
Automatically hide/unhide rows by JStiehl
I'm a VBA newbie and have searched for an answer for how to do this, but must be doing something wrong when I've tried other codes. I need to have rows...
April 26th, 2010 01:29 PM
by JStiehl Go to last post
6 729
Referencing relative to a formula reference by Csaba Gabor
I have an Excel workbook with two worksheets. In one sheet (Books) I have defined a series of items with column 1 being my book Id and column 4 being the...
April 26th, 2010 01:13 PM
by Bob Phillips[_3_] Go to last post
3 635
Date + relative number reference by Derek M[_2_]
Hi all I have a spreadsheet with dates in row 3 going from today till the end of the year i.e 26/apr/2010 In row 16 directly below the date i have a number...
April 26th, 2010 12:43 PM
by Derek M[_2_] Go to last post
3 770
Despite formula I use (for example SUM) result is always zero. by Anida
Despite formula I use (for example the most simple SUM) it always shows me zero result even it should show a lot more. Values in other cells (cells that I...
April 26th, 2010 12:28 PM
by Dave Peterson Go to last post
5 709
Excel Formulas by Shona
Dear, I need to calculate the below in excel sheet. please find below the details and advise me: Amount - 25000 - 3% * 3% please advise how to subtract 3%...
April 26th, 2010 07:38 AM
by Shona Go to last post
3 645
How to Sum infinite formula by minyeh
I'm doing a transition matrix (hazard rate method) using formula (trying to avoid using VBA under some company policy), but then, i'm stuck when it comes to...
April 26th, 2010 04:39 AM
by minyeh Go to last post
7 844
Finding matches in two columns by Erik
I have two columns of years. Column A has 27 years from 1911 to 2007 indicating a particular year a house was built. Column B has all years from 1800 to 2009...
April 26th, 2010 03:32 AM
by T. Valko Go to last post
4 661
IF function by Lost Cluster
I’m using the If Function to compare a string of text to a letter. This is what I have ColA has names ColB has the days off in this format (string of text)...
April 26th, 2010 03:08 AM
by FSt1 Go to last post
4 657
SUMPRODUCT by Skinman
Hi all Please. Needing some assistance. Using excel 2007 This formula starting in the first row of my data ranks each share value for the first day (entered...
April 26th, 2010 03:04 AM
by T. Valko Go to last post
3 667
Referencing formula using Indirect by Raj[_4_]
Hi, A workbook has 13 sheets, a sheet each for the months from Apr-10 to Mar-11 and final summary sheet In the Summary sheet, I have a validation list in...
April 26th, 2010 01:37 AM
by Raj[_4_] Go to last post
4 660
¿cómo puedo conbinar formulas entre hojas de exel ? by fajardo sebastian
nesecito saber si se pueden conbinar formulas entre celdas de distintas hojas de un mismo archivo
April 26th, 2010 12:15 AM
by Héctor Miguel Go to last post
1 779
IFERROR in Excel 2007 by Dirrk
I need an example on writing an IFERROR in Excel 2007. =IFERROR......I have to do this for work and can't find anything on it.
April 25th, 2010 10:08 PM
by Danny Rocks Go to last post
5 927
Post New Thread


Display Options
Showing threads 1001 to 1020 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 09:40 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.