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
September 23rd, 2008 03:28 PM
by Spiky Go to last post
1 198
how i can count the dicontineued lines according to category wise by Santosh
Dear Sir/Madam, there is lot of categories every category have discontinued mrp lines,increged mrp lines and some of them are blank because is regular...
September 23rd, 2008 03:24 PM
by Spiky Go to last post
1 196
Help, I need a formula for work. by Che028[_2_]
Help, I need a formula for work. Here is a generic version of my problem Leauge Team Attendance exceed 20,000? American Yankees Yes American Red Sox No...
September 23rd, 2008 03:16 PM
by Spiky Go to last post
7 317
Using VLookup and Conditional Formatting by Andy B.
I am currently working on a project with the company I am working for and we are having some difficulty with an excel formula. We're basically working out of...
September 23rd, 2008 03:16 PM
by Stefi Go to last post
4 226
Classify grups by Tiiii
hi, How do I create a column that classify grups, like if i have one column with numbers from 0 to 2000 and I want another column that gives me a number like...
September 23rd, 2008 02:11 PM
by MartinW[_2_] Go to last post
2 146
Is the RANBETWEEN function certified randomness? by Candicehkjc
We use the RANBETWEEN function to generate random numbers, is this function certified randomness?
September 23rd, 2008 02:06 PM
by JP[_5_] Go to last post
7 333
Four criteria MATCH INDEX lookup of date between matching two text by John_J
I got stuck after 2 criterias, can anyone help! I need a formula that returns 1 if true and 0 if false in Sheet2!B2:Z1000 (filled/copied out). The formula...
September 23rd, 2008 01:33 PM
by John_J Go to last post
9 465
average based on criteria by ramudt
i am having the values as follows PRODUCT MFGDATE ====== ======= AAAA 01-SEP-08 BBBB 02-SEP-08 CCCC ...
September 23rd, 2008 12:37 PM
by Mike H Go to last post
7 199
max date based on criteria by ramudt
it is not working the data values are as follows A B C D = = = = AAA 01-Sep-08 ...
September 23rd, 2008 12:29 PM
by ramudt Go to last post
2 127
Checking for Duplicates within a Workbook by RAYCV
Hi, I am using the following array formula to check for duplicates within a worksheet. {=IF(MAX(COUNTIF('Daniel S'!A4:A1000,A4:A1000))1,"Duplicate","No...
September 23rd, 2008 12:10 PM
by Lori Go to last post
7 183
Average column by [email protected]
I have a column of cells which contain some cells with values (ie: 4,6,3,5,7 etc.) and some blanks (cells which possibly will have values if circumstances are...
September 23rd, 2008 10:46 AM
by Ashish Mathur[_2_] Go to last post
4 193
Movado Se Sports Edition Mini Womens Watch 0604835 by [email protected]
Movado Se Sports Edition Mini Womens Watch 0604835 Discount Watches Site : http://www.watchespurchase.com/ Movado Se Sports Edition Mini Womens Watch 0604835...
September 23rd, 2008 08:30 AM
by [email protected] Go to last post
0 558
Equation required by Junaid[_2_]
I am trying to generate an equation to generate the total value in one column if there are two categories are same in two columns. e.g. A B ...
September 23rd, 2008 08:25 AM
by Mike H Go to last post
2 160
Refer to a worksheet/name using cell contents? by Caeres
I'm creating a workbook that contains a "Front Page" worksheet, in which the user inputs tank numbers, and then the worksheet returns specific information...
September 23rd, 2008 03:23 AM
by T. Valko Go to last post
5 152
autofilter average without zero by jane
I am using the Subtotal with autofilter to average the visible cells but I need to exclude zero values. please help. thank you in advance, jane
September 23rd, 2008 03:18 AM
by T. Valko Go to last post
2 262
VLOOKUP from multiple table_arrays? by Seebs
I have what probably should be in one many-rowed table broken into three separate tables side by side just so I can see them more easily....
September 23rd, 2008 03:09 AM
by T. Valko Go to last post
3 204
Need to calculate percentage with some variables by Cristin
Hello, I'm trying to calculate the % of YTD Actual # compared to the Annual budget #. In some cases it's easy: YTD Actual = $10,000, Annual budget =...
September 23rd, 2008 02:02 AM
by Fred Smith[_4_] Go to last post
4 162
How to identify offset data and execute multiple formulas by davensocal
Hello All- Sorry to ask this of everyone, but I am not that good at Excel 2003, and I am getting a headache reading through all the posts.. What I want to...
September 23rd, 2008 01:04 AM
by Sheeloo[_2_] Go to last post
1 162
find and replace data by Rob
How would I find and replace data conditionally. In the example below I would like to take Workbook 2, A1:A3 and replace abc with 123. Something...
September 23rd, 2008 12:54 AM
by NoodNutt Go to last post
3 153
Convert time to text by NoodNutt
G'day Everyone I need a work around for the following please: Case Target.Value = DateSerial(2008, 9, 1) And Target.Value DateSerial(2008, 10,...
September 23rd, 2008 12:52 AM
by NoodNutt Go to last post
3 286
Post New Thread


Display Options
Showing threads 20041 to 20060 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 12:38 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.