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
Symbols or pictures in formulas by
Is there any way that I can make a picture or symbol the result of a formula? If so, how?
October 16th, 2003 10:55 AM
by Chip Pearson Go to last post
1 143
Subtotals - Copy the Subtotals into a new sheet by
Hi, Using subtotals to summarise, say, a 1000 rows of data into 50 rows of subtotals. I want to take those 50 rows into another sheet and then work on just...
April 15th, 2004 04:02 AM
by Dave Peterson Go to last post
2 145
Placing the "&" symbol in an excel header by
Since the "&" symbol is used as a programming tool in an excel header how can I tell excel that it is just a piece of text that I want to show on my header...
April 30th, 2004 06:26 PM
by Gord Dibben Go to last post
6 345
AVERAGE of row gives no result by
cells are formatted as text? -----Original Message----- This problem MUST have a really simple answer; I just don't know what it is... When I attempt to...
(Multi-page thread 1 2)
May 3rd, 2004 07:13 PM
by Ron Rosenfeld Go to last post
12 359
Return last value in a range. by
My range is from A1:A20. The range could have a possible of 20 numbers, some number may be exactly the same. Numbers will be entered starting at A1. I am...
June 6th, 2004 06:06 AM
by Aladin Akyurek Go to last post
2 184
Need simple macro by
Hi All In Excel 2002 Column A cells 1 to 20 has data in them, Column B1 has data in it, I would like to have a macro that would copy the data from B1 to all...
June 6th, 2004 06:04 PM
by Gord Dibben Go to last post
3 104
Help by
I am trying to program a worksheet to make the cells turn red when the row exceeds a $2,500 amount, but it has to be able to do it after a a specific date like...
June 24th, 2004 02:41 PM
by Norman Harker Go to last post
1 97
Excel hyperlink to jpg always opens with I-net Exployer by
I need to open a .jpg file pointed to by a hyperlink in a cell, with an application that will allow zooming. I have set the jpg to always open with "Paint" or...
July 18th, 2004 03:08 AM
by Go to last post
0 239
Excel formula giving #Value! error by
I have a spreadsheet that has cells calculated from other workbooks. Some cells are updated while others give me an error of #Value!. The error goes away...
September 16th, 2004 09:14 AM
by vinaya nayak Go to last post
9 153
creating a list from an existing list by
hi! is there a formula that can create a list from an existing list for some specific creteria. so kind of an iteration. so say in one sheet i have list with...
March 17th, 2004 03:00 PM
by Go to last post
4 202
Compare a cell to a range of cells by
Could someone help me? What I need is to compare one cell with 35 other static cells. If the data in the main cell is the same as any of the other cells it...
February 17th, 2004 10:43 AM
by Go to last post
2 539
delete alternate columns... by
Need a macro/function that'll delete every other column. THX Scottie
November 17th, 2003 03:39 AM
by Scottie Go to last post
5 123
Number formatting by
Can anyone tell me how to enter 25 and have it appear in the cell as 25,000,000? I have only been able to get it to go out to 25,000 (using a custom fomatting...
March 31st, 2004 05:41 PM
by Frank Kabel Go to last post
2 97
HAVE VLOOKUP RETURN 0 OR BLANK INSTEAD OF #N/a by
how do i get the vlookup formula to return 0 or return nothing instead of #n/a. i know it has something to do with a vlookup formula nested in an...
January 21st, 2004 05:27 AM
by Laura Cook Go to last post
9 379
absolute refernces - range of cells by
I am trying to find an easy way to turn a range of cells from relative references to absolute references without going into each cell and hitting F4. Any...
December 1st, 2003 09:57 PM
by Go to last post
2 171
finding the date in a sheet by
First, Name your data range B2:H5202 as DATA Then, insert the formula =Today() in an unused cell and name that cell TODAY Switch to VBA and insert a module...
December 2nd, 2003 10:20 PM
by Dale Hymel Go to last post
1 163
Formula to combine cells (A challenge!) by
Hi, tried my best to find the answer through the HELP menu and the knowlege base...but unsucessfull. I have an expense tracking Excel file, with worksheets...
January 12th, 2004 02:59 AM
by Norman Harker Go to last post
4 105
error by
Can you tell me what program that was written for? The one with the #AND#? Thanks, CJ
January 20th, 2004 09:04 AM
by Harlan Grove Go to last post
1 102
Calculating next due date by
Hi! You can try: =IF(A139,lastphysicaldate+730,lastphysicaldate+1095) where A1 is the age. (730 and 1095 are two and three years in days, respectively....
February 4th, 2004 04:13 AM
by Ron Rosenfeld Go to last post
1 316
excel workbook acting weird by
I have an excel workbook that I converted from text. When I create formula in a cell (A1*2) it just displays the formula and not the result. I checked the...
September 16th, 2004 03:10 PM
by Go to last post
6 255
Post New Thread


Display Options
Showing threads 201 to 220 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:39 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.