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
FYI: MSDG not displaying posts; expects duplicates :-( by Joe User[_2_]
FYI, the MS Discussion Groups web interface is not displaying postings again. It appears to be accepting and propagating postings; they are simply not...
(Multi-page thread 1 2)
January 12th, 2010 03:15 PM
by trip_to_tokyo[_3_] Go to last post
10 203
Combo Box text and Controls changing size on Monitor change by Richhall[_2_]
Hi I have two combo boxes and a control button on a spreadhseet that work fine on my montior. When I remove my laptop and use my laptop screen so control...
January 12th, 2010 01:38 PM
by Richhall[_2_] Go to last post
0 110
transform formula by driller
Hello again, I am preparing a classic presentation of numbers. I just need it for a catchy test. Is there a macro or any formula to convert whole numbers...
January 12th, 2010 10:02 AM
by driller Go to last post
3 114
How to Control a formula by a character in adjacent column on same by Joe
I have the following example A 1 aaa 1 2 aaa 2 3 bbb 3 X 4 ccc 4 5 ccc 5 6 3 7 3
January 12th, 2010 07:49 AM
by Joe Go to last post
4 197
Previous Posts by enna49
Hi I have previously posted a question which was answered successfully and I thought there was a way of viewing these posts. I have spent the last 1/2...
January 12th, 2010 07:42 AM
by enna49 Go to last post
3 94
Counting consecutive numbers in a list by Wiseguy91
I'm looking to take a list of twenty numbers and count the number of times in that list two or three consecutive numbers appear in it. Any ideas?
January 12th, 2010 04:52 AM
by T. Valko Go to last post
1 105
Counting Consecutive Numbers in a List by Wiseguy91
Is there a function in Excel that will count how many sets of 2 or 3 consecutive numbers appear in a list of 20 numbers? Sorry if this post is redundant, but...
January 12th, 2010 04:51 AM
by T. Valko Go to last post
1 108
Dynamic Range in Offset Help Request by VBApprentice :)
Dear Gurus and MVPs, Is there a way to change the Reference of the Offset funtion so that the reference cell could change accordingly ? For example, 1 ...
January 12th, 2010 04:49 AM
by T. Valko Go to last post
1 120
how to calculate a projected date by farmgirl[_2_]
I'm working on planting schedules using Excel 2003. I have a column containing weeks to maturity and a column containing the planting date. How to a...
January 12th, 2010 02:41 AM
by Ashish Mathur[_2_] Go to last post
3 117
Excel Worksheet by Scott Rowe[_2_]
Howdy, I am trying to minulipate this worksheet so once I enter data into the form I would like to display the data for each form into a specific cell and...
January 12th, 2010 02:18 AM
by Scott Rowe[_2_] Go to last post
0 90
In Excel , by XL novice
how do I transfer invoices to a sales ledger without typing in each one individually
January 12th, 2010 01:44 AM
by Gord Dibben Go to last post
1 82
Lookup one value, Return matching correspnding values by JJ
I need to lookup a value in a column to return multiple corresponding values from another worksheet. Worksheet A: Worksheet...
January 12th, 2010 01:29 AM
by Ashish Mathur[_2_] Go to last post
7 112
Counting consecutive numbers in a list by Wiseguy91
Is there a function that will take a list of 20 numbers and count if two or three of them are consecutive and count how many times this happens within the...
January 12th, 2010 12:07 AM
by Wiseguy91 Go to last post
0 84
sum letters with values and numbers by Galadad
I have a time sheet that where I want to do various totals. When it's hours worked, no problem. This department also uses letters (P, V, H) to indicate...
January 11th, 2010 11:33 PM
by Lars-Åke Aspelin[_2_] Go to last post
2 116
Formula displaying don't know why by Jazz
I put a formula in a worksheet and instead of making the calculation the formula is showing. I checked Tools/Options/View but Formulas is not checked off. ...
January 11th, 2010 11:11 PM
by Jazz Go to last post
1 111
assign numeric value to letters and sum with other numbers by Galadad
I apologize if I am duplicating an earlier question, but I can't find the answer. How do I sum a row or column that has numbers and letters by giving the...
January 11th, 2010 10:53 PM
by Galadad Go to last post
3 90
Auto Sum range with multiple columns. by BRC[_3_]
Can anyone tell me if there is vba command to auto sum a range similar to pushing the autosum button ∑ in excel 2007? In this situation the cells may not...
January 11th, 2010 10:32 PM
by Gord Dibben Go to last post
1 98
Totaling YTM on a group of loans by kirkland020208
Is there a formula that will accurately total the YTM of a group of loans?
January 11th, 2010 10:18 PM
by ryguy7272 Go to last post
1 215
How can I change the row height of specified rows? by Di_W[_2_]
I want to change the height of every 4th row. Is this possible? Thanks!
January 11th, 2010 10:16 PM
by Gord Dibben Go to last post
2 134
Drivers for percentage increase by Jo
I am trying to set up a driver to include in my budget profile so that my managers can select the percentage from a driver and see on each budget line what...
January 11th, 2010 09:40 PM
by trip_to_tokyo[_3_] Go to last post
1 130
Post New Thread


Display Options
Showing threads 3961 to 3980 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 02:31 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.