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
Concatenate formula by Bricky
Hi I'm trying to get a formula using concatenate that will identify numbers in a row 3 (4&5) and returning the name of the column above into one cell....
November 11th, 2009 04:30 AM
by Bricky Go to last post
0 110
"if" formula not working- seems to be formatting by GaiGauci
Hi All I have a formula in Col B =if(G2"99999","StaffType1","StaffType2"),"") Col G has the staff employee numbers in it which if they are a 5 digit number...
November 11th, 2009 04:27 AM
by GaiGauci Go to last post
4 153
Subtotal placement issue by simmerdown
I am running Excel 2003 SP3. When calculating a subtotal on location, then by salesperson, excel is inserting the subtotal for the salesperson after the...
November 11th, 2009 04:27 AM
by GaiGauci Go to last post
2 140
filtering dates in a Pivot Table Report Filter by jsmith
Hi, I have a file with over 25k rows and 100 columns. I also have 15 various pivot tables. In about 6 of these tables I need to filter a date range. The...
November 11th, 2009 04:27 AM
by GaiGauci Go to last post
3 139
How do I build a calendar from an excel table of events/dates? by Schedule Guy[_2_]
I have a list of events in an Excel table with related dates in the adjacent column. I want to automatically populate a calendar so the information is...
November 11th, 2009 04:25 AM
by Schedule Guy[_2_] Go to last post
0 137
Show Pages for Excel 2007 Pivot Tables by Jim Georgia
Where do I find Show Pages on the Excel 2007 Ribbon? In earlier versions of Excel, this feature was extremely useful to automatically create a new Worksheet...
November 11th, 2009 04:25 AM
by Stephane Bourgain Go to last post
5 131
FLOOR FUNCTION by Confused
I am trying to use a floor function to calculate overtime. For every 8 hours worked, our employees get paid .5 of OT. The floor function works up until 136...
November 11th, 2009 04:24 AM
by EricG[_2_] Go to last post
5 162
Special Financing Calculator Help Please by Steve
Looking for a calculator for estimating insurance premium financing payments. Here are my "variables" Premium payment amount = $75,000 Downpayment amount=...
November 11th, 2009 04:24 AM
by Steve Go to last post
4 127
Password for cells and Password for sheet by Emece
I have some cells protected with a password so that they cannot be modified, and I want to add a different password to the sheet. Is this possible? Thanks in...
November 11th, 2009 04:23 AM
by Jim Thomlinson Go to last post
2 105
Pop up formatable positionable message box when hovering over a ce by Melody
Hi, I want to add information text when point to a cell. I need to be able to format the text and color the box as well as position it in the spreadsheet. ...
November 11th, 2009 04:20 AM
by Melody Go to last post
4 142
Can Excel duplicate Access's PivotTable Detail Data feature? by mwoolf
In Access pivottables, when you place a field in the data area, you can specify "Detail Data". This displays the actual data instead of a summary of the...
November 11th, 2009 02:07 AM
by Debra Dalgleish Go to last post
1 143
Pivot Table Calculated field error by Jeff Metcalf
I have a pivot table that As Rows Service Territories As Values Count the number of service calls Sum two columns of data consisting of 1 or 0 depending on...
November 11th, 2009 02:03 AM
by Debra Dalgleish Go to last post
1 126
macro for chart data range extension by mohavv
Hi, I've 12 graphs with 6 lines each. I want to extent the ranges of the lines and labels with 1 column (already extists in data range). Is there a way to...
November 10th, 2009 09:24 PM
by mohavv Go to last post
0 156
extract duplicat values by adeel via OfficeKB.com
i have large amount of data in two sheets with many rows and columns. now I want a formula which could extract duplicat values (matching sheet 1 & sheet 2) and...
November 10th, 2009 08:48 PM
by Bernard Liengme Go to last post
1 158
retaining email addresses by srd0613
When I’m ready to send the excel sheet as the message body, I hit the ‘send to mail recipient’. If this is a sheet that I send out as a message body on...
November 10th, 2009 08:28 PM
by srd0613 Go to last post
0 149
Formula Help by KBrown
I need help with a formula... I have two columns of data and I need to figure out a way to have Excel figure out the third column. The data is being...
November 10th, 2009 07:49 PM
by Jacob Skaria Go to last post
4 153
"GWXL97.XLA could not be found" by 300driver
When I try to run any command from the file menu, such as "save as" or "save" in Excel, I get "GWXL97.XLA could not be found. Check the spelling of the...
November 10th, 2009 07:23 PM
by Dave Peterson Go to last post
1 366
Need Date Formula Help by vegasrenie
This formula is supposed to subtract one day every day. It works perfectly to 30 days, and then on the 31st day, it resets to zero. It needs to go...
November 10th, 2009 07:13 PM
by David Biddulph Go to last post
3 158
Modify excel office online template by Sam
I downloaded an invoice template and one column is too narrow for the numbers I have to write in. I am an experienced user but could not find a way to chage...
November 10th, 2009 06:57 PM
by Gord Dibben Go to last post
3 149
November 10th, 2009 06:55 PM
by Otto Moehrbach[_2_] Go to last post
1 107
Post New Thread


Display Options
Showing threads 10221 to 10240 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:28 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.