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
Custom filters by Dudley
I created a custom filter on a city field, looking for all cities that start with So. The criteria used was begins with SO. THis works fine. I then...
October 22nd, 2004 05:50 AM
by VENKAT Go to last post
2 184
how do i locate student data files in excell by vigilba
I am a student trying to use microsoft office xp for students and teachers, I am having trouble finding the storage location of the student data files.
October 22nd, 2004 07:39 AM
by JulieD Go to last post
1 149
I am getting the error message "Cannot open consolidation source . by richuber
I am trying consolidation for the first time. I set up 3 files with data to consolidate, then i went to data -- consolidate, entered all the reference files...
October 22nd, 2004 08:37 AM
by JulieD Go to last post
1 163
macro cannot be found by Ydiv
I created a macro and called it Timestamp_on_save. It was originally supposed to populate a cell with the current time and date upon hitting the 'save' button....
October 22nd, 2004 11:23 AM
by Paul Cunliffe Go to last post
1 291
update month itervals automatically by Odart
If say something was done in May-04 and it's not due again for another 15 monthes how do I get excel to due the math and then when it get's done in 15 monthes...
October 22nd, 2004 05:13 PM
by Peo Sjoblom Go to last post
2 154
need more columns by Herm
Have used up all columns and need about 60 more can I add then and how or do I need to look at redesigning, can't rotate work as again still not enought columns
October 22nd, 2004 05:23 PM
by Frank Kabel Go to last post
1 142
Uppercase Input by L.A. Lawyer
I want to format a cell so that any characters inputted into that cell are automatically saved as uppercase in that cell. How do I do that?
October 22nd, 2004 09:28 PM
by Peo Sjoblom Go to last post
2 191
IF Function by sgrech
Here is a nice easy one! I have a value in a spreadsheet that I need to check. If the value -0.005% or 0.005%, then I need to notify the user that an...
October 22nd, 2004 09:31 PM
by Bob Sweet Go to last post
2 175
How do I create an employee schedule and vacation tracker? by Excellent
Never used Excel for this but I know it can be done.
October 22nd, 2004 09:34 PM
by bigwheel Go to last post
2 274
Deleting Blank Rows by PA
I am frequently importing data from other applications, into Excel 2002 workbooks. There are, many times, blank rows, with no pattern or in no way similar to...
October 23rd, 2004 12:17 AM
by Frank Kabel Go to last post
1 271
Update selected columns from one spreadsheet to another by homevestors
Hello, I have two spreadsheets saved as seperate files with different names. One is sheet is called parcels.xls. The other...
October 23rd, 2004 02:40 AM
by Mark Go to last post
1 185
combining columns by mudraker
one85x In c2 enter this formula =right("b2",4) & left("a2",1) -- mudraker ------------------------------------------------------------------------
October 23rd, 2004 06:18 AM
by BenjieLop Go to last post
1 172
Conditional Formatting by George Gee
Hi all I have this conditional format in cell BB35 =IF(BB35$BB$37,TRUE) If I insert cells between BB35 & BB37, then the formula changes to...
October 23rd, 2004 01:31 PM
by Debra Dalgleish Go to last post
5 169
Penny rounding! by rozbat
When using the "if" function on the function wizard, I'm having problems with penny rounding. I have three columns. Column 1 is a net figure, and column 2 is...
October 23rd, 2004 02:24 PM
by Gordon Go to last post
1 159
Changing values daily by George Gee
I would like to know if this is achievable? I would like cell B30 to show whatever is in cell F10 If the value in cell F10 changes, then the new value to be...
October 23rd, 2004 03:39 PM
by George Gee Go to last post
4 296
Penny rounding! by rozbat
Gordon, the trouble is not that I can't do as you've suggested, the problem is that almost all the columns are showing errors because of the tiny roundings up...
October 23rd, 2004 04:17 PM
by rozbat Go to last post
0 143
Sum by sgrech
Hi, I have a following data in a column on my spreadsheet 0.00 -98.35 #N/A -222.89 56.45 0.00
October 23rd, 2004 07:18 PM
by Frank Kabel Go to last post
2 180
excel by Pete
How do I convert my works spreadsheets to excel?
October 23rd, 2004 09:03 PM
by Gord Dibben Go to last post
2 148
change the year in a list of dates ex 1/3/2003 to 1/3/2004 by Elaine
I have a list of dates, all in the year 2003 1/3/2003, and 5/17/2003, I want to change just the year to 1/3/2004 and 5/15/2004 in the whole list. How do I do...
October 24th, 2004 05:50 AM
by Peo Sjoblom Go to last post
2 269
help. rotation shift pattern by Max
Perhaps one way .. experiment with this set-up .. In a sheet: Names ----------------------- Create a lookup table: Put in A1: Name1, copy down to A10 Enter...
October 25th, 2004 11:12 AM
by Max Go to last post
1 132
Post New Thread


Display Options
Showing threads 1001 to 1020 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 01:27 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.