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
Pivot Table and Countif Function by Amiram
ID B Month A1 Pass Feb A1 Pass Feb A1 Pass Feb A3 Fail Feb A4 Fail Feb A4 Pass Feb A4 Fail Feb A4 Pass Feb A1 Pass Jan
November 11th, 2003 03:29 PM
by Amiram Go to last post
0 311
excel automatic add-ing by luis
the automatic add-ing stop working. i uninstalled the program and reinstalled again, but did not fix the problem. I used tthe fix and repair option but did...
November 11th, 2003 07:00 PM
by Gord Dibben Go to last post
1 288
manual calculation doc by Sheri
A monthly excel report sent from our corporate office to our remote location is saved by the sender in Manual calculation. With no other excel documents open,...
November 11th, 2003 07:05 PM
by Gord Dibben Go to last post
1 364
Linking workbooks by Fawn
I have 4 workbooks with approximately 12 sheets with the information rolling up into one YTD sheet. What I want to do is to have all 4 of the YTD sheets on a...
November 11th, 2003 09:00 PM
by Harlan Grove Go to last post
1 349
Problem with INDEX function to return top 3 objects and sizes from a list by Roger
SHEET1: Hundreds of entries in no particular order. Note: there are other columns between these fields. This is only an...
November 11th, 2003 09:43 PM
by Aladin Akyurek Go to last post
1 513
Dynamic Range by Brian
I am trying to create a macro and am stuck trying to figure out how to determine my last column. In cell E3 I am using the formula =COUNTIF(E4:??,0). Can I...
November 11th, 2003 09:53 PM
by Aladin Akyurek Go to last post
5 416
Array Function - cell to remain blank by mare
I am a novice on Excel, however, I don't get easy projects. I have a spreadsheet where D6:D15 have values. In cell D17 is the Total, which is an average of...
November 11th, 2003 09:56 PM
by Jon Barchenger[MS] Go to last post
1 189
Howto: relative & absolute cell references by Eric Tubbs
Greetings, I hope my first posting has found the correct group to ask my question. I made the mistake of referencing the main worksheet to many other...
November 11th, 2003 10:36 PM
by Kevin Stecyk Go to last post
3 527
using cell background color as basis for formula by ken
Anyone know of a way to use a background color in a function such as an IF statement? I have a spreadsheet keeping track of items where I use yellow and...
November 11th, 2003 10:50 PM
by ken Go to last post
2 350
Assign Macro to AxtiveX objects by Roger Trewenack
Just started playing with ActiveX Command Buttons, with a view to adding macro code to them to do simple functions within Excel (Versions 2000 & XP). According...
November 11th, 2003 11:33 PM
by Chip Pearson Go to last post
1 289
HLookup by Steve
I am trying to build a template and one of the formulas that I have to use is HLookup. Is there a way to write this formula if I don't know what the last row...
November 11th, 2003 11:35 PM
by Peo Sjoblom Go to last post
4 146
Sorting based on a drop down list by Randall Roberts
how can i have excel sort a work sheet based on a selection from a drop down list The selections in the list would be the same as the headers on the sheet
November 11th, 2003 11:59 PM
by Don Guillett Go to last post
1 542
finding quarter date information for accounting by Sean Atchison
Anyone know of a function example on a worksheet that will return the quarter (1-4) and the month in the quarter (1-3)?
November 12th, 2003 12:02 AM
by Harlan Grove Go to last post
4 410
Copy Unique Records ... Formula? by Ken
I know I can use "Advanced Filter" to copy Unique Records to another location of spread sheet. Question is ... can this be achieved with a formula? Something...
November 12th, 2003 12:18 AM
by Harlan Grove Go to last post
5 542
Autofilter and zero's in blank field questions. by Max
Just some thoughts on your 2nd Q ... In Sheet2: Try Tool Options View tab Uncheck 'Zero values' OK -- hth Max -----------------------------------------
November 12th, 2003 01:20 AM
by Max Go to last post
2 478
Relative Cell Reference when recording macros by Danadita
Once upon a time, I would get a little box when recording macros and I could click on it to tell it "absolute" or "relative" but now it doesn't show up and I...
November 12th, 2003 02:07 AM
by Gord Dibben Go to last post
2 228
roots by Murray
Can Excel calculate the root of a number and if so, how please? For example, what is the 11th root of 500? Thanks Murray
November 12th, 2003 06:24 AM
by Kevin Stecyk Go to last post
1 140
letter and numbers substitute by Paul
"ibo" wrote in message ... Hi there I have a cell with letters and numbers. Like...
November 12th, 2003 08:44 AM
by jale Go to last post
4 492
auto SUM a FILTERED List by davidbrowne17
When using the AUTO filter, is there a forumular to SUM the filtered list ( i.e Displayed items) I have used the SUM fuction, this will add up the current...
November 12th, 2003 12:52 PM
by Stephen Bye Go to last post
1 360
A B C D column names and 1 2 3 4 by Brendan
Can I hide A B C D column names and 1 2 3 4 rows so I can only see my workspace
November 12th, 2003 12:53 PM
by Stephen Bye Go to last post
3 299
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 06:56 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.