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
conditional formulas by DJK
I am trying to track data by using a reference in a separate column. For example, If cell A1="Victor" I want to deduct the data assigned to him in cell B1...
May 14th, 2009 12:57 AM
by Simon Lloyd[_247_] Go to last post
2 207
Goal Area by wcurtis
How do I add an area to a 2007 chart that shows the goals we are trying to acheive? I have a column chart with twelve months and need to have a horizontal...
May 14th, 2009 12:53 AM
by Herbert Seidenberg Go to last post
2 188
yearfrac sometimes does not work by StevenJJ
I am using Excel 2003. yearfrac sometimes displays an error message. Sometimes restarting excel the function works properly but other times I have to restart...
May 14th, 2009 12:53 AM
by StevenJJ Go to last post
0 180
Sum with IF and IF/Where by Marco
Hi. I need to sum in excel some values where one of the criterias is the Employee number and the other is if the Date column is equal or bigger the is last...
May 14th, 2009 12:17 AM
by smartin Go to last post
1 201
need a vehicle loan amortization by roseakatina
iI +-need a vehicle loan amortization template that I can input the actually date paymts are received. The template that are provided amortizes the loan as...
May 14th, 2009 12:15 AM
by MyVeryOwnSelf[_2_] Go to last post
3 163
Excel Number Format Question by snolte
How do you keep the zero in front of a number when the cell is formatted as a number(example 01423)? This needs to stay formated as a number for importing...
May 13th, 2009 11:56 PM
by Dave Peterson Go to last post
1 161
ActiveX ToggleButton Reset by John
I have a sheet with several hundred ActiveX Toggle buttons. After running some code, I need to reset them all so their value = False. Is there a way to do...
May 13th, 2009 11:27 PM
by Chip Pearson Go to last post
2 184
calculating dates by future spreadsheet master
I'm wondering if I am able to calculate a date based on two different cells. A1 is my actual start date 6/28/2006 C1 is the current date (ex 5/13/2009) B1- I...
May 13th, 2009 11:27 PM
by smartin Go to last post
3 184
May 13th, 2009 11:17 PM
by Bernard Liengme[_2_] Go to last post
1 345
lookup a value across 15 rows by NotanExcelGuru
Here is my problem - The need to look a certain value say 'desktop' across 15 columns ( 1 row) and if it is present in any one cell, in the 16th column I...
May 13th, 2009 11:09 PM
by T. Valko Go to last post
2 220
Design Mode button by rodlmiller
My coworker and I share a macro-enabled file with some command buttons linked to macros that sorts a column according to different criteria. It works fine on...
May 13th, 2009 10:33 PM
by Dave Peterson Go to last post
1 166
Pivot Tables by Janet
Hi - can someone please tell me how to get the data i drag from the pivot table field list to the values field to line up underneath each other instead of...
May 13th, 2009 10:32 PM
by Roger Govier[_3_] Go to last post
1 167
Odd Remove Hyperlink Behavior by Bob
Hi, I am trying to figure out why sometimes when I select multiple hyperlinks I can right click and get the Remove Hyperlink command, but for other...
May 13th, 2009 10:28 PM
by Bob Go to last post
0 211
Formula Question by John
Is there a formula that gives you the number of business days in a month (mon-Fri) I have a date in a column A , and I would give to write a formula in...
May 13th, 2009 10:20 PM
by John Go to last post
6 162
How to increment a cell reference in a row by Mike
I have a row of cells. The first cell in the row is ='05.09'!M7. I need the second cell in the same row to be incremented by 7 ex: ='05.09'!M14 and the...
May 13th, 2009 10:04 PM
by Mike Go to last post
6 176
Reformat Row to Column by Fellow Wanderer
Is there an easy way to quickly change data that is in a row to a column or vice versa? Example: Jan Feb Mar convert to: Jan Feb Mar
May 13th, 2009 09:54 PM
by Fellow Wanderer Go to last post
1 189
I can't get groove off my system, please help! by PinkieRoze
Hi! My ex downloaded office groove before we split, and now, I can't get it off my system! (Yikes) I don't speak to him and I have no idea what email he used...
May 13th, 2009 09:51 PM
by PinkieRoze Go to last post
2 243
sankey diagrams in office by IKI
looking for ways of making sankey diagrams using excel, powerpoint or visio needs to be simple preference for excel
May 13th, 2009 09:34 PM
by Jon Peltier Go to last post
1 219
Scrolling in drop down menu by Marco B
Is there a way to allow scrolling with the mouse in drop down menus created. I have a drop down menu that has a lot of options and it would be great to be...
May 13th, 2009 09:22 PM
by Marco B Go to last post
0 182
Importing from Peoplesoft by Louisq
Dear Colleagues, I am importing a file from Peoplesoft into Excel 2003. There is a green triangle in each cell. I tried to change to format to General, so...
May 13th, 2009 09:00 PM
by Louisq Go to last post
0 166
Post New Thread


Display Options
Showing threads 20181 to 20200 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:02 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.