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 count/tally entries? by chrisk
Hi I want to put a number by a name for each job a staff member...
April 16th, 2009 04:41 PM
by chrisk Go to last post
2 87
Text to rows by Phippsy
I have text in a cell which has been forced onto separate rows within the same cell. Can I split this into several rows so there is one line in each new row?
April 16th, 2009 04:12 PM
by Phippsy Go to last post
6 108
Lookup Function by Wasdell
I am trying to lookup an exact text cell and convert it to a numeric value eg If cell x3 = A15C then the answer will be 15
April 16th, 2009 03:54 PM
by klswvu[_2_] Go to last post
2 180
how to move contents in column up one cell by pmt
How to I move contents in a column up one cell/row within same column?
April 16th, 2009 03:47 PM
by klswvu[_2_] Go to last post
2 78
Today() function by Steve
I hope you guys can help me. I have used the Today() function many times, but now, I am at a new company and the Today() function only displays ###### The fx...
April 16th, 2009 02:32 PM
by Luke M Go to last post
2 69
Flatten password file by PSM
I have a spreadsheet with that is password protected and has the following code also included. I would like to let the user save the tab they are working on...
April 16th, 2009 01:57 PM
by Tom Hutchins Go to last post
3 85
How do I complete this nested if formula by Bobbybee
This formula is working for the condition "If Long" but how do I add "If Short" in a nested formula thats checks both...
April 16th, 2009 01:54 PM
by Luke M Go to last post
1 71
Text to Number by Steve
I have over 50 items with multiple price points. I can not seem to figure out how to make the price automatically fill in once I either import or type in the...
April 16th, 2009 01:14 PM
by Luke M Go to last post
3 71
Calculate the number of hours in a date/time cell by richardwo
Morning, I created a pivot table showing the sum of handover delays. If there were a total 11hrs 40-mins delayed in a week then it correctly returns...
April 16th, 2009 11:48 AM
by Jacob Skaria Go to last post
1 72
Red face
Time/priority problem by sonic-the-mouse
I am trying to set up a spreadsheet to report on how we are meeting our priority orders in line with time constraints col A - Date Col B - Time order in...
April 16th, 2009 11:23 AM
by Jacob Skaria Go to last post
2 93
how do I use a cell from one worksheet in the equation of another by jpw
I am working on a workbook that has three worksheets. I want to use a cell value from the first worksheet in the formula of a cell in the third worksheet. ...
April 16th, 2009 10:57 AM
by mclwlg Go to last post
3 115
Stuck on Formulas by megsmom85
I'm having a complete block with my basic formulas. I'm trying to create an Excel formula that will total the percentages in columns E through P (which are...
April 16th, 2009 09:29 AM
by JudithJubilee Go to last post
1 75
Numbers of repeats of a string by Luciano Paulino da Silva
Dear all, I am looking to detect repeats (sequences of letters or numbers which are repeating at least twice within a string) in some strings containing...
(Multi-page thread 1 2)
April 16th, 2009 09:12 AM
by macropod[_2_] Go to last post
11 115
Taking Average ignoring #DIV/0! in the range... by Astro
Currently if I use the average function for the months, it will show the results to be "#DIV/0!". What formula can I use such that when theres only data for...
April 16th, 2009 07:59 AM
by T. Valko Go to last post
1 306
EDATE Function disappears intermittently by Wendy
Hi all, Hope somebody knows the answer to this one. I have a new computer set up, which has Excel 2003 installed (11.8237.8221) SP3. The Analysis Tool Pack...
April 16th, 2009 07:49 AM
by T. Valko Go to last post
1 62
Pivot Table - Old remaining values for rows by ZorionK
Dear experts, We are developing some reports with MS - Excel, using pivot tables. We created a pivot table, pointing to some information in the same XL...
April 16th, 2009 06:36 AM
by ZorionK Go to last post
3 86
solver an uxexpected internal error ocurred, or available memory by Jorge A.
Office 2007 when I use Solver option show message below : "solver an uxexpected internal error ocurred, or available memory was exhausted" Someone has an...
April 16th, 2009 05:29 AM
by Jacob Skaria Go to last post
1 83
Quarters by PAL
I have a few hundred rows, one of the columns has a date, the other column a number value. I want to group the dates by quarters (the range is 3 years back...
April 16th, 2009 05:24 AM
by Jacob Skaria Go to last post
1 61
filtering or selecting data baseed on time of day by TBA
Hi there. I have rows of date, one field is a start time that has full date and time of day a phone call was initiated. I want to filter only those calls...
April 16th, 2009 05:11 AM
by Jacob Skaria Go to last post
1 68
displaying changes by Kackels
I am needing to display the date and time that text is entered into a specific cell, and it not change. - is that possible? = example - if and address is...
April 16th, 2009 04:09 AM
by Tom Hutchins Go to last post
1 83
Post New Thread


Display Options
Showing threads 12081 to 12100 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 02:19 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.