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
Count function by
I'm trying to count a column with some kind of criteria. Count if cell contains EL or HC or MM etc. Can it be done with the countif functions? Appreciate any...
November 20th, 2003 07:16 PM
by Jason Morin Go to last post
2 72
Simplifying my previous Request for Assistance by
I suspect that (since I didn't get any response on my previous request for assistance) I may need to approach this in stages ... Assuming that Information...
July 6th, 2006 02:06 PM
by Go to last post
1 59
Running Macros by
I have the following Macro (which I need to run on approximately 200 different workbooks) -- what is the BEST way to achieve this? Should I use a Function...
July 6th, 2006 03:42 PM
by Go to last post
0 41
Problems saving a worksheet with links to a New Location by
Does anyone know how I can resolve this issue ... I have a directory which contains 129 worksheets which have links to external data (in a Master Spreadsheet)...
July 7th, 2006 05:09 PM
by Dave Peterson Go to last post
1 57
Depreciation Formula by
I don't expect to get any bites on this one, but, "Hey, it's Friday -- it could happen!" Just got this one dropped on my lap -- we have a spreadsheet with...
July 9th, 2006 11:53 PM
by Fred Smith Go to last post
1 56
want a list of selectable names on my worksheet by
Hi You could use Data/Validation/List. Prepare your list in another sheet and point your validation at the list. Hope this helps. Andy. "Boze"...
August 7th, 2006 08:49 PM
by Boze Go to last post
4 53
Using Excel 2000 VBA Application on Excel 2003 by
I have a VBA application written in Excel 2000. The appl contains several forms and custom menus. I tried running the appl on Excel 2003, but got errors. (I...
August 8th, 2006 02:36 AM
by Go to last post
0 50
Running Excel 2000 VBA Application on Excel 2003 by
I have a VBA application written in Excel 2000. Running the appl on Excel 2003 generated errors, and the appl would not run on the Excel 2003 PC. (I can't...
August 8th, 2006 06:04 PM
by Go to last post
0 47
Making cell reference absolute makes cell format text by
Hi Weird one here! I've been browsing the Excel forums for years and not seen this. One sheet is called Special One Off Deals, and in cell C2 is Aug 06 -...
September 22nd, 2006 04:47 PM
by Go to last post
2 44
how can I split one cell's data into two cells? by
I am using Excel as a database, and have a column with cells with a person's name (text) in it...e.g., John Smith. NOW, after the fact, I wish to have...
May 15th, 2006 01:19 AM
by Go to last post
3 66
Number of items in a colum by
Hei, I would like to found out how many same items are in one Excel column. If the column has the values 1 3 4 2 5 6 7 9 3 6 7 8 3 the funktion should pic up...
May 9th, 2006 01:56 PM
by Ardus Petus Go to last post
1 53
Cannot check autofilter - Grey'd out by
I am working on a large spread sheet, 450 rows x 26 columns, and I want to use the autofilter option to sort items in the list however, the autofilter box is...
January 9th, 2004 03:58 PM
by [email protected] Go to last post
2 259
PV & NPV discrepancy? -showing different results for same entries by
Calculating the Present Value of $120,000, $175,000 $195,000 @5% (as per exercise) gives: $441,464.20 as per detailed example below. Year1 Year2 ...
(Multi-page thread 1 2)
January 10th, 2004 01:51 AM
by Norman Harker Go to last post
11 158
array formula by
I have an array formula summing only posotive numbers in a single column but in differant rows. I'm not able to use the : because it sums all info inbetween...
April 8th, 2004 04:06 PM
by Bob Umlas, Excel MVP Go to last post
7 99
paint cells with highest numbers by
How do I get excel to paint the cells with say the 14 highest numbers i a defined area of the sheet?
May 26th, 2004 02:56 PM
by Frank Kabel Go to last post
2 77
linking headers and footers to multilple worksheets by
Does anyone know how to link a custom header and/or footer from one worksheet to another in excel?
June 21st, 2004 10:50 PM
by Ann Scharpf Go to last post
1 56
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 59
how to switch a #N/A value into 0 by
I used the vlookup function to get pricing from a=20 database which is multiplied by a specific volume. When I=20 have no pricing in the database for a product...
July 22nd, 2004 10:01 PM
by JE McGimpsey Go to last post
1 45
use "button" to make calculation ignore a cell by
How can I create a macro "button" over a series of columns that will cause a formula in another part of the sheet to ignore the value that the...
March 21st, 2006 04:54 PM
by Go to last post
5 58
Extract email addresses by
Hi I have been looking for an answer to this for weeks - and I admit defeat! I have a column of data with email addresses in there, somewhere. Each email is...
December 15th, 2006 09:05 PM
by RichardSchollar Go to last post
9 55
Post New Thread

Display Options
Showing threads 41 to 60 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 12:27 AM.

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