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
Condensing data from 3D to 2D by Garbin
Hi there, I have a spreadsheet containing data representing a 3 dimensional data structure in the following form; Z1 Z2 Z3 Z4 ... Y1 ...
December 5th, 2007 07:29 PM
by Garbin Go to last post
7 73
Nested if help by Curtis
I need to have a formula that looks at cell a1 and produces the following in cell b1 if a1 4% outcome needs to equal 'None" if a1 =4% but greater than 3%...
December 5th, 2007 07:03 PM
by Bob Phillips Go to last post
1 53
Identify if Cell is Formula or written number by Mike C
David, I just came across this thread and had an additional question..I see how to conditionally format cells that have formulas, but is there a way to put a...
December 5th, 2007 06:01 PM
by Mike C Go to last post
0 75
links to a second workbook doesn't work if origin not open by Gerardo
I have some links from one workbook to another, but when I open only the destination workbook the link shows #value! error. If I then open the origin, the...
December 5th, 2007 05:24 PM
by RagDyeR Go to last post
3 69
How do I sum a column with only a certain date range? by soconfused
I am trying to sum a column with only certain dates, mean if the date in column G is Jan-07, I want to sum column...
(Multi-page thread 1 2)
December 5th, 2007 05:16 PM
by Roger Govier[_3_] Go to last post
14 158
help with formula for bolding font by Roger
I need a calcualtion formula that will result in the bolding of a cell. If cell A1 is less than half the amount of cell B1 then bold cell B1. example A1...
December 5th, 2007 05:08 PM
by Roger Go to last post
3 70
can you calculate sheet to 2 decimal places by JBW
My wife and I set up a fantastic invoice for her very fussy boss, all invoicing was previously in word and completely manual. having been shown the invoice...
December 5th, 2007 04:56 PM
by Gary''s Student Go to last post
1 79
Scatter Plot Point Labels by Dallas
Hello, I would like to make a scatterplot with X and Y parings and a name for each of the points that it creates. I have set up the data as...
December 5th, 2007 04:24 PM
by [email protected] Go to last post
2 107
Convert MM to inch and add to comment by rpick60
How would I convert a number from MM to Inch and add the results to the comment? here is what is the cell 800X400X300 the results can be entered in to a...
December 5th, 2007 04:08 PM
by Dana DeLouis Go to last post
4 99
Excel cell Formatting by Scott
I would like to type numbers including leading zeros while still being able to do calculations. Is this possible? What is the format type? When I use text...
December 5th, 2007 04:03 PM
by Flick Olmsford Go to last post
1 74
How do I convert the result of a formula in a field into a value by Hicks
How Does one convert the result of a formula to a value -
December 5th, 2007 03:50 PM
by Stephen Go to last post
2 91
Pivot tables after Excel 97 by [email protected]
I do a lot of work with pivot tables. Excel versions up to and including Excel 97 allowed me to copy various formulas using pivot table data the same way one...
December 5th, 2007 03:03 PM
by Debra Dalgleish Go to last post
2 73
December 5th, 2007 02:48 PM
by joel Go to last post
3 72
Finding the Location within an Array by Sh0t2bts
Hi All, Thanks to this Group I was provided a snipit of code to find out is a value is within my Array:- If Not IsError(Application.Match(some_value,...
December 5th, 2007 02:06 PM
by Ron Rosenfeld Go to last post
2 70
i WANT TO CALCULATE THE NO IN A SINGLE COLUMN WHICH ARE NOT SAME. by thakur
pls tell me i am using excel and i have a problem, first i am working on worksheet and in a single column i have 200 entries. It contains many nos. same....
December 5th, 2007 12:00 PM
by Stephen Go to last post
1 81
how can i convert digists in to characters in a spread sheet by Raja Aurongzeb
for example if i write 15,000 and i want to convert it in to characters as Fiteen thousand only is there any function in excel spread sheet available to...
December 5th, 2007 09:14 AM
by Niek Otten Go to last post
1 67
Specific function to get the sum by [email protected]
Hi all, I have an excel table with data like: ticket amount invoice n° 45 145$ 7025.222-(75 ) 45 120$ ...
December 5th, 2007 09:10 AM
by [email protected] Go to last post
4 52
Countif Help by Curtis
cell c2 = 80% Column of data is c5:c27 I need to calculate the % of sales greater than the value in cell c2. thanks
December 5th, 2007 08:58 AM
by David Biddulph Go to last post
8 84
HOW DO I MAKE A WORD HAVE A VALUE IN EXCEL by madmhaha
I work on commission. what I sell decides the percentage. I want to know if I can make a word have a value in excel. if i type the word, will it know the...
December 5th, 2007 08:41 AM
by Niek Otten Go to last post
2 90
while entering text excel should not accept duplicate record..? by HAYAT
Hi all, I want to make a list of companies names, (preferrabley in excel, access will be ok too). I want to avoid duplicates, e.g If I enter the same record ...
December 5th, 2007 08:37 AM
by Niek Otten Go to last post
1 93
Post New Thread


Display Options
Showing threads 31001 to 31020 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 05:21 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.