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
Question: About using COUNTIF in a filtered list by acw
Scott Send a copy of the workbook to . I'll have a look. Tony ----- Scott wrote: ----- Tony,
February 11th, 2004 03:32 AM
by Debra Dalgleish Go to last post
1 402
Extract Text to the Left and Right of a Delimiter such as _ (the underscore). by acw
Hi This is pretty messy but should give you what you want. I started off with the text for something else this_text then something else in A1 and the...
February 19th, 2004 07:32 AM
by acw Go to last post
0 256
How to use Vlookup with web query data (In HTML format) by acxes
I want to search a name (Primary Key) and want relative data from two sheets in another sheet. I using Vlookup but its giving me #N/A value, is that because...
December 6th, 2007 03:01 PM
by Don Guillett Go to last post
1 110
find all combinations of cells that add up to certain number by AD
Hi there, I work in accounting and we're trying to tie numbers very often. I would like to know of a possible function or code that can output all...
November 17th, 2005 08:50 PM
by Duke Carey Go to last post
1 221
SUM COUNTIF problem by AD Carvajal
In the following spreadsheet, I need to count the number of times "y" appears in the Guest column when B appears in the Site column. Is there any way to do...
August 3rd, 2008 06:23 AM
by T. Valko Go to last post
1 123
incorrect date by ad place
As of yesterday, 3/16/04, when you format a cell in Excel for the date, the date is not correct...I enter 031704 and the date appears as October 19, 1986. What...
(Multi-page thread 1 2)
March 17th, 2004 10:50 PM
by Norman Harker Go to last post
13 490
Fast Fourier Transform by Ad Pronk
Dear Madam/Sir, I have a simple question about the use of the Fast Fourier Transform option in the Data Analysis package. 1. After the transform of a...
May 12th, 2005 11:38 AM
by Ad Pronk Go to last post
0 97
Formula error by AD108
I am trying to reference a cell offset from another cell in the sheet I am working on. The formula below is generating an error. The named range "SUMRNGE" is...
December 11th, 2006 05:45 PM
by PapaDos Go to last post
4 68
Number of weeks past in current qtr by AD108
Hello, I need to write a formula that returns the number of weeks already past, in the current quarter. The value returned should include a partial week...
December 4th, 2006 02:17 PM
by AD108 Go to last post
2 59
Make Function ignore 0 and error values by AD108
I am trying to make the average function ignore 0's and errors. The following array formula works to ignore the 0's, but I got stuck trying to make it ignore...
November 4th, 2006 08:03 PM
by AD108 Go to last post
3 65
Look up based on Column and Row headings by AD108
Hello, I am trying to write a "look up" that will return the cell value where the row and column headings in the range match the row and column headings...
August 9th, 2006 07:42 PM
by RagDyeR Go to last post
4 73
strange error by AD108
I have the following formula in column "I". I have code that puts a range of values in to column "G". The values must be pasted as "Values" as the source...
August 9th, 2006 09:22 AM
by Max Go to last post
7 97
Activate the top of sheet by AD108
I need to find a way to make the top of each sheet in a workbook visible after my code runs. I tried "select" and "activate" but when you select the sheet,...
July 30th, 2006 05:27 PM
by Gord Dibben Go to last post
2 52
YEAR MONTH DAYS COUNTER by ad2ad79
Hi, I have a sheet in which I want to count the year then month and then days for employee. i.e Name Date of joining Date of leaving Absent Total JOHN ...
June 14th, 2009 02:42 PM
by Don Guillett Go to last post
8 211
YEAR MONTH DAYS COUNTER by ad2ad79
Hi, I have a sheet in which I want to count the year then month and then days for employee. i.e Name Date of joining Date of leaving Absent Total JOHN ...
June 13th, 2009 04:28 PM
by Shane Devenshire[_3_] Go to last post
2 134
Problem in time calculation with specified number by ad2ad79
Hi, I wana calculate the difference between two times and then the result should be multiply with specific number, which user defines manually. For...
June 28th, 2009 10:41 PM
by David Biddulph Go to last post
1 80
How do I highlight a column depending on other column value? by Ada
I'm working on a sales report and I want to highlight the names of the Reps which sales for the last 3 months average period are grater or equal to $16,000. ...
July 12th, 2006 05:49 PM
by CLR Go to last post
2 73
Data Validation in Excel 2007 - Input Message by ADagenais
Is there a way to import informaiton into the body of the Input Message? What I want to accomplish is to have a list of employee ID's plus corresponding name...
December 8th, 2008 05:30 PM
by ADagenais Go to last post
0 91
Count IF by Adam
Hey Guys, i Want to use COUNTIF function liek this.. (Range, Criteria, when you use count if, it will just let you do one if statement, (range,...
April 13th, 2009 10:55 PM
by Dave Peterson Go to last post
1 60
im trying to create a date formula by adam
I am trying to set up a cell that will auto load the currant date. I really would apreciate it if someone could help me
December 11th, 2008 05:40 AM
by T. Valko Go to last post
1 95
Post New Thread


Display Options
Showing threads 1141 to 1160 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 06: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.