General Discussion - Page 56 - 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
General Discussion

Home

Page 56 of 6989

Threads in Forum : General Discussion

Forum Tools

Search this Forum

Thread / Thread Starter	Last Post	Replies	Views
9.89E+09 Why this instead of a 10 digit number in cell? by Tim Fitch When I paste (regular or special) a 10 digit number beginning with 989, I get 9.89E+09 displayed in the actual cell, even though the actual 10 digit number...	July 3rd, 2004 04:38 AM by Bob Flanagan	4	371
Date Formula Help by SMonczka Someone here once gave me the formula for converting a Date to the number of the week. In other words 1/16 would be 3 as it falls on the 3 week of the year....	July 3rd, 2004 07:42 AM by SMonczka	4	185
Counting how many times a certain number appears in a column of ce by Melinda (I am not sure if this is possible) I am trying to configure a formula to tell me how many times certain number appears in a column of numbers. Is this...	July 3rd, 2004 08:41 AM by Melinda	4	320
What function would I use? by Capn_Chord Thanks for the suggestion it did work really well, but I think I'm dealing with a little too much data for it. This is an example of what I'm trying to...	July 3rd, 2004 09:45 AM by AlfD	5	239
Any ways to do something similar to Access Switch() function... by Tripp Knightly In Excel, instead of doing a bunch of nested ifs for conditional logic, are there any ways to do it w/ something more elegant like the Switch() function in...	July 3rd, 2004 10:09 AM by Bob Phillips	1	162
date and sending message by rpahl I am trying to create a macro that sends a specific number to a specific cell on a certain day. "If the first day of the month, then send 75 to cell A2 If the...	July 3rd, 2004 01:59 PM by Norman Harker	2	150
Hi! Urgent pls: Protecting sheets so macros/buttons still work? by StargateFanFromWork Sub YourMacro() ThisWorkbook.Worksheets("Sheet1).Unprotect("YourPassword") 'your code ThisWorkbook.Worksheets("Sheet1).Protect("YourPassword") End...	July 3rd, 2004 02:25 PM by StargateFan	7	941
filter out all the #n/a... by sokevin I have done a vlookup in col(b), col(c) and col(d) i want to summarise column b,c,d in column E e.g if col b2 = #na, c2=#na, d2=300 then i want e2=300 if...	July 3rd, 2004 03:04 PM by sokevin	2	167
AutoFilter not an Option by Jeremy I have a large spreadsheet with multiple columns of data. Each column has a label and no column is left entirely blank. When I go to the Data:Filter menu the...	July 3rd, 2004 04:41 PM by Jeremy	3	146
Auto refresh of Pivot Table by K. Georgiadis I found the following code on C. Pearson's website: Sub Auto_Open() Application.OnSheetActivate = "UpdateIt" End Sub Sub UpdateIt() Dim iP As...	July 3rd, 2004 06:40 PM by K. Georgiadis	2	118
Matching by gary a1..e711 contains data in this format: Part-nbr Date Amount 008101815-8 03/12/2001 751.72 008101816-9 03/12/2001 514.50 008101817-0 03/12/2001 ...	July 3rd, 2004 08:28 PM by Alan Beban	2	165
Work menu in Excel? by billlake ~× wrote: *Very handy feature in Word. It's a menu where you can add the documents you work most frequently with. Much better than the Recent Files... ( 1 2)	July 3rd, 2004 10:15 PM by Andy	13	694
Using formulae to display pictures.... by matt_123 Hopefully there is somebody that can help me with this predicament. I regularly compile quizzes on excel which get sent out & are now viewed as far afield as...	July 3rd, 2004 10:32 PM by AlfD	2	360
Not Enough System Resources to Display Completely by RamblinWreck I have a spreadsheet with several drop down menus. Depending upon the screen resolution and/or Percent Zoom, I may get a "Not Enough System Resources to...	July 3rd, 2004 11:00 PM by David McRitchie	2	2,141
count if by gregork I need a formula to return text based on that text being in all the cells in a range. I want the formula to ignore blank cells in the range. I have...	July 3rd, 2004 11:23 PM by RagDyeR	6	254
Reduce chart white space by Vinod When I create a pie chart, a terrible amount of white space exists around the pie. When I insert it into PowerPoint, it takes up way too much room. I can...	July 4th, 2004 12:15 AM by Jon Peltier	2	431
Data validation input message by DT Can anyone please offer any advice? ..... I am using data validation on a worksheet and would like to resize the message box that appears when the cell is...	July 4th, 2004 12:16 AM by Dave Peterson	8	226
pop-up/comment of text in chart by acl Hi I am basically brand new to VBA and excel macros...so please keep that in mind. If the solution lies in either of those, if you would be kind enough to...	July 4th, 2004 12:27 AM by Jon Peltier	2	208
Athos by Athos is there a way to write this as a formula? I want each cell (B1:B10) to refer to a fixed cell(A1) in the following way: Cell B1 = $A$1 * n. Where n is a... ( 1 2)	July 4th, 2004 03:17 AM by Ragdyer	13	240
Excel to Lotus by xippy Is there a way to convert an MS Excel spreadsheet to Lotus? I have saved an Excel file, but it's Read Only for some reason, and doesn't...	July 4th, 2004 09:19 AM by Andy Wiggins	1	176

Page 56 of 6989

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 02:09 AM.