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
TROUBLESHOOTING VLOOKUP - PASTE NEW VALUES by Charlie Marcous
I have a workbook where column "I" looks up the value in "J" in another worksheet and returns a correct value for column "I" which works for 400+ rows just...
September 17th, 2003 11:36 PM
by L. Howard Kittle Go to last post
1 713
Changing A1 to $A$1..... by 43fan
Is there any way to change a set of cells all at one time? The entire equation? I'm copying cells from one area in the worksheet to another, and I don't want...
September 17th, 2003 11:31 PM
by jr Go to last post
3 297
Split Combined Name by dlaw
Cell A contains a name in the format 'first initial last'. I want to create cells from this: 'first' 'initial' and 'last'. Are there formulas for the 3 cells...
September 17th, 2003 11:14 PM
by mr Go to last post
1 433
This directed to John Wilson/or anyone else by Radio848
Hi Guys & Gals: John provided me with the enclosed macro, (I have made modifications, so the problem isn't his fault) Problem: I can only get the enclosed to...
September 17th, 2003 11:09 PM
by Radio848 Go to last post
6 389
Formula Help by SFrick
In row 5 i have text, positve and negative numbers. I need a formula that will return 1 when the cell above in row 5 is positive and 0 when it is negative or...
September 17th, 2003 11:06 PM
by Harlan Grove Go to last post
1 257
revision number of excel worksheet.. by PhantomSteve
Is there any way I can get a cell to show the revision number of the current document (ie how many times it has been saved)? In Word, this is done by...
September 17th, 2003 10:58 PM
by Andy Wiggins Go to last post
1 399
macro - hide rows by Will
I will try this again but I do not understand all the lingo so please lead me. Cells A2:A60 contain formulas that return a result of either "" or a number....
September 17th, 2003 10:18 PM
by Will Go to last post
3 441
Worksheets by Walter Payne
My worksheet is long. How do I divide it and still have the information linked to the first page.
September 17th, 2003 10:06 PM
by Walter Payne Go to last post
0 236
Remove Spaces by Bryant Caldwell
How can I use a function to remove spaces from a string. Before Smith , Bob After Smith,Bob Thanks,
September 17th, 2003 10:05 PM
by Lynnus Go to last post
3 428
Copy subtotals by Erin Paulin
You just saved me a TON of work!! Thanks for the very helpful post! Erin -----Original Message----- If this has to be done often, there is an icon which...
September 17th, 2003 09:50 PM
by RagDyer Go to last post
1 679
Spreadsheet play file then close by Brenda
I need to create a workbook that will play a .wav file then automatically close. Is there anyway to do this without having "Enable Macros" dialog box pop up...
September 17th, 2003 09:43 PM
by John Wilson Go to last post
2 332
Linking by Dawn
When doing a link to another program, borders are missing. Any way to fix this.
September 17th, 2003 09:33 PM
by Dawn Go to last post
0 263
Custom Template Worksheet Location by brohar
I cannot for the life of me get my custom template worksheet to show up in the same location as the default xlt files. My PC is a company machine but my help...
September 17th, 2003 09:27 PM
by Radio848 Go to last post
3 499
trendline equations are incorrect by Fred
I charted a set of coordinates. The polynomial equation fit extremely well (r square = 0.99) Unless I'm doing something wrong, (and I don't think I am; I had...
September 17th, 2003 09:21 PM
by Michael R Middleton Go to last post
3 438
Pooled regression and dummy variables by Kev Summersgill
I'm a bit of a novice with excel. I have a dataset of national ststistics which only has a few years so I can't run a time series regression with any...
September 17th, 2003 09:16 PM
by Michael R Middleton Go to last post
1 697
Autofill formulas b/t various worksheets by lbenson
Hello- I have a workbook w/ 25 worksheets. I need to sum the same cell from each worksheet and put it on a separate summary worksheet. I tried to use the...
September 17th, 2003 09:15 PM
by RagDyer Go to last post
3 474
Data Validation by dinna
can anyone help me !!!! I am trying to create a drop down list in excel with data from another tab. Is this possible, if so how can I do...
September 17th, 2003 09:13 PM
by Debra Dalgleish Go to last post
1 288
unhiding Column A - help! by Phil
I've run into an odd problem. I did a Hide on Column A and B. Excel won't let me unhide a column unless I highlight the columns on BOTH sides of it. I have...
September 17th, 2003 09:05 PM
by Don Guillett Go to last post
1 310
Excel database query by Jean
I am using Office 97. I recently moved an access database from one network drive to another. I have an excel database query to that database that no...
September 17th, 2003 09:03 PM
by Dave Go to last post
1 383
Spherical Coordinates by Keith Ingstrup
Given: Radius, inclination(in degrees) and azimuth(in degrees). Can excel calculate P(x,y,z)
September 17th, 2003 08:57 PM
by Harlan Grove Go to last post
1 347
Post New Thread


Display Options
Showing threads 87581 to 87600 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:17 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.