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 Reverse Sort Order Replies Views
Splitting Data from One Worksheet to Many Automatically by Richard
Is it possible to split data from one worksheet to seperate worksheets based on a criteria in Column A, e.g. day / month / surname / etc. I have a master...
May 6th, 2010 11:10 PM
by Richard Go to last post
3 354
Conditional Formatting - Test Practice by downinfl
I want to design a test for my students, who need to memorize -- verbatim -- a list of 37 characteristics. I would like to use an Excel 2007 spreadsheet to...
May 6th, 2010 10:49 PM
by downinfl Go to last post
0 258
Sumproduct Problem (AB) by albertmb
Hi everyone, can you please sort out this problem for me? SUMPRODUCT(('Client Opening Stock'!B2:B138=$A$1)*('Client Opening Stock'!C2:AH138=A7),'Client...
May 6th, 2010 10:08 PM
by Scott Gall Go to last post
4 220
Formula to Convert Numbers to Words by Kiley
What is the formula to convert numbers to words? Example: Number Words 568 Five Hundred Sixty Eight
May 6th, 2010 10:07 PM
by EricG[_2_] Go to last post
3 266
Formating Dates by LovingLife28
I need to update a list of dates to show all days as 01. For example, where date shows 03/28/2009, I need it to read 03/01/2009. I appreciate any...
May 6th, 2010 09:35 PM
by LovingLife28 Go to last post
4 142
Preview Excel 2007 files in Outlook from SharePoint by Barb Reinhardt
I'm not sure if this is the best place to post this, but it's a start. I have a SharePoint document library interfaced to Outlook and I've been able to...
May 6th, 2010 08:48 PM
by Barb Reinhardt Go to last post
0 145
Auto sorting to match by Very Basic User
Hello All, I have a spreadsheet that automatically sorts catagories by largest loss or lowest # in another column. My original data is not sorted in the same...
May 6th, 2010 08:33 PM
by Squeaky Go to last post
1 142
TABLE ROW SORT ERROR? by RAY
Hi all - I have a 22+ column by 867 row table. Three columns host formulas on each row that refer to values on the same row. Everything is fine until I...
May 6th, 2010 08:20 PM
by Squeaky Go to last post
1 179
How do I change Font color specific text by jlr
How do I change the font color in the first 4 letters of text in a column of cells? Thanks. -- jlr
May 6th, 2010 08:19 PM
by Gary''s Student Go to last post
1 132
Conditional Formatting according to the date the data is entered by hadeeter
I'll do my best to explain my question, please let me know if more information is needed. I have a "calendar" of sorts that is in Excel format. It lists...
May 6th, 2010 08:16 PM
by Squeaky Go to last post
1 179
Formula to breakdown original amount with two components to the pe by K. Carter
I need a formula that will breakdown an original number with two components into multiple components which then add up to the original. The example below...
May 6th, 2010 07:35 PM
by Niek Otten Go to last post
3 166
Highlight specific text by jlr
How do I highlight specific text within a cell in Excel 2003 in all rows? -- jlr
May 6th, 2010 07:21 PM
by jlr Go to last post
1 145
sub total value by creating a reference list
I have 4000 lines of data and I have used the sub total function to obtain the value that I need. How can I sort the data by the sub total value?
May 6th, 2010 07:17 PM
by Jim Thomlinson Go to last post
1 139
Excel subtotals by Michele
I have a list that is approx 2000 rows by 8 columns (A:H) which needs to be subtotaled in Column H on each change in column G. Once the list is subtotalled...
May 6th, 2010 07:00 PM
by Luke M[_4_] Go to last post
1 112
Copy and Past Values AND Formatting AND Text by KKD
I want to copy and paste a section of my spreadsheet, however, I can't seem to find a way to copy the formatting, the text, and the values. If I try to use...
May 6th, 2010 06:25 PM
by Don Guillett[_2_] Go to last post
1 157
Adding up hours and minutes by Dave
Hi, I need to add up a list of hour and minutes, the only problem being is that Excel treats them as TIME not hours and minutes. For example, if I sum 7:24,...
(Multi-page thread 1 2)
May 6th, 2010 06:06 PM
by Tacrier Go to last post
19 507
grouping Radio Buttons; Using ActiveX Controls by ryguy7272
Hello experts! I’m trying to enter radio buttons on a sheet (not UserForm) and I’m using ActiveX Controls (I don’t want users moving the controls...
May 6th, 2010 06:01 PM
by ryguy7272 Go to last post
2 226
Top 5 recurring text values with count by S
My data: Col 1 Apples Oranges Oranges Bananas Apples
May 6th, 2010 05:43 PM
by S Go to last post
2 188
Time in Seconds Only by Chad Cameron
Hi All, I have to enter a bunch of times that are less than 1 minute. Is there an easier way to enter times than 0:0:15? I would like to just enter 15 and...
May 6th, 2010 05:40 PM
by Eduardo Go to last post
2 125
How can I restore a column that was deleted by mistake by Lucia
How can I restore a column that was deleted by mistake after I have saved the document. Can one go back to a previous saved version stored in excel...
May 6th, 2010 05:22 PM
by Paul C Go to last post
3 157
Post New Thread


Display Options
Showing threads 1241 to 1260 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 03:23 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.