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 Reverse Sort Order Last Post Replies Views
Formatting by Alan
Hi, Not sure if this is on the cards, but does anyone know of a Custom cell format which will display blank if the value of the cell is zero and/or a minus...
October 5th, 2004 03:42 AM
by RagDyer Go to last post
2 156
Calculation speed optimisation - Links and Dependency Tree by Alan
Hi All, Environment = Excel 2007, Centrino Dual-core 2.3MHz processor, 2Gb RAM, WinXP Pro. I am trying to optimise a fairly large set of workbooks for a...
March 5th, 2008 04:18 AM
by Alan Go to last post
0 79
Sumif multiple criteria? by Alan
ok, I am using sumif to add columns with particular names next to them, but I am selecting the names from a dropdown list A1 B1 C1 ...
May 6th, 2008 01:32 PM
by Bob Phillips Go to last post
3 100
Multiple Conditonal Comparison by Alan
Hi, I am wondering what the best way to do a multiple conditional comparison is? For example I have 3 columns of data where I need the first column...
July 25th, 2008 07:20 PM
by John C[_2_] Go to last post
1 124
How do I get my Excel 2007 worksheet to go beyond 65536 rows? by Alan
I saved the workbook as a .xlsx before I even started creating a spreadsheet, and I can't get any spreadsheet in the workbook to go beyond the old limits of...
May 4th, 2009 04:03 PM
by Bernard Liengme[_2_] Go to last post
1 87
How to use keyboard to enter the drop down list? by Alan
The drop down list i dun like use mouse to click it....is that can use keyboard enter?
May 29th, 2009 02:46 AM
by Alan Go to last post
2 128
add 10,0015:15 hours to 03:53 Hours to a total time by Alan
when adding a hour number larger that 10,000 to another time number the formula will not give a correct answer. Tried several time formats and nothing...
September 24th, 2009 04:25 PM
by T. Valko Go to last post
5 163
Column by Alan
Apologies if there is a really obvious answer to this but it is driving me mad! When you use the column() function you get the number of the column (i.e....
December 17th, 2009 07:17 PM
by Teethless mama Go to last post
4 195
CHAR(10) does not create new line in excel 2007 by Alan
I am copying contents from multiple cells into one cell, I would like a new line for each cell content being copied. I use the following forumula and do not...
December 23rd, 2009 07:01 PM
by Rick Rothstein[_2_] Go to last post
4 119
"countifs" convert to formula in XL2002 by Alan
Hi, xl2007 formula "COUNTIFS" as following:- =COUNTIFS('MTD Reach'!K:K,"0",'MTD Reach'!A:A,B12:B277) *Criteria range 1 = 'MTD Reach' (Sales data) *Criteria...
February 11th, 2008 11:01 AM
by Alan Go to last post
2 97
Moveing Data to another Worksheet by Alan
I hope I put this in the correct place. Let's say I have a workbook that contains 2 Worksheets named "Worksheet 1" and "Worksheet 2" In "Worksheet 1" I have...
September 8th, 2005 11:46 PM
by Alan Go to last post
2 87
Using text value in cell as input for another by Alan
Me again ... while I am here ... My spread sheet contains a first column with unique values and the remainded of the colums are referenced in another...
November 26th, 2004 03:38 AM
by Dave Peterson Go to last post
1 193
COUNTIF ON 2 VARIABLES ?? by Alan
Thanks for all the previous assistance... however I have now encountered another couple of problems Again back to my large spreadsheet issues ... I have...
November 26th, 2004 09:10 PM
by Bob Phillips Go to last post
4 112
AUTO HIDE ROWS by Alan
Is there a method/function to auto hide rows dependent on the value of a cell in that row ... Ie cell B3 = 0 ...... hide row ??! Many thanks again Alan
November 27th, 2004 10:13 AM
by Ron de Bruin Go to last post
1 190
Table References by Alan
I have 3 Tables, i.e. T1, T2 and T3 defined as cell ranges with the same number of rows/columns, different cell values. I want the user to select a table,...
February 14th, 2005 04:18 AM
by Tom Ogilvy Go to last post
3 104
Formula or not? by Alan
Hi, Is there a formula to establish whether a cell contains a value or a formula? What I mean is say A1 contained =10+20 so it shows 30 and it contains a...
February 20th, 2005 04:26 PM
by Alan Go to last post
2 106
Evaluating similarity of text strings by Alan
Hi All, I have a data list - roughly 2000 items in all, which are names (people, companies, organisations etc) and an amount they have paid. The data is...
March 30th, 2005 01:35 AM
by Alan Go to last post
6 96
VLOOKUP Help by Alan
I have a Workbook with multiple sheets.... On one sheet I have a unique identifier which provides me with certain information and have acquired another which...
(Multi-page thread 1 2)
April 25th, 2005 02:57 PM
by bj Go to last post
10 148
how can i make a cell always show text in caps by Alan
This code will do it, you need to name the columns as a named range that you want it to apply to, in the this code the ranges are named 'Input' but obviously...
August 13th, 2005 04:32 PM
by JE McGimpsey Go to last post
3 80
Product Formula by Alan
Hi, I have a column of quarterly returns which I wish to calculate longer term returns from. My problem is that the list will continue to expand over time...
December 29th, 2009 04:48 PM
by ryguy7272 Go to last post
1 130
Post New Thread


Display Options
Showing threads 2001 to 2020 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:42 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.