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 : General Discussion Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Replies Reverse Sort Order Views
Compare and consolidating duplicated rows by Jen
I have a worksheet that has over 4000 rows and 50 columns of information. An individual may be listed multiple times. I am looking to compare the information...
(Multi-page thread 1 2 3)
March 4th, 2008 09:49 PM
by Tony S. Go to last post
20 244
convert a text date to a true date by JR Hester
I am out of ideas. Excelâ„¢ XP on WinnXP. I have acquired a spreadsheet "database" from another user. approximayely 5K records with dates in the dddd, m-d-yy...
(Multi-page thread 1 2 3)
November 15th, 2007 08:15 PM
by T. Valko Go to last post
20 249
Filter question? by AOP
At the moment I have a data sheet that details are entered using a userform. It finds the last empty row and enters the data from columns "A" to "AF" Is there...
(Multi-page thread 1 2 3)
April 2nd, 2008 08:22 PM
by c g Messinger Go to last post
20 170
Formula to consolidate numbers? by FJ
Hi, I have I have a spreadsheet with about 65,000 rows. I have to consolidate the data so that ranges of numbers with no breaks (in other words, where the...
(Multi-page thread 1 2 3)
December 14th, 2007 09:42 AM
by carlo Go to last post
20 245
Calculating the mode of a criteria-based range by PaladinWhite
I have two columns of data. I want to calculate the mode of some cells in the first column - including only those cells whose corresponding cell in the...
(Multi-page thread 1 2 3)
August 9th, 2008 02:50 AM
by T. Valko Go to last post
20 252
how to add attachment in a CDO mail by Julaf
Hi everyone, I've got a small problem. I'd like to send my active sheet with a CDO code. I use .AddAttachment ThisWorkbook.ActiveSheet but it looks...
(Multi-page thread 1 2 3)
August 19th, 2008 04:36 PM
by Ron de Bruin Go to last post
20 389
Look up one number based on mulitple criteria!!!! by scottgorilla
I have a list with two possible numbers but each number has several criteria A1 B1 C1 DIAMETER LENGTH MAX WEIGHT 70 ...
(Multi-page thread 1 2 3)
August 5th, 2008 05:22 PM
by Bob I Go to last post
20 218
Cross-posting by SwearBear
How do I cross-post to more than one discussion group. I had a question that I wanted to post to both the Excel Programming discussion group and the Excel...
(Multi-page thread 1 2 3)
August 14th, 2008 02:19 PM
by Bob I Go to last post
20 219
Import Access Table into Excel. I appreciate your assistance. Thanks! by Damil4real
I have a table in Access called "Invested Related". All the analysis is to be done in Excel. I want to implement a button in EXCEL. Such that when the user...
(Multi-page thread 1 2 3)
September 15th, 2008 08:29 PM
by Ron de Bruin Go to last post
20 262
Help in finding Value in Index Array by George
I am trying to search a column (C5:C400) to find out when it runs to a null value, then search down a different column (G) starting from that same row and...
(Multi-page thread 1 2 3)
October 30th, 2007 12:48 AM
by RagDyer Go to last post
20 155
blank sheet by Rider
Can anyone tell me how to print a blank spreed sheet with the grid lines, so I can hand write my own info? thanks
(Multi-page thread 1 2 3)
July 19th, 2007 02:18 PM
by Bob I Go to last post
20 170
count text occurences in a column by Daniel_ITSM
I am not proficient with Excel. My challenge is to find out how many times a term is used in a very long column. PROF_CARER_EPISODES PROF_CARER_EPISODES,...
(Multi-page thread 1 2 3)
March 7th, 2007 09:46 PM
by Dave Peterson Go to last post
20 209
Locking/Unlocking cells upon condition by Brettjg
I have put the following code into the worksheet code but it doesn't work. Can someone put me straight please? Private Sub PERSONAL_LOCK() If...
(Multi-page thread 1 2 3)
March 12th, 2007 07:01 AM
by Brettjg Go to last post
20 152
Numbers aren't numeric? by Al Randall
Suddenly my Excel 2003 started acting "wierd". Numbers entered on a NEW spreadsheet as numbers (1,2,3.45, etc) are being treated as "characters" rather than...
(Multi-page thread 1 2 3)
March 23rd, 2007 08:56 PM
by Dave Peterson Go to last post
20 151
Co-ordinates by [email protected]
Hi, I have two circles. I have the co-ordinates and radius of the first circle and the second circle. The condition that should be checked is, if the...
(Multi-page thread 1 2 3)
April 20th, 2007 04:37 AM
by [email protected] Go to last post
20 248
Userform combobox question by teepee[_2_]
Hello I have a userform combobox which is linked to the values in column A I want to find a way in VBA so that when an item is selected from the drop down...
(Multi-page thread 1 2 3)
May 16th, 2007 09:42 AM
by teepee[_2_] Go to last post
20 145
Excel: How copy all rows that have a given column entry? by Motown Mick
Do you know a quick and efficient method on how to mark or flag somehow, and copy to the clipboard, all the rows in a worksheet that have an entry in a given...
(Multi-page thread 1 2 3)
June 12th, 2007 06:56 PM
by Motown Mick Go to last post
20 188
The Callaway Handicap System by Duncs
I've read several posts in the group, in relation to the above. I've also tried, unsucessfully, to download the templates / files that people have posted...
(Multi-page thread 1 2 3)
July 30th, 2007 08:22 AM
by Duncs Go to last post
20 363
Formlua Error! by Killer
Hey guys need help on this formula as I keep getting a #REF! Error that won't list what is required from cell AN15. The formulas below are as follow. Cell...
(Multi-page thread 1 2 3)
June 28th, 2007 05:29 AM
by T. Valko Go to last post
20 280
how do I calculate a difference in dates in years and months? by Dan Cotts
In the Help menu, I can see how to do it in years, and I can see how to do it in months, but how do I do YY, MM? - I am trying to calculate retirment ages.
(Multi-page thread 1 2 3)
October 30th, 2008 02:29 PM
by Bob I Go to last post
20 196
Post New Thread


Display Options
Showing threads 181 to 200 of 139764
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 09:48 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.