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
Compare lists - count # records by Jan
Hi, Using Excel 2003. I have two lists. List A - has one record of ID. List B - may have more than one record of ID. I need a formula on List A to count...
September 26th, 2008 05:10 AM
by Peo Sjoblom Go to last post
1 135
To Make a Changing Data Sheet by ShellyK
Hi, I need to make a Data Sheet. The First Sheet will have the imputs and the following sheets will have calculations. On the imputs sheet, I want to be...
September 26th, 2008 02:13 AM
by Ashish Mathur[_2_] Go to last post
4 248
Pivot Table Fields: Median function? by Rosie
Hi. Is there a way to summarize a field using MEDIAN? It's not one of the options.
September 26th, 2008 01:56 AM
by Ashish Mathur[_2_] Go to last post
3 262
Finding multiple items from a list by Col[_3_]
Hello all, Wonder if you kind souls can help me out with this one. The office mangers in my territory need to complete some information for me and I'm trying...
September 26th, 2008 01:39 AM
by Ashish Mathur[_2_] Go to last post
4 163
Index by bbmexgal
Hello, Im creating a chart that should be reading froma table it has 3 diffrents variables ex a blue 50 b red 70 c orange 80 a blue 60 b red 80 b...
September 26th, 2008 12:43 AM
by bbmexgal Go to last post
0 133
how do you print single page multiply times with increasing page . by aliasmith
How do you print a single page multiply times with increasing page numbers?
September 26th, 2008 12:30 AM
by Gord Dibben Go to last post
2 157
Excel footer default font size by Rhiannon Thomas
I need to set up a default font size to be smaller than the worksheet font size so that all worksheets have a file path footer that is a size 8. I would...
September 26th, 2008 12:28 AM
by Gord Dibben Go to last post
1 156
Milenko Kindl itpiotpoil by [email protected]
NEW YORK - Financial markets grew more upbeat Thursday as political leaders said they struck an agreement in principle on a massive spending plan to revive the...
September 25th, 2008 11:55 PM
by [email protected] Go to last post
0 151
Calculating time by Erica
I am working on a spread sheet and I need it to calculate the hours worked based on the clock in/out time... This is the formula that I have...
September 25th, 2008 10:39 PM
by T. Valko Go to last post
4 138
Locking individual cells in an excel spreadsheet by sglassedmkw
I'm looking to lock specific cells in a spreadsheet so that no one can change them. It needs to be a workable cell because its part of (or linked to) a...
September 25th, 2008 10:39 PM
by sglassedmkw Go to last post
4 116
If Function by trnivens
I have a spreadsheet for our office football pool. I put in everyone's picks and if the team they pick matches the winner they get a point and then it...
September 25th, 2008 10:13 PM
by David Biddulph Go to last post
5 123
=IF(ISERROR(SEARCH("insurance",A125,1)),"","*") by cynichromantique
Is it possible to add additional words to a statement of this nature? Examples: coverage homeowners annuity blue cross group
September 25th, 2008 09:49 PM
by bridgemonkey Go to last post
9 126
Formulas by jen
Hi, I was wondering if there was functionality in Excel that allowed me to save basic formulas, that I use constantly in various worksheets, in a drop down...
September 25th, 2008 09:35 PM
by [email protected] Go to last post
1 120
Using data from multiple worksheets in a formula by altschool
I have a workbook that will have 26 worksheets, the first worksheet will serve as an index of data for a roster of students. The other worksheets will be...
September 25th, 2008 09:31 PM
by Duke Carey Go to last post
1 114
Formula for sum of alternate cells by John Blackwell
Folks, I'm trying to find a formula for summing the contents of alternate cells in a row? I have a large workbook and want to calculate the contents of row...
(Multi-page thread 1 2)
September 25th, 2008 09:28 PM
by Peo Sjoblom[_2_] Go to last post
10 215
Clearing scheduled work hours for weekends by Phil B.
I have set up an worksheet for employees that automatically populates two rows, the day (eg. Wed) the date (e.g. 15). The first day and date are calculated...
September 25th, 2008 09:03 PM
by Roger Govier[_3_] Go to last post
6 149
Intermediate value of a set of array. by HARSHAWARDHAN. S .SHASTRI[_2_]
Actually i have raised this query about 2 years back in same forum but still i have not got satisfactory solution. What i looking for is , I am having...
September 25th, 2008 09:01 PM
by MartinW[_2_] Go to last post
5 132
Paste Special Multiply Formulas not working in Excel 2007 by el_guapo
Not sure if anyone else uses this, but in 2003 you can copy a cell whose formula is '=$A$1' then paste special multiply formula onto a second cell or range...
September 25th, 2008 08:30 PM
by Ron de Bruin Go to last post
1 145
Alphanumeric udf question. by K
Guys I found a code to extract numeric, decimal or negative values from a alphanumeric value. It works great, my problem is that I want to use it for an...
(Multi-page thread 1 2)
September 25th, 2008 08:23 PM
by Ron Rosenfeld Go to last post
10 282
function or code? by hal
What would be the best way to look at the value in 6 cells and in another cell next to it put what its rank is? For example, say you have the following values...
September 25th, 2008 08:14 PM
by hal Go to last post
3 119
Post New Thread


Display Options
Showing threads 19861 to 19880 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 03:05 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.