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
Converting "special data" into number in the same column by PaulinaDi
Hello. As one of my last questions, as I get some info from an internal program, I have to work it in Excel and it's a little crazy to convert each month...
September 25th, 2008 04:33 PM
by RagDyeR Go to last post
4 247
match by Atishoo
is there a quck formula to identify if any value at all occurs twice within a range?
September 25th, 2008 04:28 PM
by Atishoo Go to last post
3 149
Question regarding comments by Fusion1337
Hi everyone. I was wondering if it would be possible to make different comments to appear in the same cell depending on a selection from a...
September 25th, 2008 04:17 PM
by Fusion1337 Go to last post
2 158
Plotting in Real-Time by carl
I am tracking a stock price and have a spreadsheet that shows me the last trade. The value will change whenever there is a trade. Is there a way to plot the...
September 25th, 2008 03:59 PM
by carl Go to last post
0 104
How do you wrap text in Excel? by mlt51907
I am trying to use Excel 2007, and I cannot get the colum to format for alignment = wrap text. If anyone knows how to get this to format properly, please let...
September 25th, 2008 03:40 PM
by Rick Rothstein[_2_] Go to last post
2 140
Vlookup is adding quotes! by Michael Enoksen
I am trying to count number people based on dates. On one sheet I have an array that has names and dates for a particular course. ABG!$F$501:$F$599 On...
September 25th, 2008 03:37 PM
by Dave Peterson Go to last post
3 142
Data Disappears When Closed by Shawn
Hi, I am working with an existing form in Excel. There are 4 tabs with different forms in each tab. When I close the workbook, the data in two of the 4...
September 25th, 2008 03:37 PM
by Spiky Go to last post
2 129
Creating reference numbers from column of data by LucasD
Hi, Here is what I am struggling with: The table will hold a thousand rows In one column there is a ref. number between 1 and 50 that I will input I would...
September 25th, 2008 03:23 PM
by Glenn[_6_] Go to last post
3 140
how to set up an IF formula by Gene
formula: sum(B1-C1)/C1. B1 is 200, C1 is 100 result is 100%. But when B1 is (200) and C1 is (100) the result is still 100% but should be (100%). How can I...
September 25th, 2008 03:22 PM
by Gene Go to last post
6 117
calculate month by RJ
How can I calculate the number of months (or years) between two dates, such as 06/11/2000 and 09/20/2005?
September 25th, 2008 03:06 PM
by Glenn[_6_] Go to last post
9 178
Compare 2 worksheets all 6 columns in each worksheet by Bud
Hello Each week we produce a report of peoples time and bill this. It has 6 column fields. The person entering their time can go back and change their...
September 25th, 2008 02:26 PM
by Bud Go to last post
7 187
Filtering by Colour by Colin Hayes
HI I have a worksheet of 650 rows. Certain of the rows are highlighted in green. How can I group the highlighted rows at the top of the sheet? Grateful...
September 25th, 2008 02:26 PM
by Bob Umlas[_2_] Go to last post
4 114
=SUMPRODUCT by LHerring
I have the below spreadsheet. In a separate spreadsheet, I need a formula to calcuate the cost (column C) of labor (Column A) under 346620.01.03.01 (Column...
September 25th, 2008 01:50 PM
by Teethless mama Go to last post
2 127
Referencing data across sheets by RDR
First i would like to attach a picture but I don't know how to, I would be happy to email it someone who would like to help rderoo at shaw . ca. It would...
September 25th, 2008 01:30 PM
by RDR Go to last post
2 138
If statement containing today formula by Christi
Hello. I have a spreadsheet with two sets of information that I am trying to compare. In columns D thru I, I have the kit information. In columns K thru L,...
September 25th, 2008 01:22 PM
by Christi Go to last post
8 110
Finding data between blank rows by j.ruderman[_2_]
A B 1 6:00 a 7:00 a 2 7:05 a 8:30 a 3 8:35 a 10:00 a 4 5 12:00 p 1:00 p 6 1:05 p 4:00p 7 8 6:00p 10:00p
September 25th, 2008 11:48 AM
by j.ruderman[_2_] Go to last post
2 112
How do I insert a dropdown calendar into a cell? by Jeff Kass, San Diego, CA
I am setting up a spreadsheet as a form. One of the cells will contain a date the form was filled in. I would like to make it easy on the user by making a...
September 25th, 2008 10:41 AM
by David Biddulph Go to last post
5 116
How do I set up a time sheet in Excel? by Julie Holmberg
What I need to do is have people enter the time they start, what time they leave for lunch, come back from lunch and leave at the end of the day. I want...
(Multi-page thread 1 2)
September 25th, 2008 08:38 AM
by David Biddulph Go to last post
11 188
How to differentiate groups of numbers by RodJ
eg: number group = 2,12,18,35,36,40. I need a function that will tell me how many numbers are under 22 and how many are over 23. Answer I am looking for...
September 25th, 2008 08:24 AM
by Max Go to last post
6 139
combine data in two cells into a third cell by ordnance1
In cell A1 is a number(9), in cell A2 is a number (0001). Is there any way to get cell A3 to show the result 9-0001?
September 25th, 2008 07:49 AM
by Max Go to last post
3 165
Post New Thread


Display Options
Showing threads 19901 to 19920 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 09:55 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.