finding last non empty cell in a column #2

Perfect - Thank

--
cparson
-----------------------------------------------------------------------
cparsons's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1286
View this thread: http://www.excelforum.com/showthread.php?threadid=26238

0
9/22/2004 2:49:11 PM
excel.misc 78881 articles. 5 followers. Follow

0 Replies
502 Views

Similar Articles

[PageSpeed] 41

Reply:

Similar Artilces:

How to Filter cells and save the file with certain criteria?
Hello. I have a Excel file that contains a large list of Tracking Numbers. The tracking numbers are from two sets of order types- Internet orders and Mail Orders. Orders that are from the Internet are matched up with a order number such as "5678". Orders from the mail-order side are designated by initials "MO". So in Excel it'll look something like this: trackingnumber orderid 123365656666 5467 152155896345 5468 123365634567 MO 152134567789 5469 152151234563 MO Is there a way to eliminate the Mail-Order rows and save the Excel file to ...

Viewing IMAP messages #2
I connect to a Linux IMAP server remotely for my emails. When I click on an email in Outlook P once the headers have been updated the system seems to download the email and the attachement. All I want to do is read the message before I download the attachment - Is this possible? Its a bit of a problem if an email has a 3mb attachement and all I want to do is read the mail content before deciding to download the attachment - especially a pain if I am CC into some mail. Regards Andy --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Ve...

Sumproduct #2
Hi all! I am trying to use Sumproduct with dates that come off an SQL databas and are in the format of 02/12/2003 15:30. This is forcing me to use the following formula =SUMPRODUCT((Data!$E$2:$E$3893>G$3)*(Data!$E$2:$E$3893<G$2)*(Data!$C$2:$C$3893=$A4)*(Data!$G$2:$G$3893)) where $G3 is 02/12/2003 00:01 and $G2 is 02/12/2003 23:59 Is there any way I can just look at the date only rather than the time as well, so that anyone can enter a date from, and a date to In anticipatio ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and p...

pasting into merged cells #2
Every time I try to copy and paste data into a merged cell I get error messages about the cells not being the same size. Even if I try to just paste values only. Is there any workaround or fix for this??? Dennis Try pasting into the formula bar. It's a pain, but it works. HTH Carole >-----Original Message----- >Every time I try to copy and paste data into a merged cell I get error >messages about the cells not being the same size. Even if I try to just >paste values only. Is there any workaround or fix for this??? > >Dennis > > >. > See my res...

Work out overtime hours for individuals #2
Hi All I have a question which i am hoping someone will eb able to help me with, i have a spreadsheet which contains infromation for part time hours worked during the course of a month for individuals (e.g. below) Name Start End Hours Persona 1:30 2:30 1 Persona 3:30 4:30 1 Persona 9:30 11:30 person b person b person c person c person d etc etc What i need is a formula that will allo wme to add an extra column which gives me the total hours person a worked, person be worked and so on. The original data contains multiple lines (i.e persona could have 10 lines, personb15 lines etc etc), and...

add contents of one column
I have a budget that I want to automatically add the contents of one column as I'm working on the sheet. I am new to this and I need all of the helo that I can get. In B1: =SUM(A:A) -- HTH RP (remove nothere from the email address if mailing direct) "Pam" <Pam@discussions.microsoft.com> wrote in message news:FC5F8EE6-99D4-4327-B452-D34E441CA743@microsoft.com... > I have a budget that I want to automatically add the contents of one column > as I'm working on the sheet. I am new to this and I need all of the helo that > I can get. Assume your numbers ...

Cannot insert explicit value for identity column in table x
Sql Server 2005 9.00.4035. We have a hub and spoke topology which includes 6 tables with identity columns. I need to add a new subscription to a new server (same version/sp). I took backup from another subscriber and restored to new server, ran snapshot, push subscription. To make sure a new record would replicate, I added a record at the publisher with the followig text: Insert into tblicimagefolder (imagefolder) values ('dummy') A conflict occurs with the following: This failure can be caused by a constraint violation. Cannot insert explicit value for identity c...

