New Users - Page 11 - 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.

		Home » OfficeFrustration forum » Microsoft Excel
New Users

Home

Page 11 of 687

Threads in Forum : New Users

Forum Tools

Search this Forum

Thread / Thread Starter	Last Post	Replies	Views
Can I get Excel to automatically BOLD dates 30d before expiration? by Donna I am new to Excel (obviously), and I have created a simple worksheet that contains numerous dates. I wish to have the dates become bold when they are to... ( 1 2)	January 10th, 2008 05:35 PM by Gord Dibben	12	325
Hiding #N/A error (or displaying a blank cell instead of #N/A) by Eva Marie Hello, I have a formula which is working correctly; however when it doesn't locate the data (as will happens sometimes), it displays the #N/A error. I would... ( 1 2)	October 3rd, 2008 08:38 AM by Dave Curtis	12	182
getting future dates from an existing date by Totti[_2_] Hi everyone, I have an excel sheet filled with dates of this year and few future years, i am intending to use it as a worksheet for knowing some prcise dates... ( 1 2)	October 17th, 2008 06:06 PM by Totti[_2_]	12	193
AutoSum by CC I know this should be easy, but.... If I autosum several cells...and then want to add more cells with numbers and get a new autosum of all cells - how do I do... ( 1 2)	October 29th, 2008 03:11 PM by CC	12	184
Program find a 5 minute gap by Striker Excel 2007 used to represent a Cell. They do not exist in the data of the cell. I have a column spreadsheet that has 15K records. IN column "G" all... ( 1 2)	December 4th, 2008 03:07 PM by Niek Otten	12	140
Nesting an additional formula in an IF statement by Karsea I have an existing calculation in a column, when I drag the formula down - I rec'v a #DIV/O - I need to insert a "Serror" in my existing formula but unsure... ( 1 2)	February 10th, 2009 10:16 PM by Karsea	12	429
Hide and unhide shaded cells by Sylve Hi everyone! New here and in Excel too. I want to hide shaded rows (different colours) and see only unshaded rows. Later I will unhide those rows. Thanks in... ( 1 2)	March 8th, 2009 09:09 PM by Dave Peterson	12	297
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!!! ( 1 2)	April 2nd, 2009 06:05 PM by Francis	12	246
Sort worksheet on multiple keys - Primary, secondary, tirterary, etc. by Doug Mc How do I specify the most important, next most important, the next most important, etc. columns to sort on. I assume when I do that the remaining columns will... ( 1 2)	October 22nd, 2009 02:18 AM by Gord Dibben	12	265
Printed 5 documents via Microsoft Office Doc Image Writer - and they are nowhere to be found - and it's freaking me out?????????? by JethroUK© I have now printed 5 documents via 'Microsoft Office Doc Image Writer' (.tiff files) - and they are nowhere to be found on my system (Vista Premium & Office... ( 1 2)	December 1st, 2008 02:58 AM by Ben M. Schorr - MVP (OneNote)	12	168
Help with Absence sheet formula. by Bojan Hi, I manage a monthly absence sheet, we have 4 types of absences "sick; a/l; bev; dom" and "late or Early finish" All of these types of absence are entered... ( 1 2)	September 20th, 2008 03:38 AM by T. Valko	12	261
how to quick calculate sum of colume A1 to A115? by Anthony B[_2_] How to quick calculate sum of colume A1 to A115? Or, do I always have to set up formular =sum(A1:A15) to get the sum? ( 1 2)	January 4th, 2008 08:34 PM by gls858	12	203
Splitting up timeperiod by Bret Bernever I have 4 Timeslots: TimeSlot 1 - 6:00-8:00 TimeSlot 2 - 8:00-18:00 TimeSlot 3 - 18:00-22:00 TimeSlot 4 - 22:00-6:00 I have one time... ( 1 2)	January 11th, 2008 12:50 PM by Max	12	281
Automate Merge by John In an bank statement (excel softcopy) the movement description excel rows look like this: 1 RECIBO TELEFONO 2 TELEFONICA MOVILES S.A. 3 RECIBO A SU... ( 1 2)	February 5th, 2008 01:40 AM by Max	12	228
Help by dfmstes1 I have a an excel doc that I need the information entered to be transferred to a log. Each copy of the doc must be saved, so there are about 150 worksheet... ( 1 2)	February 14th, 2008 11:24 PM by Max	12	201
Reduce Size of Blank Rows (again) by Rebecca I am using MS Excel 2007. A month or so ago I asked for help to reduce the size of blank rows (currently 16 points) down to 8 points. The Excel experts... ( 1 2)	March 30th, 2008 02:00 AM by Rebecca	12	314
Days between dates by Linda RQ[_2_] Sorry Guys, I have looking around on a bunch of websites on calculating days between dates (sort of) and it's almost working but I need it to really work. I... ( 1 2)	April 12th, 2008 06:27 PM by T. Valko	12	264
Further Excel help for =SUMPRODUCT((C$1:E$8=G1)B$1:B$8) by MikeR-Oz* Any one able to assist with formulae like the above which for me is quite advanced yet I am sure it is intermediate. I would like to attach a file to give as... ( 1 2)	May 6th, 2008 02:14 PM by Max	12	200
More function than FLOOR() ! by wilchong via OfficeKB.com I have a problem for an excel formula. I want to convert 1 to 0, 2 to 0,...... ..., 10 to 0. And convert 11 to 10, 12 to 10,............, 20 to 10. I know... ( 1 2)	August 6th, 2008 12:47 AM by Ron Rosenfeld	12	289
How can my macro run faster ? by Roger I have a set of 5 macros which analyse and finally format data. It starts with about 5000 records and ends up with around 250. I have one "super" macro which... ( 1 2)	October 26th, 2009 12:57 PM by Dave Peterson	12	378

Page 11 of 687

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	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 08:09 PM.