sequence numbers #2

how i can put sequence number after applying filter.
if anyone can help me on this matter, i'll be very thankful.
0
Ashley (23)
7/22/2005 12:04:02 PM
excel.misc 78881 articles. 5 followers. Follow

1 Replies
793 Views

Similar Articles

[PageSpeed] 52

If your list begins in cell A1....

Insert a column and put SEQ in the "new" cell A1.
Then put this formula in Cell A2 and copy down:
=SUBTOTAL(3,B$2:B2)

Now filter your list. That formula will count the number of non-blank, 
visible cells.  

Note the dollar sign in the formula.  Cell A3 will count the non-blank, 
visible cells from A2:A3.  Cell A5 will count them from A2:A5, etc.

Does that help?

-- 
Regards,
Ron


"Ashley" wrote:

> how i can put sequence number after applying filter.
> if anyone can help me on this matter, i'll be very thankful.
0
7/22/2005 1:32:02 PM
Reply:

Similar Artilces:

finding all the Type=2 deliverables in the Server
Is there a quick way to get a listing of all of the type=2 deliverables in the Server? Yes, create a query in the Reporting db. Look at the built in Views ending with _Userview. They have all custom fields automatically appended to their end. -- Rod Gill Microsoft MVP for Project - http://www.project-systems.co.nz Author of the only book on Project VBA, see: http://www.projectvbabook.com "Chris_J_S" <ChrisJS@discussions.microsoft.com> wrote in message news:3531912E-1B61-4087-9CBE-AF7F00635BD1@microsoft.com... > Is there a quick way to get a li...

