Description:
Microsoft Office Excel newsgroup.
|
|
|
getting rid of blank area
|
| |
Hi When I export certain work to excel, the rows end up in the 6000 when really there are only usually max 250 - 300 rows. I saw somewhere that if you go to the last cell (ctr+end) and you delete all the rows blank to there, your last cell will be where you want it. But that doesn't work. I end up having to copy my working area and pasting it to a new worksheet... more »
|
|
|
Formula using "If" and "or" criteria.
|
| |
I have 4 columns of currency data in columns A,B,C and D. I want to sum them in Column E. The result I want in E should be the sum A+B or C-D if A+B is = 0. Could someone please advise how to write a formula for this scenario. Thanks !!!
|
|
|
Ctrl + F not working?
|
| |
Can anyone tell me what the problem might be if sometimes my CTRL + F doesn't work in Excel? I often have to go via the menu to do a find. Thanks John
|
|
|
Adding dates ... to previous weekday if falls on weekend.
|
| |
I found lots of solutions if one is using the AnalysisPak but I'm not and with no possibility to use it since they don't like us installing stuff, even things like this. I have this formula: =IF(A2<>"",A2+18,"") It works fine except it deals with calendar days. The formula putting today's date in A2, returns this date:... more »
|
|
|
Data Validation - Custom
|
| |
Excel 2003 Please can someone tell me the simplest formula that I can put in 'Data Validation/Settings/Custom/For mula:' to limit a range of cells to being a number between -24 and 24? At the moment I have: =AND(ISNUMBER(A1),SUM($A$1:$A$ 21,$B$1:$B$21)<=24) Now I see a need to limit the negative number as well.... more »
|
|
|
fill right
|
| |
When I enter Nov-25-2009 and Nov-26-2009 in cells and then do fill right the year changes to 2010 is there a way to change only the date and not the year? Afd
|
|
|
Plotting two datasets on a graph
|
| |
Hi, i have two datasets of X and Y Values. The first dataset has 48 pairs of X,Y values. The second has 96 pairs. I wonder how i can plot this on the same graph so i can compare them. Thanks in advance for your suggestions. Thanks, Victor
|
|
|
Problem with ISBLANK Function
|
| |
Hi, I have an Excel 2003 worksheet and I wish to perform certain functions if a range of cells are ALL blank (empty). I am trying to use the ISBLANK function, but am getting varying results. Can the ISBLANK function be used to check a range of cells simultaneously? e.g. =IF(ISBLANK(L11:M21),"Blank"," Not Blank")... more »
|
|
|
Challenging Sort Problem
|
| |
Have a spreadsheet with items. A = Multiple Locations B = item id (in each location) C = Description D = Qty on Hand (some have zero) E thru J = has misc data I am trying to sort by D - Highest qty on hand and bring all locations with it - no matter what qty is showing. A=location B=part number C=part description D=qty on hand... more »
|
|
|
|
