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 Replies Views Reverse Sort Order
VLOOKUP returns unwanted/wrong values by wcollatz
I'm using the VLOOKUP function to return data from a named range which contains several data points (across the row) for several "sites" which are numbered...
September 23rd, 2008 09:57 PM
by T. Valko Go to last post
4 988
Opening Excel sheet with macro's on XP machines gives error by Dhanashree Bhat
Hello, I have an Excel sheet which has macro's written as well as Calendar control used. This sheet was developed in Excel 97 (windows 98) environment. It...
September 17th, 2003 07:02 AM
by Dhanashree Bhat Go to last post
0 985
How to Calculate ANTILOG in EXCEL SHEET? by Parag
Can you please guide me about calculation of Antilog in the excel sheet. Regards
March 31st, 2006 03:38 PM
by Bernard Liengme Go to last post
3 981
Numbering rows for sorting by Dan
If i understand you correctly try this: Say you want your numbers from A1 to A1000 In A1 input the number 1. In A2 input the number 2. Hilight (select just...
September 15th, 2003 02:08 PM
by Andy B Go to last post
1 980
Alternative formula to HLookup by Bernie Deitrick
BeSmart, (I actually knew someone named B. Smart ;-0) Simply make the row lookup parameter dynamic: in this case, replace the 4 with ROW()-Row($BN$10) This...
March 26th, 2004 01:53 PM
by Bernie Deitrick Go to last post
0 978
Keyboard shortcut for current date and time by Raj[_4_]
Hi, Ctrl+ ; inserts current date and Ctrl+Shift+; inserts current ti me Ctrl+Shift+; inserts the current time with the date serial as 0 and not the current...
June 2nd, 2010 04:24 AM
by Jim Cone[_2_] Go to last post
1 977
View Message when Mouse Hovers over Cell. (Not the Comments Feild) by Kev - Radio Man
Hi, I am interested if there is a way to have a message become visible when the mouse is hovered over a cell. I am currently using 2007. In this problem I...
June 1st, 2010 01:02 AM
by Kev - Radio Man Go to last post
2 977
entering more than seven levels of functions with in a function by CAMPLI
I WANT TO PUT MORE THAN SEVEN LEVELS OF FUNCTIONS WITH A FUNCTION. FOR EXAMPLE...
June 3rd, 2010 11:48 AM
by Steve Dunn Go to last post
3 976
Converting number to text by booshi
Is it possible to convert, say 1234 to one thousand two hundred and thirty four Thanks
June 2nd, 2010 06:17 AM
by Jacob Skaria Go to last post
1 975
VLOOKUP problem by Crystal
I'm using the VLOOKUP worksheet function and I'm having some issues with the result affecting my other formulas. Instead of the lookup returning "#N/A" when it...
September 15th, 2003 04:03 PM
by Anon Go to last post
1 975
Pivot Table option, display as data list, repeating items down by carl.fields
I sometimes need to combine data from more than one pivot table, and then do a pivot table on the combined data. Since you don't have the option of having a...
September 17th, 2004 07:57 PM
by carl.fields Go to last post
4 974
MAKE EASY MOENY by Rajkovaca Ante
- MAKE EZ AND FAST CASH, NO JOKE, JUS READ!!!!! : MAKE MONEY FAST!!!!!! IT WORKS!!!!!!! : IT'S SIMPLE AND IT'S LEGAL!!!!!!! I found this on : a bulletin board...
January 2nd, 2004 10:51 PM
by Rajkovaca Ante Go to last post
0 973
What is mathematical equation for NORMDIST (x,mean,standard_dev,TR by Rijan
Would someone tell me the exact mathematical equation for NORMDIST (x,mean,standard_dev,TRUE)? I have found an equation in Excel Help which is for cumulative...
June 21st, 2005 01:15 PM
by Jerry W. Lewis Go to last post
9 972
COUNTIF function for multiple criteria by yorkshirelass
I hope someone can help me. I devised a s/sheet in Excel 2007 using the COUNTIFS function. However, not all my colleagues like 2007 and have reverted back to...
June 18th, 2009 01:45 PM
by Bernd P Go to last post
8 970
Odd Drop Down Box Behavior by Squeaky
I have a drop down box on a spreadsheet in a workbook with several spreadsheets. For some reason the contents of the drop down box is beeing bled through to...
March 19th, 2010 12:17 AM
by Gord Dibben Go to last post
4 969
Counting cells with conditional formatting by AOdoc
I am trying to count the cells in a range that have a certain fill color in Excel 2003. Is there a way to use COUNTIF? If so, how do I write the criteria for...
June 2nd, 2010 03:27 PM
by Luke M[_4_] Go to last post
2 968
using cell contents in pathname by Don Guillett
Since indirect won't work with closed files, couldn't u use indirect to make the reference and then just copy/paste special values? -- Don Guillett SalesAid...
January 2nd, 2004 03:11 PM
by Howie Go to last post
7 966
California Overtime Calculation by Joe D.
Hello, I'm looking for a formula that will calculate overtime. But here's the problem... We do business in California and are required to pay overtime...
May 10th, 2005 01:45 AM
by Harlan Grove Go to last post
3 960
State Machine in Excel by Alex Gildenberg
Hi, I need to implement state machine in Excel as follows: There are 6 valid states: S1,S2,S3 and B1,B2,B3 Valid moves between...
August 1st, 2004 02:39 AM
by macropod Go to last post
1 960
countif by Jim W
I am trying to count the number of cells in column B="large" when the condition in column A="week1". I tried the formula below and it counted all the...
June 3rd, 2010 06:19 AM
by L. Howard Kittle Go to last post
3 959
Post New Thread


Display Options
Showing threads 201 to 220 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 06:24 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.