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
Final attempt save as binary question by Kevryl
This is about my fifth attempt since March, so far without eliciting a single reply (last attempt seems to have disappeared into the ether): Re Excel 2007...
June 1st, 2010 07:17 AM
by Kevryl Go to last post
6 379
Date Related Query by sandy
hi need help again.... I have this Data Date Submitted On-Time 3/14/2010 x 5/29/2010 x 3/12/2010 I have to count the number of on time...
June 1st, 2010 06:54 AM
by Ms-Exl-Learner Go to last post
1 312
Angry
Undeletable mark--amazing properties by Don_Texas
A mysterious, undeletable mark appeared in an Excel 2003 spreadsheet. It looks like a forward slash, but half-length and more sloped (45-deg.). It won't...
June 1st, 2010 02:43 AM
by Don_Texas Go to last post
0 436
Getting contents of adjacent cells by Rocky
I want to divide the y1-axis column and save it to radius (y1/2) column. How do I do...
June 1st, 2010 02:01 AM
by FSt1 Go to last post
1 373
Input box to find date by Tom[_55_]
Hi, As part of my macro, how can I make an input box (or whatever box) to pop up and ask the user to input a date - e.g. 25/06/2097? On clicking OK, it then...
June 1st, 2010 01:24 AM
by Tom[_47_] Go to last post
4 409
I want to add or subtract a range of cells by wormburner
I am trying to add a range if another range is "D" or subtract if the "D" is an "R". I have used SUMIF to add the range but cannot figure our how to not add...
May 31st, 2010 11:03 PM
by T. Valko Go to last post
2 435
Unwanted reformatting of protected cells by USAOz
I have a number of spreadsheets in which I have columns formatted in a particular way - e.g. Time to display 00:00:00 or ID formatted to display as a Number...
May 31st, 2010 08:58 PM
by USAOz Go to last post
0 337
Excel 2007 - Copy Picture Resolution by XLUser
When I select cells to copy as a picture in Excel 2007, the resolution is terrible. Text and objects with shadow's are very blotchy when pasting the...
May 31st, 2010 07:11 PM
by Jon Peltier[_2_] Go to last post
1 497
Simply Array Formula? by Going Crazy with excel[_2_]
I have a column of numbers. Looking for an array formula that will identify and highlite the "highest" three values. Does such an animal exist?
May 31st, 2010 07:03 PM
by jkiser Go to last post
6 397
Filter on Pivotable by tran1728
Dear All, pls help me. I work with Pivitable : Iem , Code and Qty. exemple: Item Code Qty 1234 10AA 25 1424 25BB 52 1475 10AA 32 1475 ...
May 31st, 2010 06:01 PM
by tran1728 Go to last post
0 269
Date Format Problem by Alain
I have a worksheet with a column formatted as 022008 which is suppose to mean Feb 2008 or 02/2008. I can't seem to figure out how to change the cell format...
May 31st, 2010 04:53 PM
by David Biddulph Go to last post
2 362
Mnthly auto ,shift schedule for multi employee by Balbir
I am incharge of multi employee and need to schedule monthly shift duty as: Weekday (Monday to friday)-1730-2300 weekend ( saturday-sunday and public holiday)...
May 31st, 2010 04:21 PM
by Balbir Go to last post
0 300
Excel 2003 - using VBA to post to alternative worksheets by BJ&theBear
I have a complicated macro which posts a series of entries to a worksheet called "expenses" but I am sending a copy of some sheets of this workbook to all the...
May 31st, 2010 01:32 PM
by Sheeloo Go to last post
1 437
Exporting the values to excel error by Karthik
Hi All, I am trying to exporting the values as '10-02' and '10-03' from my developed application (developed in .Net). These values are stored as 02-Oct and...
May 31st, 2010 01:21 PM
by Sheeloo Go to last post
1 369
Separate the boys from the girls? by Quin
I would like a simple function that can help keep a dynamic count of males and females assigned to a section. For example we will say there is a list of 100...
May 31st, 2010 04:49 AM
by Quin Go to last post
3 352
How to clear up useless content within worksheet? by Eric
When I copy and paste the whole worksheet for editing, and delete some useless content, but I find out the file size of worksheet is almost the same, I am...
May 31st, 2010 04:39 AM
by Max Go to last post
1 372
How 2 sort an autosum total list after adding items 2 autosum item by akm
Am using detail dollar amount list to insert new transactions in the middle of a the detail list, and they in turn get included in the 'autosum' total calc...
May 30th, 2010 11:44 PM
by akm Go to last post
0 360
Sumif/SumProduct/lookup question by Confused in TX
I want to insert subtotals only for items containing at least two specified costs. A B C 1 Item Name Cost Title Cost...
May 30th, 2010 11:09 PM
by Confused in TX Go to last post
1 325
Sort problem by Emece
I have the months of the year in one column. I need Excel to sort the months, but according to calendar. I need January, February, March and so on. But if I...
May 30th, 2010 11:04 PM
by Bob Phillips[_3_] Go to last post
1 416
Hard to select first worksheet tab by Dennis Marks
When you click on the icon in the upper left of a window a box appears with: Restore Move Size Minimize Maximize Close With Windows 7 the box also appears when...
May 30th, 2010 08:58 PM
by Gord Dibben Go to last post
7 586
Post New Thread


Display Options
Showing threads 261 to 280 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:39 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.