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
Linking Daily Workbooks by General Specific
I receive daily workbooks from field crews. I would like to compile daily billing one bi-weekly workbook. I want to link the bi-weekly summary to the daily...
September 24th, 2008 05:34 PM
by Ron de Bruin Go to last post
1 159
Text to Columns for Multiple Worksheets by Michael
Hi Folks - Looks like the Text to Columns feature is unavailable when grouping worksheets. Is there a workaround? Thanks. Michael
September 24th, 2008 05:29 PM
by Peo Sjoblom[_2_] Go to last post
2 182
Convert Date to Text by Michael
Hi Folks - I have a date in the following format: 2008-09-24. Is there a way to convert this to text so it displays as 2008-09-24? Thanks. Michael
September 24th, 2008 05:28 PM
by Peo Sjoblom[_2_] Go to last post
2 138
Linking by TOS
I have a spreadsheet with multiple worksheets, one of the worksheets, recently added, I linked to the main worksheet, so each time I add info it updates it...
September 24th, 2008 04:57 PM
by TOS Go to last post
0 137
Value Field Settings for Pivot tables by Eden397
I want to have the default of my values I place into my pivot to be a SUM rather than a count at all times in my job. Can I change my pivots to always sum...
September 24th, 2008 04:48 PM
by Eden397 Go to last post
0 155
Filter Customize date by Achim
I created a table with "date" and "name" being some of its columns. Unfortunetly when I filter it by name and want to customize a filter for the dates...
September 24th, 2008 04:35 PM
by Achim Go to last post
3 151
Loan Period Calculator Sheet by garber2007
I have a loan with my parents and we are trying to see how long it will take to pay back the loan. I see a lot of templates that have you insert the amount...
September 24th, 2008 04:17 PM
by ryguy7272 Go to last post
3 221
Compute using information from two different worksheets ! by Shefali
Hi, I have one worksheet with total no. of prints, month and building wise, and I have another worksheet with head count also month and building wise. I need...
September 24th, 2008 04:16 PM
by ryguy7272 Go to last post
1 184
Special editing by Mister Ed
When using Excel 2003, I could fill blank cells in a column with contents from a preceeding cell using the Edit menu. Specifically, after selecting the...
September 24th, 2008 04:15 PM
by Dave Peterson Go to last post
1 140
Comparing more than two by Vern
I have a spreadsheet that tracks Date, Salesman and Sale Amount in separate columns with information over a year. How do I do an analysis of monthly sales...
September 24th, 2008 04:03 PM
by Vern Go to last post
4 165
Indirect function – relative column copy/paste by Gary T
I’m using INDIRECT to allow me to refer to a previous month’s cells (thanks to helpful answers to another query I posted on these forums). The INDIRECT...
September 24th, 2008 02:52 PM
by Glenn[_6_] Go to last post
1 140
Changing date format by PaulinaDi
Month by month I have to work a spreadsheet containing values that should be in dd/mm/yyyy format but as I get this page from an internal program, I use to...
September 24th, 2008 02:30 PM
by Max Go to last post
3 128
how do I sort a spreadsheet of daily events into weekly totals? by polly
I have a worksheet containing figures reported on a workdate daily basis; I wish to split it into totals by a weekly basis; can I create a formula to sort...
September 24th, 2008 01:34 PM
by Dave Go to last post
1 134
HELP Please - Formula problem by Form Option Buttons[_2_]
I'm trying to create something like this with option buttons under the ratings and totals at the bottom. I can't figure out how to get the option buttons to...
September 24th, 2008 01:19 PM
by Dave Peterson Go to last post
1 250
Displaying Pivot Table Results by Popey
Hi Using Excel 2007: I have a pivot table that produces results from a list of clients entered into a database each time a client uses my services. The...
September 24th, 2008 01:17 PM
by Bam Go to last post
1 162
How generate new list in another worksheet from existing list? by NSF
I have a list in sheet 1 covering several colums, with a lot of parameters. Lets say I have AA, BB, CC as parameters used in colum A. I would like to sort in...
September 24th, 2008 01:08 PM
by NSF Go to last post
0 143
Calculating hours by Marty
I am working on a spreadsheet that will calculate the hours worked by a staff member. A1 has the start time of 16:00 A2 has a finish time of 01:30 the next...
September 24th, 2008 10:56 AM
by David Biddulph Go to last post
5 146
Circular References by Alexey[_2_]
Hi When i open a worksheet I am getting a Circular reference error The reference is on $s$6 and the forumula is: =IF(ISERROR(S6),0,SUM(R6/Q6)) Q6 contains the...
September 24th, 2008 10:33 AM
by Mike H Go to last post
4 161
Zenith Class Open El Primero Chronograph Mens Watch03.0510.4021.21.C492 by [email protected]
Zenith Class Open El Primero Chronograph Mens Watch 03.0510.4021.21.C492 Discount Watches Site : http://www.watchespurchase.com/ Zenith Class Open El Primero...
September 24th, 2008 10:31 AM
by Stefi Go to last post
1 164
FORMULA HELP ! ! by GA85
I need a formula to do the following: If in column 3, a cell says "cash", I need that entire row that contains "cash" in column 3 to be transferred to...
September 24th, 2008 09:57 AM
by Pete_UK Go to last post
1 132
Post New Thread


Display Options
Showing threads 19961 to 19980 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 09:39 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.