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 Last Post Reverse Sort Order Replies Views
How to unhide column? by Lois Corp Secy
I hid column E, did some other work on the spreadsheet, now cannot unhide column E
May 18th, 2010 08:21 PM
by Gord Dibben Go to last post
2 165
Creating backgroound for an Invoice by Gary
I am creating an invoice using Excel. The invoice has already been created and is fine. I am now just trying to input a header and footer with a middle. I...
May 18th, 2010 08:16 PM
by Gord Dibben Go to last post
1 196
Ability to sort data in Excel by fill color by okquiltluvr
We often use fill colors to designate different values. It would be helpful to be able to sort using these colors, to obtain value...
May 18th, 2010 08:08 PM
by Gord Dibben Go to last post
2 186
PLEASE HELP by sagenichole
Ok I am trying to make the document where if I enter "a" in one cell, the cell next to it will auto populate a given value that I define. Please let me know...
May 18th, 2010 07:33 PM
by Gord Dibben Go to last post
3 182
Time formula by Dottie
Working with a spreadsheet (Excel 2007) that has a start time, end time and time Start Stop time 14:00 15:18 1:18 Would like to convert time to minutes and...
May 18th, 2010 07:12 PM
by Luke M[_4_] Go to last post
5 126
Convert a text in a date format by xBeckx
Hi I have imported a file where there is a field that is suposed to contain a date. It was transformed in text, like 22FEB2010. I need to treat this field as...
May 18th, 2010 07:08 PM
by Gord Dibben Go to last post
2 166
Auto saving sheets from a workbook as separate files. by Colin Hayes
Hi I need some help with some VBA code. My workbook has 50 sheets. Numbered 1 - 50. I'd like to have a macro save each sheet as a separate file to a path...
May 18th, 2010 06:50 PM
by Ron de Bruin Go to last post
1 308
Find the last number in a row by David Brogelli
Hi, I have lots of rows of data which are either a value between 50 and 200 (e.g 115) or "0". Each column is a specific week of the year, ie from 1/1998 to...
May 18th, 2010 05:17 PM
by T. Valko Go to last post
5 204
Combine data into central worksheet by Candida
I have a main costing work sheet that needs to be populated by individual costing sheets that went out to all of the buyers to populate. Main Costing...
May 18th, 2010 05:17 PM
by Don Guillett[_2_] Go to last post
1 139
Separate Date from a Text String by Sara
The data that I have looks like this: And I would like to just get the date like this: 10/24/10 Is there any way to do this in Excel with a...
May 18th, 2010 03:41 PM
by Sara Go to last post
3 174
Formulas by Raja
I wanted to enter a number in a cell for example 10 in A2 and this number should be converted into a letter say "A"in A2 cell. How could it be done?
May 18th, 2010 03:13 PM
by Jacob Skaria Go to last post
2 152
Formula to figure out months between two dates by Kimbe
I have an excel spreadsheet that I download from a vendor that has the dates listed as MAY/17/2010 - JUL/31/2011 and I am not able to use my existing formula...
May 18th, 2010 02:49 PM
by Jason[_11_] Go to last post
2 142
Define a Value by sagenichole
Thank you to those who posted to my question earlier, but just to give a little more insight on what I am trying to do: I have a scroll list in one cell and I...
May 18th, 2010 02:41 PM
by Luke M[_4_] Go to last post
2 144
How do I ensure formulas automatically calculate after pasting by wohners
I have just recently installed Excel 2003. When I copy and paste a formula into a column the result of the first cell copies down the column and I need to...
May 18th, 2010 01:18 PM
by Jacob Skaria Go to last post
1 222
Copying "Exact" Function by Nats_uk
I have an excel spreadsheet with two columns, legal forename and preferred forename. I ran a "exact" function so it would appear true if the two surnames...
May 18th, 2010 01:04 PM
by Dave Peterson[_2_] Go to last post
2 132
Repeat Sort in Excel 2007 by Kevin K[_2_]
In Excel 2003 you can repeat sort parameters for different sections of a worksheet by using the F4 function key after performing your 1st sort, but I can't...
May 18th, 2010 12:23 PM
by Peter Lingenfelter Go to last post
4 201
Formula to get date from text string by Sara
This is what the cell currently looks like: I would like the formula to return only: 10/01/09 Does anyone know what formula I should use? Any help would be...
May 18th, 2010 10:51 AM
by Roger Govier[_8_] Go to last post
2 168
Which function will shorten IF-THEN-ELSE ? by Jack Ryan[_2_]
Here's a simplified example of what I want to do: Col A Col B Row 1 yes 5 Row 2 10 Row 3 yes ...
May 18th, 2010 10:02 AM
by Jack Ryan[_2_] Go to last post
0 124
Formula to obtain result from non exact sequence match by The Hit Man
I know this has to be easier than I currently do it. I have seen examples similar using exact matches or dates but nothing using ranges. I can obtain the...
May 18th, 2010 06:18 AM
by The Hit man Go to last post
2 161
Sum Formula dilemma - Can yu Solve? by Tom
Have a column for item id and a column for its Qty. What I need to do is have a sum of all the item id quanitities whose item id is either a 1, a 3, or a 7....
May 18th, 2010 04:04 AM
by ozgrid.com Go to last post
3 188
Post New Thread


Display Options
Showing threads 481 to 500 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 06:04 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.