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 : Worksheet Functions Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Reverse Sort Order Last Post Replies Views
Sort a column (specifically email data) by end of text, not beginn by Zip code help
One of my files contains a field of Emails. I want to sort it by the ISP, not the beginning of the text. so if an email is , I want to sort it so I...
October 14th, 2005 07:13 PM
by Zip code help Go to last post
4 103
Sortin method advice please by Zipadeedoodaa
I am new to excel and would like some advice please. I am treasurer for a forthcoming concert. All the seats are numbered in the concert hall. As the bookings...
January 17th, 2006 09:53 PM
by Zipadeedoodaa Go to last post
2 67
Array formula needed by ZipCurs
I want to perform an sumproduct type of function with on column of data (1 x n) and the minimum value in each row of a 2 x n matrix. Is there a simple formula...
December 17th, 2005 03:16 PM
by B. R.Ramachandran Go to last post
4 109
Keeping Control Buttons Still by ZipCurs
I have created an interface sheet with a number of control buttons on it. I do not want the buttons to move or change size. I have set the properties...
December 14th, 2005 11:41 PM
by ZipCurs Go to last post
1 83
Printing spreadsheet print area to 1 page fails to shrink image en by zipidy
Print scaling fails to shrink image enough to print on one page (even though Print Preview shows the data fitting in one quarter of a page). If I try to...
June 25th, 2009 02:46 AM
by zipidy Go to last post
0 97
header/footer by zipper
How do you use the & key in header, the & doesn't appear
June 28th, 2008 02:40 AM
by Dave Peterson Go to last post
1 50
Currency vs. Accounting Format by zippy
I see the differece between these formats, but I'm wondering why or when one should be used over the other? Thanks for your ideas.
July 19th, 2006 02:59 AM
by zippy Go to last post
0 58
Splitting information in cells by Zippy
I need to split information in one cells into various cells. EG B1 holds an address, 11 One Street, Kookoo, 1111. I want to divided that info into A1- 11...
August 15th, 2008 01:38 PM
by tech1NJ Go to last post
7 58
Display cell contents in one xcell doc. from another xcell doc. by Zippy
I am trying to display data from an xcell workbook "A" in another xcell workbook "B". I tried linking the cells using a hyperlink but all that did was pull...
May 25th, 2006 07:10 PM
by [email protected] Go to last post
1 80
Remove Password by Zita
I want to remove a password from a workbook so it opens without one. It is unshared file.
July 21st, 2009 07:33 PM
by Gord Dibben Go to last post
3 73
Macros and security by Zita
I have check boxes in my excel sheet. When I click a box and save as (I think enabeling macros), the next time I open it, I cannot change the check unless I...
January 15th, 2010 08:26 PM
by Zita Go to last post
0 77
cannot paste link using equal sign by zizu
I cannot make a paste link between 2 worksheets in excel 2003 if I use equal sign (=). For example I have data is in Sheet1!A1, and I want to copy it to...
October 31st, 2006 08:56 AM
by David Biddulph Go to last post
1 66
Date/time Duration by zjay
How do I make a formula in excel which will allow me to calculate the duration in hours and minutes of two different dates and times? IE: 1/1/05 01:00 to...
May 24th, 2005 10:58 AM
by Bob Phillips Go to last post
1 69
Template to convert column of text to time by zjopa
I manage an afterhours call center and need to know how to convert the time column in the call history reports I export as .xls into time. I've included a...
October 15th, 2007 03:02 PM
by zjopa Go to last post
0 48
August 27th, 2004 04:58 PM
by Frank Kabel Go to last post
1 251
Mail a different files to each person in a range by [email protected]
Hello I've found this macro on a great website http://www.rondebruin.nl/mail/folder2/files.htm -------------------------------------------- Make a list in...
September 2nd, 2005 02:00 PM
by Ron de Bruin Go to last post
5 180
Across a worksheet, which cells I have formatted as locked? by ZM
How do I tell which cells I have formatted as locked in an excel worksheet without looking at each one individually?
October 27th, 2005 01:34 PM
by Ian Go to last post
3 109
Very puzzling - how do I reference cells without the blank rows??? by ZMAN
Hi, here is something that should be much simpler to accomplish but somehow is very difficult to figure out. Basically, for simplicity's sake, let's say I...
August 28th, 2006 07:36 PM
by Ken Wright Go to last post
5 46
How do I match up two tables of data with one column in common by Zman
I have two data tables and each one has a reference column in common. How do I match up the two data tables with by that reference column?
October 24th, 2006 09:56 AM
by Ken Wright Go to last post
1 69
SUMIF for Dates / Months ? by ZMAN
Hi, I have a spreadsheet that has every day of the year (1/1/2004 to 12/31/2004) and I am trying to sum a column next to it to get only totals for each month. ...
August 26th, 2005 02:07 AM
by ZMAN Go to last post
5 154
Post New Thread


Display Options
Showing threads 87581 to 87600 of 87787
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 12:06 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.