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 : New Users Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Concantenate columns with dates and text by Dazed and Confused
The first two columns in my spreadsheet are dates. The third is text. When I try to concantenate, the dates turn into numbers. Any advice would be greatly...
April 4th, 2009 01:07 PM
by Dazed and Confused Go to last post
4 216
Counting cells with a calculated value. by dugasyl
I have been trying without success to do the following in 2007: Count cells in a named range (Col."H" abt 300 out of 1000 lines containing data) that are =...
April 4th, 2009 08:19 AM
by Jerry W. Lewis Go to last post
3 151
how to find blank cell in column by vinod
ex in column a a1=1 a2=2 a3=3 a4=4 a5=blank which formula for finding blank cell (a5)
April 3rd, 2009 08:27 PM
by Luke M Go to last post
1 172
ABS = and logic functions by DrPhil
I'm having trouble with this function =IF(ABS(G30-F30)=0.2,"PASS","FAIL") If the numbers in G30 and F30 are bigger than 31 it returs false when equal to...
April 3rd, 2009 04:43 PM
by DrPhil Go to last post
5 189
Selecting the first cell of the last row in a range by Susan Ramlet[_3_]
A co-worker asked me how to programmatically select the first cell of the last row in a range in Excel 2003 (Windows XP). We found the Help reference to...
April 3rd, 2009 04:35 PM
by Don Guillett Go to last post
5 301
I know how to use 2003 with statistic but I'm having trouble with by phoenixs_paiste12
I know how to do Statistics tests like the T-Tests and Median tests, for the Excel 2003 but I'm having trouble with the Excel 2007. I need to get the median...
April 3rd, 2009 01:50 PM
by Bernard Liengme[_2_] Go to last post
2 231
Copying Macro by John Calder
Hi I run Win XP with Excel 2K I have a worksheet with a pivot table on it. I would like to copy the grand totals of the pivot table into another...
April 3rd, 2009 08:00 AM
by John Calder Go to last post
2 156
How to clear the lowest 10 values from a list of 30 values by fap87
Suppose I have a database of 50 students. Each row starts with the name of the student and then marks of 30 quizes for each student. e.g.- Jack- 10 7 8 5 10 9...
April 3rd, 2009 07:40 AM
by Jerry W. Lewis Go to last post
3 242
calculate not working by Janet
I'm having the same problem as Tony. My formulas are suddenly not working. I've turned calculate auto and manual. tried saving, closing & reopening file...
April 3rd, 2009 07:00 AM
by Jerry W. Lewis Go to last post
4 147
converting a 4 figure number to time in active cell by Pee
Hi, I've got 2007 on my pc and I'm trying to set up a timesheet. As I'm to lazy to keep entering the ":" all the time, i was wondering if someone knew how to...
April 3rd, 2009 12:45 AM
by Pete_UK[_5_] Go to last post
1 235
SORTING by robo
i have a spreadsheet with 4 columns and multiple rows. the columns are point number,reading,date and time. how do i set up the columns so i can sort the data...
April 2nd, 2009 09:10 PM
by David McRitchie Go to last post
2 138
What formula should I use to count a number of records? by Princesshera1
I have a list of computers....I want to count the total number of computers in my list. I'm going nuts...it should be simple, but I can't figure it out!!!
(Multi-page thread 1 2)
April 2nd, 2009 06:05 PM
by Francis Go to last post
12 246
How to graph x-variable versus y-variable in Excel ? by Mojjara
I feel this is a very basic challenge .... but it seems beyond my ability ...... I after much trial and error .... i humbly approach the masters' feet !!! I...
April 2nd, 2009 05:38 PM
by Bernard Liengme[_2_] Go to last post
3 264
Subforms using same table by MKuria
Is it possible to create 2 subforms using the same table and how do I link them? I need one to show fields to populate and one to show cust...
April 2nd, 2009 04:04 PM
by MKuria Go to last post
0 180
format cells from mm/dd/yyyy to yyyy by bbane
I am trying to convert the format of a column of cells from mm/dd/yyyy to yyyy. I used format cells, custom, and yyyy. The cell will change to the yyyy...
April 2nd, 2009 03:42 PM
by bbane Go to last post
3 135
Color coding dates in excel by Hilly
Hi , I am trying to set upo a spreadsheet to track stock market purchases,dividends etc. I have date columns, however I would like to be able to color code...
April 2nd, 2009 12:05 PM
by Stefi Go to last post
7 211
Formula stopped working by Tony
I'm having a rather odd problem with my Excel formulas and hope someone can help me. Within the week, my Excel spreadsheet formulas have simply stopped...
April 2nd, 2009 09:50 AM
by Tony Go to last post
2 154
Select the first cell of the last row in a range - Excel 2003 by Gary''s Student
Is this good enough: Sub ordinate() Set r = Selection nFirstColumn = r.Column nLastRow = r.Rows.Count + r.Row - 1 Set first_cell_in_last_row = Cells(nLastRow,...
April 2nd, 2009 12:56 AM
by Gary''s Student Go to last post
0 105
Updating data from one worksheet to another by joe2017
I've created an in-depth spreadsheet to organize information. I need to then take a few columns of that information and put it into a more concise, easier to...
April 2nd, 2009 12:24 AM
by AltaEgo Go to last post
3 176
how do I change email server info? by tvorhees3
I am trying to send document in email and didnt set server (pop) options right, now cant get back to it.
April 1st, 2009 11:38 PM
by Gordon[_13_] Go to last post
3 127
Post New Thread


Display Options
Showing threads 1841 to 1860 of 13737
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:52 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.