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 : General Discussion Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Excel cannot auto start external application by Jason Falzon[_2_]
I have an excel file that with the copy/paste special/link features I managed to insert a 3d scatter graph in excel using an external application called...
March 25th, 2010 09:57 AM
by Jason Falzon[_2_] Go to last post
0 152
Collate Worksheets into single workbook by jw4774
I have a number of a folder containing a number of workbooks each of which contains a number of worksheets. I am trying to combine just one worksheet from...
March 25th, 2010 09:30 AM
by jw4774 Go to last post
3 167
Merge contents of two worksheets by Grey Old Man[_2_]
I am a novice writing an Excel 2002 template. I import external data from sources A and B into sheets 1 and 2. There are no duplicate rows. I have named...
March 25th, 2010 08:31 AM
by jeya Go to last post
1 200
about screenupdating by baha
Hello, I have a long code which is a kind of poker simulation that gives you simple random poker hand and calculates the odds.If I disable screenupdate some of...
March 25th, 2010 07:16 AM
by baha Go to last post
0 117
Ctrl+E to center by Thomas S.
MS Word and PowerPoint has had the "Ctrl+E to center" function for years, and I am really hoping this will be extended to MS Excel soon. Today, typing the...
March 25th, 2010 07:05 AM
by Gary Keramidas[_4_] Go to last post
2 147
Formula copying error by KKGV
I've entered a vlookup formula and when I copy it to another cell, sometimes it copies the formula correctly into the other cells and comes up with the...
March 25th, 2010 06:31 AM
by Max Go to last post
3 161
look up question by G
Hi , I have 2 columns - column A containes dates , coumn B contains activieties ( meetings , phone calls , emails ) .. I'd like to have a formula that...
March 25th, 2010 05:55 AM
by Jacob Skaria Go to last post
1 144
Calculate times between dates and times in Excel by Helio
How can I calculate the time in minutes between 2 events with format (date,hour) or format date in a cell and time in another cell, without weekends and...
March 25th, 2010 05:29 AM
by Fred Smith[_4_] Go to last post
1 160
How to find errors in documents by Pnoahjones
when you have a series of data and you have a space or error in your numbers when you are using functions and formulas. how do you find where there error is...
March 25th, 2010 05:29 AM
by macropod[_2_] Go to last post
1 137
Pivot Table Default Setting by Registrar
Can you change the default setting in Pivot Table? For Example if everytime I do a pivot table I do not want it to give me subtotals can I default it that...
March 25th, 2010 05:14 AM
by Matt S Go to last post
1 193
Hide unused rows and columns by kyleb
In excel 2007 i would like to hide All rows and columns except for the few i have data entered into. Any advice? Thanks
March 25th, 2010 03:24 AM
by David Biddulph Go to last post
1 277
Scrolling from a created gridline in Excel by Roy[_2_]
Hello group I am not quite familair with some of excels manipulative prowess... I noticed that its possible to scroll up or down from a gridline ...say by...
March 25th, 2010 02:55 AM
by Roy[_2_] Go to last post
2 185
Formula to count multiple various inputs and create a summary by Kelstar
Hi, I've got a spreadsheet which has multiple rows and collums of data that I log issues in and I need to find a way to produce a summary. So, each row...
March 25th, 2010 02:13 AM
by Kelstar Go to last post
2 189
top ten ranking by liem
I have 20 category in each category I have random 1 to 500 items with sales units and Sales $ metric for each items. How can filter and rank it will show up...
March 25th, 2010 02:12 AM
by liem Go to last post
0 136
If(AND formula by Wildwood
Please help......this formula is returning a Value error.......what is wrong?...
March 25th, 2010 12:52 AM
by Joe User[_2_] Go to last post
9 163
Insert Name Define by Chris Johnson
Why does this work for a Name definition of a range? =Sheet1!$A$3:INDEX(DataforCharts!$A:$A,MATCH(9.99999E+307,DataforCharts!$A:$A)) It works but I can't...
March 25th, 2010 12:34 AM
by Dave Peterson Go to last post
1 149
How to automatically paste cells from one sheet to another sheet? by Jenni
I'm working on an Expenditure file. 12 sheets are for the months of the year and 10 other sheets are for the categories of various expenses. ie: Medical...
March 25th, 2010 12:16 AM
by kyleb Go to last post
1 123
include rounding in a formula by KrispyData
i have the following: A B C 1 327.2 3033.56 0.107860072 column C1 is simply A1/B1 . Is there a way that i can include in my formula to round the results...
March 25th, 2010 12:01 AM
by kyleb Go to last post
2 108
Name scope within a workbook by Christer
I have 3 different workbooks open. A sheet within one workbook contains a number of named Ranges. When I copy the sheet into one of the other workbooks the...
March 24th, 2010 11:32 PM
by Christer Go to last post
0 99
Find Command by Mike H.
If I do a "find" (Ctrl-F), I wish to find the value 1500 but the cell that contains 1500 contains the formula A1*B1 and A1=750 and B1=2. How can I find...
March 24th, 2010 11:10 PM
by Mike H. Go to last post
8 192
Post New Thread


Display Options
Showing threads 3281 to 3300 of 139764
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 11:30 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.