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
Copying and updating formulas by dimitry
I have a workbook with mutiple sheets, each corresponding to a date. I use a formula which is the actual stock, based on the remainig of the previous. I...
August 2nd, 2008 07:42 PM
by dimitry Go to last post
0 74
Hide all "except" the visible selected range(s)? by Pierre
On Aug 1, 1:35*pm, John C johnc@stateofdenial wrote: Just curious, if everything is hidden if it is not selected, how do you select in the first place? ...
August 2nd, 2008 07:17 PM
by Pierre Go to last post
0 111
Need help with formula by Gerd
Hi. I would like help with the following problem. A1 contains the total job costs and is constantly being updated. At the end of the first invoice period...
August 2nd, 2008 07:06 PM
by Gerd Go to last post
2 167
Count instances of text in date entries by MilusC
I'm using Excel 2007. I have a column of dates in this format - 04-Aug-08, 15-Jul-08, etc. I would like to count the number of times a certain month shows up...
(Multi-page thread 1 2)
August 2nd, 2008 05:48 PM
by T. Valko Go to last post
11 207
tab name = cell value by jatman
is it possible to have a cell value equal the same as a sheet (tab) name? just something simple as =sheet1 or something thank you,
August 2nd, 2008 05:37 PM
by Fernando M. Go to last post
7 171
Adding Multiple Excel Spreadsheets To One Another From Saved HTML Pages by Martin
Hello, I'm currently involved in a project in which I'm *individually* saving (Save As) a live HTML web page before converting it to an Excel spreadsheet. I...
August 2nd, 2008 05:20 PM
by Barb Reinhardt Go to last post
1 172
index match by Anthon
A B C D ROW 5 1 65 6 56 ROW 6 2 100 7 41 ROW 7 3 34 8 32 ROW 8 4 6 ...
August 2nd, 2008 04:05 PM
by Teethless mama Go to last post
4 96
Need Formula by vmohan1978
Summary 8mm 10mm 12mm 16mm 20mm 25mm 32mm ...
August 2nd, 2008 01:01 PM
by vmohan1978 Go to last post
2 89
Conditional Formatting Q by Sean
What formula could I use within CF to express the following If A1 in Sheet1 is less than or equal to 80% of the value of A1 in Sheet2, then change text colour...
August 2nd, 2008 11:17 AM
by Bob Phillips Go to last post
1 81
trying to use the index function when #N/A can be part of data ran by Dan T.
I am using the index function to sample a range of data that will usually contain several lines of #N/A data. The data is from an external app using DDE. ...
August 2nd, 2008 06:27 AM
by T. Valko Go to last post
5 145
Figure future date by J
Is it possible to have cell A1 with todays date and make B1 add 1 week to that date and display it?
August 2nd, 2008 04:35 AM
by Gord Dibben Go to last post
7 212
Turn vertical data to horizontal data automaticaly by Leandro Sesarego
I have a big amount of records that looks like this: Leo Sesa 10666 Wilkins Ave #306 310-494-5875 Paul Wakki 12510 Van Nuys Blvd 818-497-9552
August 2nd, 2008 04:31 AM
by Gord Dibben Go to last post
7 99
is this possible ? by Ms_M_o_n_i_c_a
I want to create a drop down list with only the item & function. Then depending on what item/function is picked, i need the dept and class and subclass to...
August 2nd, 2008 04:23 AM
by Gord Dibben Go to last post
3 86
Conditional Sum based on independent evaluation by analysis headache
I am trying to figure out how to sum certain cells in a row that correspond to a Date in the same column. For example. A B C ...
August 2nd, 2008 02:23 AM
by smartin Go to last post
1 123
% of Subtotal In Pivot Table by Milodie66
Is it possible to utilize options or any other field to build a % of a value against the subtotal of the group. Example: Sales is my group, I have multiple...
August 2nd, 2008 12:56 AM
by smartin Go to last post
1 107
Notes and Coinage for Wages by Owl
If, for example, one labourer’s wages for the week are R1843, is there a simpler way to work out the notes and coins to be got from the bank, than the...
August 2nd, 2008 12:53 AM
by T. Valko Go to last post
3 92
Need Function for Year-to-Date spent total by mokshadavid
I'm doing a Budget Worksheet for the Fiscal Year 08-09. I am looking for a function that takes the previous month worksheet's "YTD spent" total, adds it to...
August 2nd, 2008 12:48 AM
by mokshadavid Go to last post
3 139
Excel Spreadsheet by july
I have created a form on worksheet 1....I want to enter the data on worksheet 2 to automatically populate on the form in worksheet 1... but keep a running...
August 2nd, 2008 12:39 AM
by JLatham Go to last post
3 90
Automatically Populating a Worksheet by TS
I have worksheet that has certain information about our manufacturing operation. I have another worksheet where I would like to extract certain data from the...
August 1st, 2008 11:19 PM
by Gord Dibben Go to last post
2 119
Find & Replace by chiefwidmer
Is it possible to replace the contents of an entire row if that row has a cell which was found with the F & R function? When using the F&R function it found...
August 1st, 2008 10:37 PM
by NoodNutt Go to last post
1 70
Post New Thread


Display Options
Showing threads 22121 to 22140 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:26 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.