Numbers did not reset Jan. 1
I am using access 2003 in XPsp2 I have a log that assigns consecutive numbers preceded by a 2 digit year. (ex 10-001) On Jan. 1 the number was supossed to change and reset from 09-690 (last number of the year) to 10-001. This did not happen. The year changed but the number carried over showing 10-691. Here is the VB code that was used for this change I think. I did not write it and my VB knowledge is poor. Me.txtIncrNum.Enabled = True Me.txtIncrNum.SetFocus Me.txtIncrNum.Text = Nz(DMax("[IncrNum]", "[tblincidents]", _ "Year([datefi...

Auto Numbering #4
Hello All, Autonumbering I am using Office 2003 and have the following problem Col B 1 Mar-07 2 Sales 3 Sales 4 Mar-07 5 Sales 6 Apr-07 7 Apr-07 8 Sales .... .... .... I wish to enter in Column A, a formula which when dragged down should show me Nos. 1, 2, 3.... Only against the Months (viz Mar, Apr, May...etc) The Cell in Column A against the Word "Sales" in Column B should be blank. The Output should come as follows: Col B 1 Mar-07 Sales Sales 2 Mar-07 Sales 3 Apr-07 4 Apr-07 Sales .... .... Any one can help me in the right direction! Thanks in a...

Custom border problem #2
Having difficulty creating a custom border around a text box in Publisher 2000. After seleccting the graphic to use, we get the message that Publisher cannot open the file. It is not a question of file complexity or on a network as we see the same message no matter where the source. The account in question is a limited account, which we are assured, has managed to create custom borders in the past. I tried making a border in the admin account and it works OK which would suggest it is a question of permissions, but why should be so and why did it work once but no longer? TIA TWK Can ...

How to autofill a sequence
How can I autofill a sequence like the following. I would start with: 1 1 2 2 3 3 ..... and it would contunue to autofill.... 4 4 5 5 6 6 ..... Can this be done without vba coding? Greatly appreciate any help. Best Regards - Randy Randy 1 Select the relevant range you that already contains the series. 2 With the range selected, point your mouse over the bottom right corner of the last cell in the range. 3 Right click your mouse and drag down as far as you need. 4 Release the right mouse button and you should be presented with a number of options - select "Fill Series" -- XL200...

mail merge ticket numbers
Here is one for all the guru's out there... I have created a set of 3 "tickets" on a single page in MS Word. I have created a list in Excel from 101-201. How can use the mail merge in MS Word to show the sequence ticket numbers? Example: Page 1 Ticket # 101 Ticket # 102 Ticket # 103 Page 2 Ticket # 104 Ticket # 105 Ticket # 106 And so on... Thanks, Tustin -- onesidered ------------------------------------------------------------------------ onesidered's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25977 View this thre...

Smartlist error #2
Can anyone tell me if there is a limit to the number of records that can be exported from Smartlist to Excel. We are attempting to export 25,000 records and receive an error 'unhandled object exception: cal rejected by callee'. We can export less records. Try the free download, EZ-GP, at datapresentation.com "TSUE" wrote: > Can anyone tell me if there is a limit to the number of records that can be > exported from Smartlist to Excel. We are attempting to export 25,000 records > and receive an error 'unhandled object exception: cal rejected by call...

Re: [ANN] Sync Entourage-iCal (new) and Sync Entourage-Address Book 2.5 Update for 2004
> This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --B_3167969215_28936720 Content-type: text/plain; charset="US-ASCII" Content-transfer-encoding: 7bit On 5/20/04 9:01 AM, I wrote: > New scripts and updates for Entourage 2004: >> >> NEW: Sync Entourage-iCal 1.0 [for Entourage 2004 only] >> Sync Entourage-Address Book [PANTHER] 2.5 [free update - with new features >> for Entourage 2004] >> Export-Import Entourage X 1.3 [free update - with versions of the Exc...

Whwn I send an E Mail I receive an error number
Hello to Everybody When I send an E Mail I receive these two error numbers: OX80070057 OX800cccOD Is there anyone who can help me? Many thanks beforehand. ...

Referencing Numbers
I have a large (master) spreadsheet I made showing NBA players and using standard deviation I have been able to give the players rankings in different categories. I also have separate spreadsheets for each team listing their players, and each players ranking in each category. That sheet sums up each teams category and sends those numbers to another sheet that compares each team. What I usually have to do is copy each players rankings one at a time and paste them onto the corresponding sheet. What I'm wondering is.....is it possible to link the sheets so that when i put a players...

001 #2
...

Chinese antique #2
Q2hpbmVzZSBhbnRpcXVlDQp3b3JsZCBmaXJzdCwgdGhlIGFudGlxdWUgY2hpbmF3YXJlIHNlcmll cyBwbGVhc2Ugd2F0Y2ghDQpFbnRpcmUgZmlkZWxpdHkgMTAwJSBBbnRpcXVlICgxOTEyLTE5NDkp IFJlcHVibGljIG9mIENoaW5hIHBvcmNlbGFpbg0KdGVhcG90IDg4OCBjaGluYXdhcmVzIDQwMCBw bGVhc2Ugd2F0Y2hpbmchDQpXZWJzaXRlIGh0dHA6Ly93d3cueGp4NTg4LmNvbQ0KRS1tYWlsIHhq eF81ODhAdG9tLmNvbQ0KQ2l0eSBTaGVuZ3pob3UgWmhlamlhbmcgQ2hpbmENCg0KyKvH8s6o0ruh ornFtq20ycb3z7XB0MPxufq0ybLouvg4ODiw0cfrudvJzaOhDQrIq8fyzqjSu6GiyKuxo9XmucW2 rbTJxvfPtcHQw/G5+rS/ytbWtLTJsui6+Dg4OLDRoaK0ycb3NDAwvP7H67nbyc2how0KucXS1dD5 ucW2rcrVstjWrra8DQrN+NW+o7podHRwOi8vd3d3LnhqeDU4OC5jb20NCrXn0...

Outlook 2003 - 2 MSN http accounts
I set up Outlook 2003 with 2 email accounts for my wife and me. We are using MSN http. All email sent from either inbox ends up in a single (default) sent items folder under my account. Is there any way to have my wife's sent email go to her sent items folder and my sent email go to my sent items folder? Thanks for the help. Tim Only if you use rules or each have your own Outlook profile. -- Diane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in 24 Hours Need Help with Common Tasks? http://www.outlook-tips.net/beginner/ Outlook 2007: http://www.slipstick.com/outlo...

Conditional Number Formatting & Selective Summing #2
Attached is the workbook I need help with. From what I have bee discovering from the Excel Macro-VBA Editor-Help screens, what I wan to do should require fairly simple VBA code. However, I have no VB coding experience or skills (the VBA code in Module 3 was gleaned fro the Excel Tips Forum. Thank you Harlan Grove) Sheets �Run� through �Run (30)� are identical, except that the cel formulas on sheets 2-30 are only active if the active sheet i �Enabled� by the user and will only populate with pulled data if al preceding sheets are �Enabled�. The nature of the workbook is such tha a user will alw...

Automatic Numbering #4
Is there a way to automatic number a spreadsheet? For instances... if I were to start on column A and row 2 with number 1, would this be possible to continue numbering going down the spreadsheet? Please assist. Javster. you could grab the fill handle, the little black square in the bottom right hand, right click and drag down and fill series or put = A2 +1 in A3 and copy down -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "J...

HQ Server/Client Issues after applying HotFix 2.0.0115
I applied HotFix 2.0.0115 Tuesday night/Wednesday and today we seem to be having a lot of connection issues. Worksheet 401s are taking a long time to process, and by "a long time" I mean 5+ minutes instead of the usual 40 seconds. Whenever a client is connected to HQ, the machine that hosts HQ Server sees CPU usage at 70% or higher for the duration of the connection. Has anybody else experience this problem? Tom -- Stop fishing for e-mail This is a multi-part message in MIME format. ------=_NextPart_000_00FF_01C885DC.3C0CF2C0 Content-Type: text/plain; charset="utf-8&...

items assigned both lot numbers and serial numbers
Hi, Does anyone know of an add-on that would support tracking inventory in house by lot number but then assigning a specific serial number when the item is shipped? Thanks for any info you can provide. -- Thanks very much! Michele Durkin As you know, you can have a serial number mask such that one portion is an incrementing serial number and the other can be a constant. the only problem is that you want to assign that serial number when shipping... You may be able to achieve that using Manufacturng serial/lot number functionality. HS "mdurkin" <mdurkin@discussions.micros...

Outlook is retrieving data from the Microsoft Exchange Server #2
Exchange 2000. Outlook 2002. Using private store and public folders. Brand new Windows XP Pro IBM laptop. One user logs in and it takes upwards of 2 minutes to open one simple message. Another user logs on and accesses their e-mail and there is no delay nor do they get the "Outlook is retrieving data from the Microsoft Exchange Server server_name. You can cancel the request or minimize this message to the Windows taskbar until Outlook closes the message automatically" dialog box. I have looked throughout the news groups and Microsofts web site. Much of the information relates t...

Top 90% of records
Have the oddest SLA requirement I've ever been asked to have a look at, hope you can help. Basically have a set of data of closed records for 2005. My manager wants to show of the closed records how many days were 90% of them completed? She is looking at this as a 'best case' scenario, so therefore in simplistic terms this means: If there were 50 records closed, look at 90% of these records (in shortest amount of days order) and give the highest number once at 90%. e.g. (with a small dataset). There are 50 records. The largest number of the dataset once sorted is 20 (at the 4...

a range of numbers?
hello, i have excel 2000. heres a breakdown of what i need. ive already written the formula fo this part. when i enter a number, lets say 600, i want it multiplie by 1.35. the total, 810, then needs to be broken down into 60, 30, an 10%. like i said, i did all that already. now, i need a range of numbers from 600 to 4000. all mulitplied by 1.3 then broken down into 60, 30 and 10%. im stumped how do a range lik that. is it possible? any help is appreciated -- Message posted from http://www.ExcelForum.com || hello, i have excel 2000. || || heres a breakdown of what i need. ive a...

Find all text instances in a sheet and add one number from each row
I'm trying to have a folmula on a sheet that will look back at another sheet and find all the instances of a text string and then add a numeric value on that row with all the numbers that contain the same text. For instance I have a summary sheet that lists test names and the total hours associated with that test. I want to look back at another sheet and find each instance that has the same test name and add the hours together. This is what I want my summary sheet to do: Summary Sheet ID Test Name Hours 1 Test1 5 2 Test2 4 Using this data: Data Sheet ID ...

Error when opening any part of Office X.v under Mac 10.2.6
I recently started getting the following message when I try to launch Word or Excel from the Office 10.1.2 package: "The application xxx has unexpectedly quit. No orthe applications have been effected." I had the program working fine for some time. I have tried throwing out the application and re-installing but I still get the same message. I also downloaded the updater to Office 10.1.2 which is what I am now running but still no fix. Has anyone else had a similar problem and if so did you figure it out? Thanks in advance. Laura The *exact* same thing has been happening to me. I ca...

validating xml defined by DTD
I want to bypass the dtd validation that child elements must appear in a certain order ... In a DTD child elements that are defined and seperated by commas they must appear in the same sequence in an xml file in order for the xml to be valid ... eg if the dtd defines an element Parent with two child nodes <!ELEMENT Parent (a, b)> Then the following xml is valid <Parent> <a>data</a> <b>data</b> </Parent> but the following xml <Parent> <b>data</b> <a>data</a> </Parent> is invalid ... Does anyone know of any wa...

Sorting "text" numbers
I am sorting a list of numbers (actually telephone extensions) which need to be formatted as text. When I sort them I get two separate lists starting over again. e.g. 1000,1001,1004,2003,3456,...,0456,1003,2455,... I've check for leading spaces, format differences etc. but this is not the problem. Chris, If the cells were formatted after entering the data, the currently entered values aren't automatically converted from numbers to strings. Do your sort, then select the first group of cells and run this macro: Sub MakeText() For Each myCell In Selection myCell.Value = &q...

Adding variable number of columns
Hi Using Excel 2003 I want to create a formula which will add a varing number of columns together depending on the entry in a particular cell, for a budgeting spreadsheet. For example if I have a year to date total in the 13th column and I was to type January in cell A1 I would want the value in the first column to be displayed in the year to date total (column 13). If I put June in A1 I want the sum of the first 6 columns to be displayed in the YTD total etc for an entire year. I was able to use a nested IF statement last year as there were only 3 months remaining when...