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 Reverse Sort Order Views
Points Ranking Formulas by Cabo Wabo Jim
I have a spread sheet in which I enter players names and the place they finished for a certain event. I would like the sheet to calculate their points...
(Multi-page thread 1 2 3)
November 3rd, 2005 02:52 PM
by Max Go to last post
22 472
how to count if cell "contains" a word by cjlatta
(Using Excel2003/WinXP) I am trying to count the number of times 2 values are in a cell. The string may contain the values ",abcd, abcf," or ",abcf, abcd,"...
(Multi-page thread 1 2 3)
July 15th, 2008 08:59 AM
by Rick Rothstein \(MVP - VB\)[_917_] Go to last post
22 241
Alphanumeric by hardeep via OfficeKB.com
Dear sir I have list of 15000 of Alphanumeric data for ex. ADEDO125ADSD589ADF121, UIEIROIWS12556ERE545,ADAS15455212AD4564AD2 And so on. Now I want to extract...
(Multi-page thread 1 2 3)
July 29th, 2008 06:12 PM
by T. Valko Go to last post
22 250
LOOKUP, FREQUENCY etc - what's the best way by Brian
(moved from general) I am trying to take the data from the Races sheet and have certain parts counted, summed, or averaged by track into the Track Stats...
(Multi-page thread 1 2 3)
August 25th, 2008 09:24 PM
by T. Valko Go to last post
22 397
SUMIF with 2 conditions by JBoyer
I'm trying to use a SUMIF function with one sum range and two seperate ranges with seperate conditions. For example: I'm trying to sum the cells in the "I"...
(Multi-page thread 1 2 3)
March 8th, 2010 09:04 PM
by T. Valko Go to last post
22 276
alpha numeric data validation for excel by [email protected]
I want to use a non vb formula in data validation for an excel formula to make the user enter the first 2 characters of a field as UPPERCASE letters i.e....
(Multi-page thread 1 2 3)
November 30th, 2008 05:28 AM
by T. Valko Go to last post
22 300
How do I Calculate PI in an Excel formula? by jollydottie
Using the calculator I get a different answer, if PI = 3.162. then *3.162 in Excell should give me the right answer but it doesn't.
(Multi-page thread 1 2 3)
January 16th, 2009 04:03 PM
by Dana DeLouis Go to last post
22 223
Divide by the minimum non-zero number in a range of cells by Opus
I need to find the minimum non-zero number in a range of cells that contains some zeroes. So that I can divide by the minimum number. Any ideas? If I just...
(Multi-page thread 1 2 3)
June 14th, 2009 08:27 PM
by JoeU2004 Go to last post
22 354
Allocating Intergers based on Relative Percentage by Jim Thomlinson
Here is the Scenario. I have 15 different locations all of different relative size. I will be shipping inventory to those locations based on their relative...
(Multi-page thread 1 2 3)
September 29th, 2009 10:53 PM
by JoeU2004 Go to last post
22 418
countifs - what is instead in excel 2000??? by amir2000
Hi I used in office2007 the function countifs, in office2000 it's not working. What can i use...
(Multi-page thread 1 2 3)
June 13th, 2008 09:40 PM
by Harlan Grove[_2_] Go to last post
22 294
iwhich funvtion to use : in conversion of date and hour to day and by kbee
I need to convert the data from a cell that contains date and time to a different cell that will give a result of day /night, which functions should I use...
(Multi-page thread 1 2 3)
February 15th, 2008 01:13 PM
by Ron Coderre Go to last post
22 291
formula for a pension by barbarat
Help, please...I am using Excel 2003...as a newbie... I need to calculate (in Column I) the match for a 401(k) as follows: Column G is compensation, H is...
(Multi-page thread 1 2 3)
December 10th, 2005 02:18 PM
by barbarat Go to last post
22 308
hash function for large strings by jheby
Excel vlookup function returns #VALUE when the lookup value exceeds 256 characters. I need a hash function to transform large strings into a value that does...
(Multi-page thread 1 2 3)
March 16th, 2006 08:07 PM
by jheby Go to last post
22 311
1st Monday of a month in date range?? by scwilly
Hello everyone, I need to determine the number of 1st Mondays or any weeday e.g. 5th Fridays between a date range e.g. 1/1/2006 - 4/1/2006. I've noticed a...
(Multi-page thread 1 2 3)
April 26th, 2006 04:49 AM
by scwilly Go to last post
22 257
count unique with mulitple criteria by ellebelle
I have a list of data. Mike JOB1 Karen JOB2 Unfilled JOB1 Unfilled JOB2 Unfilled JOB1 Alex JOB1 Alex JOB1
(Multi-page thread 1 2 3)
October 13th, 2006 11:26 PM
by Don Guillett Go to last post
22 293
Return Unique Consecutive Duplicate Values across Single Row by Sam via OfficeKB.com
Hi All, I have a Named Range called "Data" that spans 8 columns and 7 rows. A Numeric Value will appear only once in a row. Each row's Numeric Values are...
(Multi-page thread 1 2 3)
February 6th, 2007 12:44 PM
by Sam via OfficeKB.com Go to last post
22 156
lock cell based on a condition by Amanda
I would like a cell to be locked or unfillable based on the results of another cell. For example: Column B has a formula that the results are "" or "x". If...
(Multi-page thread 1 2 3)
June 25th, 2007 07:53 PM
by Gary''s Student Go to last post
22 235
Limit to nested IF(ISNUMBER(SEARCH)) functions? by Jonathan Horvath
is there a limit to the number of nests you can have in a nested IF(ISNUMBER(SEARCH)) functions? For example, I have one that works properly with 6; for...
(Multi-page thread 1 2 3)
June 25th, 2007 08:04 PM
by Ron Rosenfeld Go to last post
22 227
Formulas in 2007 not working in 2003 by Andrew
I created a formula in Excel 2007: =COUNTIFS(Workflow!G9:G305,"New Facility",Workflow!S9:S305,"Yes") and =SUMIFS(Workflow!U9:U305,Workflow!G9:G305,"New...
(Multi-page thread 1 2 3)
January 28th, 2008 07:10 PM
by Ron Rosenfeld Go to last post
22 224
Validation of UK VAT Number by Rob
Hi, I want to check a number of VAT numbers using a formula, the first check is to ensure the number is 9 digits (may need to remove spaces to ensure clean...
(Multi-page thread 1 2 3)
April 18th, 2010 10:24 PM
by Rick Rothstein[_2_] Go to last post
22 920
Post New Thread


Display Options
Showing threads 141 to 160 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 05:10 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.