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
give each NO in a drop down a different value by Shevy
I have a worksheet in which I want to be able to give the NO's in the drop down a different value so that the total value when added up will tell me the...
June 24th, 2009 03:35 PM
by Max Go to last post
5 182
Excel lock / Notify feature malfunctioning by andrei999
At our workplace we have a master Excel workbook that accessed daily by sales personnel. Each person has to make entries that they responsible for. Once...
June 24th, 2009 03:28 PM
by andrei999 Go to last post
0 125
How do I insert a dynamic reference of a range inside VLOOKUP? by Alexandre
I need to insert a VLOOKUP inside another VLOOKUP in the "Table Array" definition in order to get different information selected from a big database. Example:...
June 24th, 2009 03:28 PM
by Alexandre Go to last post
4 213
find for non zero values in a column Median,Mode,STDEV by Billp
Hi, I have a column Range J2:J300. I have seen from other posts the method of getting the average(Mean) is =SUM(J2:J300)/COUNTIF(J2:J300,"0") I have tried...
June 24th, 2009 03:20 PM
by Bassman62 Go to last post
2 189
If any specific #s are present in range, show each in another cell by Steve
If I have a range, e.g. A1:A10, and in that range are various #'s, such as 1s, 2s, 3s or 4s. I'd like a formula in cell B1 that would produce all the...
June 24th, 2009 02:57 PM
by Steve Go to last post
6 130
Conditional programming by Mark
Hi, Could you tell me how i can apply conditional formatting rules to all sheets in a excel 2007 workbook? Also, can you copy rules from file to...
June 24th, 2009 01:55 PM
by Mark Go to last post
0 135
Daily compound interest by Karen
I need to calculate daily compound interest and I tried the following formula Column A (no of days) | Column B 1 | ...
June 24th, 2009 01:30 PM
by Fred Smith[_4_] Go to last post
2 147
Change cell color in protected sheet by ansa
I have a worksheet where some cells are locked and the whole sheet is protected. The users should be able to: 1. Enter data into the cells that are not...
June 24th, 2009 01:26 PM
by Stefi Go to last post
1 123
Financial formula by Karen
Need some help on a financial formula : Let's say I have $1,000 in an account. The interest rate is 5.5%pa. If start date is 10 Mar 2003 and end date is 30...
June 24th, 2009 01:25 PM
by Fred Smith[_4_] Go to last post
6 150
Summing Data by Date by Nigel P[_2_]
I would like to summarise data by date for example A1 B1 - Date, Value 1/2/9 10 1/2/9 12 2/2/9 34 3/2/9 27 4/2/9 56 with results in another range of...
June 24th, 2009 01:02 PM
by NBVC[_20_] Go to last post
6 103
Mulitiple Criteria using SUMIF by Trevor Aiston
I have a data table on worksheet within a workbook which contains a mix of numeric and text data. eg a2:a92 containis numeric values of either 0 or 1 while...
June 24th, 2009 12:43 PM
by Stefi Go to last post
3 121
Excel Maximum viewable numbers in a cell by Tony
A cell doesn't seem to show more than 16 numers it turns the last 3, in my case, to zeros. ie 8944456845364785123 is shown as 8944456845364785000. Not a big...
June 24th, 2009 11:14 AM
by Sheeloo Go to last post
2 151
Sum of named ranges conditional to date? by SleazyBreezy
Hi all, Say I have a spreadsheet listed as follows: A1 = 03/31/05 A2 = $5.00 B1 = 03/31/05 B2 = $10.00
(Multi-page thread 1 2 3)
June 24th, 2009 10:46 AM
by Nigel P[_2_] Go to last post
25 1,079
Desperately trying to build a paid time off accrual worksheet... by cgautreau
I work for a company that owns hotels and casinos all over the States. Company wide I would say we have about 13,000 employees. The hotel I work at has around...
June 24th, 2009 10:29 AM
by rh33a Go to last post
9 249
Sum Multiple Matches by Mart
Is there a way to sum totals based on multiple matches? Say in the following example, from a separate sheet, i want to sum up the totals for stationary on...
June 24th, 2009 10:06 AM
by Hilvert Scheper Go to last post
5 125
Text by Fareez
hi Please help me if i type 100 it should come next column in text say hundred. please not that i want to type cents too say 100.53
June 24th, 2009 08:53 AM
by Jacob Skaria Go to last post
1 126
Vlookup function across data copied from various sources by Scarlett
I have copied a table from another source. I am trying to do a vlookup for a column against this copied table. However N/A is returned. I tried TRIM, CLEAN,...
June 24th, 2009 07:28 AM
by Shane Devenshire[_3_] Go to last post
1 133
NETWORKDAYS Worksheet function by Abhishake Saravgi
The Version installed on my system for Excel is Microsoft Excel 2002(10.6852.6845) SP3. I m trying to use NETWORKDAYS from the Example given in the Help...
June 24th, 2009 07:23 AM
by Jacob Skaria Go to last post
3 159
Incrementing a formula within an excel cell by James C.
Hi all, I am trying to accomplish the following and can't seem to figure it out. I have a tab of monthly data Jan - Dec where Jan is in Cell A1... I have...
June 24th, 2009 07:08 AM
by T. Valko Go to last post
9 167
Range - Formula by VLOOKUP fORMULA
Any one please help me......? Is there any way to give a formula to a named range. for example:- I have given a name Range1 for D10:D20 I need to give a...
June 24th, 2009 07:08 AM
by Sheeloo Go to last post
5 126
Post New Thread


Display Options
Showing threads 9821 to 9840 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 04:51 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.