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 : General Discussion Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Replies Reverse Sort Order Views
How do I schedule a task to print a document by Hershmab
I have an Excel document with date formulas to keep it up-to-date. I wish to print its only worksheet automatically once a week. How can I specify the...
(Multi-page thread 1 2)
May 13th, 2009 02:27 PM
by Asif Shah Go to last post
11 193
Excel Circular Reference SUM HELP! by SpecOpBookie
Hi all, I'm fairly new with Excel so let's see if I can get a quick answer for my question :). I am trying to add a base number to whatever number i Input...
(Multi-page thread 1 2)
June 8th, 2009 01:28 PM
by Luke M Go to last post
11 174
display lbs and ozs by Trail Dog[_2_]
i use the formula # "lbs" ??/16 "ozs" for calculating my backpacking gear. how do i change it to show 3 lbs 2 ozs instead of 3 lbs 2/16 ozs ? thanks
(Multi-page thread 1 2)
June 11th, 2009 09:49 AM
by Trail Dog[_2_] Go to last post
11 194
Blank cell not really blank by OperationsNETTC15
I am using Excel 2007 and returning data into a table using xfODBC, which returns a number of blank cells. If I do an ISBLANK on the blank cells, it returns...
(Multi-page thread 1 2)
June 11th, 2009 05:01 AM
by Rick Rothstein[_2_] Go to last post
11 239
Why does Internet Explorer open a jpeg from a hyperlink ??? by Roman
when I created a hyperlink to a jpeg image located on my hard drive, why does internet explorer open the image?? I am using Office 2000 and IE7 +XP S3 I...
(Multi-page thread 1 2)
June 15th, 2009 05:35 PM
by Roman Go to last post
11 286
Negative Numbers by PL
How do I change all the numbers in a row into positive ones without doing so individually? Thanks
(Multi-page thread 1 2)
June 14th, 2009 09:39 PM
by James Silverton[_4_] Go to last post
11 211
BIG question by Wu
I would like to write a marco that: Let me input data in a cell, and when I , the cursor will move to right cell to let me input data again..................
(Multi-page thread 1 2)
June 15th, 2009 02:58 AM
by Rick Rothstein[_2_] Go to last post
11 216
sumproduct assistance pleas by Ajay
Afternoon all I have a table of raw data containing an inventory list by department, I need to count the number of items in each dept which are out of date....
(Multi-page thread 1 2)
June 17th, 2009 05:16 PM
by Fred Smith[_4_] Go to last post
11 235
can I use a cell content to auto-populate to a header in excel? by DaveC
any help on this? I would like to use the contents of a cell to auto-populate the header. Thanks for any assit.
(Multi-page thread 1 2)
June 23rd, 2009 12:49 PM
by DaveC Go to last post
11 508
Help with formula by Lynda
I was hoping someone might be able to help me with a better formula or a code that will give me a result based on the formula below as it comes back saying I...
(Multi-page thread 1 2)
June 5th, 2009 03:50 PM
by David Biddulph Go to last post
11 273
Can a VLookup be added to an IF Statement? by Kiley
I have an IF statement and I am wondering if a Vlookup can be added to the formula?
(Multi-page thread 1 2)
June 9th, 2009 05:15 PM
by Kiley Go to last post
11 216
Counting using multiple criteria by Rodman
I am using Excel 2003 and I would like to count the number of cells within a range thar meet multiple criteria. (Note this function is availiable in 2007 as...
(Multi-page thread 1 2)
June 3rd, 2009 05:22 AM
by T. Valko Go to last post
11 145
Format cell to show '-' by Gary
Looking for a way to make entries into cell show negative (-) indicator by default. For instance if '1' is entered, it will display '-1'. Excel 2003
(Multi-page thread 1 2)
May 11th, 2009 05:19 PM
by Gary Go to last post
11 177
What causes = not to work? by Amy
On several occasions lately I've had the misfortune of my spreadsheet refusing to treat a formula as a formula. Instead it shows me the formula. i.e....
(Multi-page thread 1 2)
May 15th, 2009 05:33 PM
by Amy Go to last post
11 247
Error problem by Ayo
I have this formular: =SUMPRODUCT(--(Tables!$C$2:$C$2979=$A4),--(Tables!$D$2:$D$2979=$B4),--(Tables!$E$2:$E$2979="Yes")) but it is showing as an error. Iknow...
(Multi-page thread 1 2)
May 20th, 2009 04:52 PM
by Ayo Go to last post
11 330
using if for multiple criteria by enna49
Hi I have used the formula below for adding across cells if certain criteria. This does work, however is there a cleaner way of doing this. Example Data...
(Multi-page thread 1 2)
May 23rd, 2009 08:21 PM
by Ragdyer Go to last post
11 130
Finding a position in a Cell using a formula by jxbeeman
Hi, I'm trying to find a certain data type in a cell and the position it is in. For example I have a text cell with the following in it "SomePartName ...
(Multi-page thread 1 2)
May 30th, 2009 02:40 AM
by macropod[_2_] Go to last post
11 199
Finding the biggest number out of 8 variables by Mojo[_2_]
Hi All Does anybody know of an easy way to find out which variable has the highest value out of 8 variables? For example, I have these values in 8 vars: 3 ...
(Multi-page thread 1 2)
June 7th, 2009 01:00 AM
by Dennis Tucker Go to last post
11 207
Substitute Text for Plus or Minus by DOUG
Is there a way to substitute the words "UP" or "ROSE" and "DOWN" or "FELL" for a calcualted value referenced in another cell in a concatenated statement...
(Multi-page thread 1 2)
June 12th, 2009 07:06 PM
by DOUG Go to last post
11 201
how to hide a number of cells based on one cell? by TG
Hello, How would I be able to hide lets say row 4-15 if A1 had the word no? Is this even possible? Also, what if i also want to hide rows 20-100 if A19 says...
(Multi-page thread 1 2)
June 26th, 2009 08:15 PM
by TG Go to last post
11 183
Post New Thread


Display Options
Showing threads 2001 to 2020 of 139764
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 11:11 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.