Synchronize data across 2 sheets
Hi all Excel 2007 Workbook with a sheet called 2010 around 700 rows/records and a sheet called Previous around 5000 rows records. Both have 31 columns and identical column headers On the 2010 sheet there are records that have changed, how do I get the changed records details onto and overwite the same record on the Previous sheet. Not sure if it would help but each record has a unique reference number. How do i do this ? Hope this makes sense thanks for any help offered Hi If you know which colums are to be changed I would use vlookup function. Vlookup(lookup valu...

MS Office VBA Automation Specialist #2
Hi there, is there such a certificate? MS Office VBA Automation Specialist, I tried googling it on microsoft website and couldn't find any info. I just passed the excel 2k expert exam and I want to take the excel instructor exam, I haven't however been an instructor. is it possible to take the exam without an instructor experience? last but not least, I am thinking about putting together some excel webcasts for beginners for free. I have always liked to learn by audio/visual versus reading so I am thinking about implementing this... here is the link for the first test webcast ...

cell protection to allow GROUP/UNGROUP function
2 asthetic questions for all you advanced Excel Users.... Q1. is it possible to protect a worksheet, but still be able to us the +GROUP & -UN GROUP buttons ? to expand / contract the viewe ranges? Q2. anyone know how to change the colour of the AUTO FILTER button - i changes from black to dark blue when activated - i would like to hav this with more contrast and so it jumps out at you ( and the othe plebs in the office who keep forgetting) Regards David ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages dire...

Making cards --2 to a 8 1/2 x 11 page
I want to make cards to send out for memorials, etc. I want 2 cards to a page, top folded 5 1/2 x 8 1/2. What happened to the old Picture It! Publisher 2001? Do you want to make these cards in Publisher? If you do, look at page setup, folded card, tent card, width 4.25, height 5.5. Publisher will say it will print two pages per sheet -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "A Holt" <A Holt@discussions.microsoft.com> wrote in message news:F5F75EEF-B186-4960-9AEB-AF1C678492B7@microsoft.com... >I want t...

Highlight Cells with different values
Hi, I have a column that I want to locate the differences. I can use the F5---Special---Column Differences. But I wanted to know if I can do it with Conditional Formatting. Like if Value in A1 is different than the values in Column A:A, then it is highlighted... Any help appreciated Fuad Sounds like an Excel question..try one of the Excel newsgroups, this one is for Publisher. "Fuad" <Fuad@discussions.microsoft.com> wrote in message news:0536FB95-362E-412F-BD1C-99BF9B10E8CD@microsoft.com... | Hi, | | I have a column that I want to locate the differences. I can use th...

Last name, first name
I have a list with lastname, firstname in a cell. I would like to change it to firsname lastname. Any clues? officexp. Thank you. Mich - Insert a column after your name column, highlight the name column, go to Data, Text to Columns, Delimited, select comma, finish. This will give you two columns, lastname, firstname. Insert a column before your lastname column. Move the firstname column to the new column. Your third column should now be blank. Enter in the formula =CONCATENATE(,A1," ",B1)in the third column. This will put your firstname space lastname in the third ...

Excel Formulae #2
Hi, I have a spreadsheet with value in one column & a series of dates in 5 other columns.For each row depending on the value in the first colunm a date may be applicable in one or more of the other columns.e.g 550 in the first column will mean dates will be inserted in the next 2 columns similar to authority levels. My qn. is how can I show what's outstanding if the relevant authority levels have not signed off-basically this is used as a tracker of invoices & I would like to show what is outstanding awaiting approval at anytime. Thanks Raj ----------------------------------...

how to arrange list by first or last name
I am trying to make a list with first, middle, last name , street address, and phone numbers. I like to know how you can review the list by any combination of first name, last name, city, state, and or phone number? hi can you give examples of how your list is layed out. i am thinking a helper column with an extraction formula might work. regards FSt1 "Andy" wrote: > I am trying to make a list with first, middle, last name , street address, > and phone numbers. I like to know how you can review the list by any > combination of first name, last name, c...

Download email #2
How to download email from Microsoft exchange 2000 to Outlook Express?? without leave a copy at Exchange server. Outlook Express cannot download mail from Exchange. Why are you trying to do so without leaving a copy of the mail on Exchange? --� Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. Due to the (insert latest virus name here) virus, all mail sent to my personal account will be deleted without reading. After searching google.groups.com and finding no answer, Edi asked: | How to download email from Microsoft exchange 2000 to | Outlook E...

How to total cells in a range with data input
Greetings to all members I am running Excel 97. An office colleague presented me with an issue that might be of interest to any Excel whiz and seasoned programmers. I would certainly appreciate any pointers in solving it. So here goes. The set of values includes 33 cells ranging from B4:D14. The data type is numeric. Data is only input in a few cells. QUESTION What would be the function to enter in, say, cell A15 to indicate the total number of cells in range B4:D14 that have received data input? Or does it involve some behind the scene VBA programming? EXAMPLE B6 = 9 C9 = 4 D11 ...

How do I protect one single cell?
I have a spreadsheet where people are going to type in numbers, and the final cell is a total, which of course I don't want people to accidentally type over, as it will lose the formula behind it. So...... I put some "data validation" behind that cell, to say only allow entries of text length = 50 - a kind of "mock" condition. Nobody'e ever gonna type in 50 chars. are they?! And sure enough, typing in (eg) 854221 brings up the error box to stop them, just like (eg) HHJSYT brings up the error box to stop them. I even unchecked the ignore blank" box, so that ent...

CF to Row after CF is applied to Column
Can someone please help me? I've read through the postings and the help files but still can't seem to figure out how to do this. I've applied conditional formatting to the J column of my spreadsheet so that if there's any text listed the cell turns yellow. What I'd like is if not only the cell but the row, from A:O turned yellow also. How do you do that? I'm using 07. Any help in English walking me through the steps or a hint toward the appropriate post would be greatly appreciated. Cuz I aint figrin it out on myown! Thanks in advance! --Dax...

How-To: Last change date on row
When I set up a database I always include a last change date that auto updates every time any field in the record changes. Does anyone have a suggestion for how to achieve a similar function in a spreadsheet. i.e. put the current date/time in a field in the row whenever anything in the row changes? -- GGG ------------------------------------------------------------------------ GGG's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29220 View this thread: http://www.excelforum.com/showthread.php?threadid=489447 GGG, For example, to put the last change date in...

The recalcitrant active cell.
I am way over in column EO, reconnoitring data, when I need assistance of a "what if", I activate the auto filter, and the active cell jumps back to A1. any workarounds for this annoying habit? Thanks in advance. Works for me, if I filter on something in one column and the active cell is there as well it won't change to A1 2 guesses, your active cell was A1 from the start even though you filtered on EO you have a recorded macro that was setup to go back to A1 -- Regards, Peo Sjoblom "Rodney" <rodney@touch88gum.com.au> wrote in message news:u3PI%...

how to jump to the next column with "enter" in excel?
Hi, The "tab" key is not an option? "dragos" <dragos@discussions.microsoft.com> wrote in message news:076B9F2B-AE6B-4DCD-96ED-6B5AAE35DC4B@microsoft.com... > ...

Field Chooser #2
Guys-is it possible that some of the fields in Outlook 2000 (from Field Chooser) can simply disappear or could the problem be that somebody else is accessing my mailbox? It happened to me that the From field and Subject field have simply disappered twice without my action? Could it be a bug or something similar? Is it possible those fields are already in the table view? I've been spooked by that one before. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstar...

authentication #2
I seem to keep getting a password and ID prompt in outlook for my HTTP Hotmail account even though I am entering the correct password and ID because i can get to this account over the internet. remember my password is also checked in tools\account\properties etc. Version of Outlook? Does it work if you log into the site in a browser? -- Diane Poremsky [MVP - Outlook] Need Help with Common Tasks? http://www.outlook-tips.net/beginner/ Outlook 2007: http://www.slipstick.com/outlook/ol2007/ Outlook Tips by email: dailytips-subscribe-request@lists.outlooktips.net Exchange Messaging Outlook ...

MsgBox #2
I have been search the web for hours looking for example spreadsheets using MsgBox to no avail. Can someone direct me in the right direction? What I am looking to do is ask a question and if the answer is "yes" do 1 thing and if "no" do something else. "Ed Davis" <ed.davis1@verizon.net> wrote in message news:4EBF4D2F-7C3F-4BAB-8366-A1C744276744@microsoft.com... >I have been search the web for hours looking for example spreadsheets using >MsgBox to no avail. > Can someone direct me in the right direction? > Hi Look at this: Sub test()...