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
Restated question for formula by Vercingetorix.XIII[_2_]
The payments are split into 2- 1 month apart- I need a formula which will add the payments to be made on Nov 1 into a cell for Nov1st - then add the payments...
December 11th, 2008 11:08 PM
by Niek Otten Go to last post
1 91
Solver or not Solver by Marilyn
Hello I use "solver " to calculate a formula. I need to send the woorkshet to different people and they will have to use solver. Here are some of the...
December 11th, 2008 10:40 PM
by Dana DeLouis[_3_] Go to last post
4 136
Automatically changing arrows by Nelson B.
I have a report for executives where I have a big "up" arrow if there was an increase and a big "down" arrow if the amount decreased. Currently I have to...
December 11th, 2008 10:38 PM
by Gord Dibben Go to last post
6 88
how do I create a quick directory of sheets in workbook by Momturbo
I have a workbook with 20-plus worksheets, each of them with the name of a different employee. Is there a quick way to make a directory of all the named...
December 11th, 2008 10:28 PM
by Gord Dibben Go to last post
2 147
excel by Excel
Is there a software that I can use to convert the .spl format into Excel format ? Thanks Cathy
December 11th, 2008 10:20 PM
by David Biddulph Go to last post
1 88
CountIF Function Help!! by Tina STL
I am using the countif to tell me how many times text appears in column. The problem I have is the return seems to be counting down, I need the return to...
December 11th, 2008 10:16 PM
by Tina STL Go to last post
4 111
Iserror help by Jim
Hello, I have the basic is error formula (=IF(ISERROR(AC21),"",AC21)) What I need help with is in cases where the formula is referencing a cell that has 0 or...
December 11th, 2008 10:11 PM
by FinRazel Go to last post
3 105
Double Click on a cell to fill data into a different cell. by ctefft
I am setting up a questionnaire and I would like to set it up so that the answer will fill in automatically after someone double clicks on the answer that...
December 11th, 2008 10:07 PM
by Gord Dibben Go to last post
3 99
Unique Pivot Table Count by Andy
I have a few thousand records. Two of my fields are a unique ID (unique to each row) and customer ID (unique to each customer). Within one pivot table...
December 11th, 2008 10:00 PM
by Debra Dalgleish Go to last post
1 158
Countdown Timer by Robert_NSBG
I created a spreadsheet to score my daughter's basketball games. I need to create a"Game Clock" macro that I can set the amount of time at the start of each...
December 11th, 2008 09:54 PM
by Mike H Go to last post
1 121
Widen merged columns while selected. by Shawnn
I would like to find out how to change the width of a merged cell or column while it is selected and then return it back when another cell is selected. This...
December 11th, 2008 09:51 PM
by Shawnn Go to last post
0 87
How do I capitalize the first letter of multiple cells? by dominic_howden
I'm trying to clean a mailing list (1000+ rows), but the capitalization of the cells containing name, salutation etcetera is variable. How can I ensure that...
December 11th, 2008 09:45 PM
by Adam Birken Go to last post
5 111
Excel 2007 adding page breaks by David L[_3_]
Excel 2007 is putting page breaks on my spreadsheets and I cannot get rid of them. Every cell has a page break above and below. Cannot adjust page scale,...
December 11th, 2008 09:44 PM
by David L[_3_] Go to last post
0 95
Identifying when all values in a range are the same. by MichaelZ
I have a row of user inputted responses (e.g., F20:K20). The possible responses are “None”, “Low”, “Medium”, and “High”. These result in a...
December 11th, 2008 09:42 PM
by MichaelZ Go to last post
7 138
referencing current tab name in formula by excelhurtsme
I am trying to reference the current tab name in a formula. I am trying to get a running total across several different sheets, but here is the catch, those...
December 11th, 2008 09:36 PM
by Bernard Liengme Go to last post
4 124
Displaying Links when opening sheets by Jase
I have to regularly open several workboks at once with most of them linked to many other worksheets. I want to be able to display the links of the workbook...
December 11th, 2008 09:33 PM
by Jase Go to last post
2 105
Convert to Excel format by Excel
Hi ! Do you any kind of software that I can use to convert .spl format into Excel format ? Thanks Cathy
December 11th, 2008 09:09 PM
by Bob I Go to last post
1 90
Last Line of Data by cware
I am using a Pivot Table. On the outside of the table, I have several calculations going on. Two of which involve finding the last line of the data and...
December 11th, 2008 09:02 PM
by Dave Peterson Go to last post
1 91
leading zeros in text format by BigBrook
I receive bulk orders via an Excel spreadsheet, containing many individual orders with reference numbers. The reference numbers may be 7-9 digits long,...
December 11th, 2008 09:00 PM
by Dave Peterson Go to last post
5 413
0 (zero) auto delete by Ben in CA[_2_]
Hi, Is there any way that I can set a cell to automatically empty (delete the 0) if someone enters a zero in the cell? (Preferably with a macro) (It's not...
December 11th, 2008 09:00 PM
by Gary''s Student Go to last post
4 141
Post New Thread


Display Options
Showing threads 29801 to 29820 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 05:20 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.