Welcome to the Excel Forum

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.

Please Register to Remove these Ads

Please Register to Remove these Ads



Reply
  #1  
Old 10-07-2008, 06:27 AM
Spellbound Spellbound is offline
Valued Forum Contributor
 
Join Date: 22 Mar 2006
Location: UK
MS Office Version:Office 2003
Posts: 227
Spellbound is becoming part of the community
Post Excel Version in Threads

Please Register to Remove these Ads

I recently answered a post incorrectly partly because I assumed the person was referring to SUMIFS in the plural but as ratcat correctly pointed out; this is a new function in Excel 2007.

Not having used Excel 2007, I was not aware of this. Still debating whether to upgrade but thats a seperate issue.

Its very easy to forget to state which version of Excel you are using in a thread, so perhaps it would help if there was an option or dropdown list in the first post of a thread, which you have to tick or select for the version.

It would also help others using the same version to know that a 'solved' thread works for their particular version of Excel.

Just a thought ...spellbound
Reply With Quote
  #2  
Old 10-07-2008, 08:31 AM
royUK's Avatar
royUK royUK is online now
Forums Administrator
 
Join Date: 18 Nov 2003
Location: Derbyshire,UK
MS Office Version:Xp; 2007
Posts: 13,708
royUK Has a higher level of understanding royUK Has a higher level of understanding royUK Has a higher level of understanding royUK Has a higher level of understanding royUK Has a higher level of understanding royUK Has a higher level of understanding royUK Has a higher level of understanding
It's a good suggestion, but I doubt if many OPs would use it. Look at the trouble we have with Code Tags!
__________________
Hope that helps.

RoyUK
--------
If you are pleased with a member's answer then use the Scales icon to rate it

For Excel consulting, free examples and tutorials visit my site
Check out the free Excel Toolbar

New members please read & follow the Forum Rules

Remember to mark your questions Solved and rate the answer(s)


Code Tags: Make your code easier for us to read
Reply With Quote
  #3  
Old 10-11-2008, 10:29 PM
ratcat's Avatar
ratcat ratcat is online now
Valued Forum Contributor
 
Join Date: 07 Mar 2008
Location: Rural NSW, Australia
MS Office Version:Vista 2007
Posts: 689
ratcat has an addiction to Excel
G'day guys,

On top of the great suggestion.

Another suggestion.

Make a required field in the CP User, that must be filled out.

Then this required field can be displayed under your registered date or under the user name.
__________________
Have I made you happy ??? If yes, please make me happy by pressing the Reputation icon in my post. Thanks


I don't void confusion, I create it
Reply With Quote


Reply

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel crashes due to incomplete VBA compilation? RogerN Excel Programming 2 06-11-2009 09:26 PM
Mail Merge Issue - Excel 2007 to Word 2007 JBG2007 Excel General 1 07-18-2008 12:43 PM
Error # 1004 was generated by Microsoft office Excel johnson Excel Programming 2 07-17-2008 12:56 PM
Post Excel Charts as ScreenSaver fractal5555 Excel Programming 0 05-21-2007 10:30 AM
shifting online data comes to excel as per formula with very minimum timelag cramatr Excel Programming 0 05-04-2007 10:08 PM