Odd Error - Functions Remaining Visible!
May 30, 2008
I've got a very simple formula in Column P:-
=IF(O1="No","N/A",IF(O1="","","Needed"))
If I click on the cell to review this, it vanishes once I click out and still works. If, however, I click in the cell to edit it and then hit "Enter" the formula stays visible and refuses to work!
I've then tried it on other places where I have a formula on the same worksheet and the same thing happens.... And yet on other columns, it doesn't.
View 9 Replies
ADVERTISEMENT
Nov 3, 2008
I've been having some problems with my company's spreadsheet in terms of calculations using Add Ins.
Some of the functions work within the spreadsheets - others give me a runtime '9' error,
View 14 Replies
View Related
Nov 10, 2008
Trying to create a spreadsheet for euromillions at work as were playing syndicate.
View 10 Replies
View Related
Feb 20, 2014
I am, and have been using several sum- and count-ifs formulas for a time, but when the new year rolled around, decided to improve some of the sheet.
That all being said, the issue started after this. A specific set of my count and sum if functions started returning error values.
I analysed them, they seemed fine, and then selected them and hit enter. Problem over in that cell, as suddenly the correct value is returned.
But that's just it, I know the formulas are correct and working, as, if I select and hit enter on them individually, they return the right value. However, every time I close the sheet and re-open, all the values are showing error again.
I am perplexed. Did I inadvertently change a setting somewhere when I rebuilt the worksheet that is preventing the formulas from resolving correctly? As, like I said before, the formulas are fine, the data they are resolving, is fine. Just does not seem to calculate when I open the sheet.
View 2 Replies
View Related
Jul 10, 2014
I use Excel 2010 andexample.xlsx cannot make my code working because of the so famous errore above.
I have several pivot tables (pt) in different worksheets (ws), and a list of items stored in an array I created. I've written a macro for setting ON all items in pt except those ones in the array (listOffnet within the code). Everything works properly.
Now, I would like to do the complementary action: setting OFF all items that are not in the array. Unfortunately, I get the error at line:
[Code]....
View 1 Replies
View Related
Apr 22, 2009
Need to correct code to resize all visible rows on a sheet based only on the text in the visible columns. I have tried the below code but when it resizes it is using the largest amount of text in the rows including that in the hidden columns.
View 3 Replies
View Related
Jul 1, 2014
I have many checkboxes (1 to 26) that I want visible or not, based on whether the cell states "n/a" (are in a column in a different worksheet). Rather than writing this code multiple times, I'm looking to condense the code.
[Code] .....
View 2 Replies
View Related
Oct 27, 2013
I need to write a macro where i need to copy set of rows from few columns of an excel sheet to another set of columns in same sheet . My excel looks something like this...
Product
F1020
F1023
F1025
F1120
F1123
F1125
[code].....
Now when i filter this table for Product PR01 only rows 1,3,4 will be visible while the other rows remains hidden
I WANT TO COPY ROWS COMING UNDER COLUMNS
F1120
F1123
F1125
TO
F1020
F1023
F1025
when i use the code
Selection.SpecialCells(xlCellTypeVisible).Copy
i get to select ones those are visible but i am not sure how i can PASTE them to rows visible under column f1020 to f1025
Tried this in a frantic effort
Selection.SpecialCells(xlCellTypeVisible).PasteSpecial xlValues
But got an error for " multiple selection"
View 1 Replies
View Related
May 17, 2014
how to build a formula that would allow my remaining UOM and it's associated cells to move up to the days remaining UOM once my time goes below, say 31 days.
View 3 Replies
View Related
May 2, 2012
I have a table which contains Day, Projects, Proj Completed and % completed. I would need to get the target % starting thu so that I can end the week completing 90% of all my projects. Fri - Sun would show the same targets as Thu. Once Fri comes, i just need to update Thu with the actual projects I completed and Fri - Sun will show me my new target % to achieve 90%. Just in case hitting 100% will not achieve the 90%, it will just show 100% for the remaining days.
DayProjectsCompleted%
Mon4375%
Tue55100%
Wed8450%
Thu9?? If today is Thu, whats my target % to close the week at 90% ?
Fri8??Fri, Sat and Sun would show equal targets as Thu.
Sat6??
Sun7??
Total 47?90%target % at end of week ( formula for % is total completed / total projects)
View 1 Replies
View Related
Jan 19, 2009
I am trying to create a "daily donut" to track how long it has been since I left for my current deployment, and how much time I have left until I return home. I would like to show exactly how many year(s), month(s), day(s), hour(s), minute(s), and second(s) (like 1 year, 4 months, 4 hours, 5 minutes, & 34 seconds not 1.0 year, 0.33 months, etc.) it has been (again, not 3600 seconds, 60 minutes, 1 hour, etc.), and how many I have left. I have spent many hours trying to figure this out, and I have even tried looking through this forum, but I still can't completely figure this out. I was close in figuring out the date differences in the x amount of years, months, and days format, but it wouldn't account for the time. I.E., 06/03/09 05:00:00 AM - 06/01/08 06:00:00 AM, would show 2 days, instead of 1 day (I'm not sure how to incorporate the time yet).
The variables are:
A1 Date I Left For My Deployment in M/DD/YY HH:MM:SS AM/PM
A2 =Now() Function in Same Date & Time Format as A1
A3 = Date I Get Home from My Deployment in Same Date & Time Format as A1
Any ideas or help? And if possible, I would like to be able to do this using excel's built in functions (not excel add-ons, vb, etc.), so that it would work on government computers.
View 9 Replies
View Related
Jun 28, 2008
I'm trying to create a spreadsheet that will subtract time remaining for a client.
IE: A client has 3 hours of time. I work for 17 minutes, leaving the client 2 hours and 43 minutes:
A= 3
B= .17
C= 2.43
View 5 Replies
View Related
Aug 1, 2008
I am making a break timesheet. My UserForm contains Start and End Time button. User clicks start button, a message prompt will appear containing the time he needs to be back in taking his break. The start time of his break will be pasted on the worksheet.
After that, user needs to click the End button to paste the end time he returned. A message prompt will appear stating the remaining time of his break if he comes before the allotted break time say " You still have 00:15:00 left" click "Yes" to end break click "No" to continue your break." If the user click Yes, the time he click the button will be pasted on the worksheet.
Here is the code I have but I am receiving error message "Method 'Range of object_Global failed":
View 11 Replies
View Related
Jul 31, 2013
I am trying to get a formula that will give me the number of days remaining in the week. I have a formaula for number of days until the end of the month and number of days until the end of the quarter, but just need the week.
So if the formula was run today it would show 4 as the result.
View 9 Replies
View Related
Apr 11, 2014
In Column A, I have the dates listed as such. Common point is that, they are all 1st day of the month.
In Column B, I have Quarters as such.... (Please see below)
Can I put a formula together, to round up how many months left in that particular quarter ? example
Date Q3 2014 Q3 2014 Q1 2015
9/1/2014 1 3 3
Column A
9/1/2014
12/1/2014
6/1/2015
9/1/2014
9/1/2014
6/1/2015
9/1/2014
9/1/2014
...
..
Column
Q2 2014
Q3 2014
Q4 2014
Q1 2015
Q2 2015
...
...
View 9 Replies
View Related
Jan 10, 2007
I have a list of numbers . Several numbers are pulled, based on criteria, and then I need to create a list with just the remaining numbers.
EXAMPLE:
A) Numbers 1 - 500, defined by name (So I can INDEX them later)
B) Pull out numbers 47, 3, 143, 224 (based on certain criteria)
C) By INDEXING the field, create a list of numbers 1 - 500, omitting the above numbers.
I have no problems with steps A & B. I can't do step C.
View 9 Replies
View Related
Aug 31, 2009
I can't figure out the specific way to write a Do Until where it exits once there is no more text in any further rows.
Basically scan the rows and find the last remaining row. If there is no data after 20 rows then exit the loop.
This is a sample.
A
B
C
D
F
G
H
I
J
I would want it to understand that there is no information after "J" and to exit the loop.
View 36 Replies
View Related
May 15, 2014
I am trying to figure out a formula to calculate remaining useful life. I have the following information:
In Service Date (Cell W2)
Estimated Life (Cell X2)
Aquired Value (Cell Z2)
Is there a formula that will just calculate how much life is left based on the information i have?
View 4 Replies
View Related
Dec 2, 2009
How to determine how many days are remaining in the quarter after I provide it a specific date. Ultimately I am trying to build something where if I enter a date it will break down how much it will contribute for the remaining current quarter and for one full year (on a quarterly basis).
For example lets say I buy gumball machine today and I know that it will contribute X dollars for 2009 and X+1 dollars in 2010. I would like to break it down quarterly and have it say - you will get X for the rest of the quarter in 2009 and X for each quarter in 2010.
View 3 Replies
View Related
Jan 7, 2014
I am trying to separate the data in my spreadsheet. I will attach the spreadsheets and explain below. T
The column labeled number has entries that include commas. I need each number entered separated and put into its own row and I need the remaining data from the original row duplicated to the new rows.
Here is an example using the first entry.
Original entry
November Wiseman 1,2,11 Bluen Medical CA
How it needs to be separated
November Wiseman 1 Bluen Medical CA
November Wiseman 2 Bluen Medical CA
November Wiseman 11 Bluen Medical CA
View 7 Replies
View Related
May 15, 2014
So I want to add some VBA Code that deletes specified columns and then insert Bolded Column headers to the remaining columns. The columns I want deleted are D,F,I,J,K. For simplicity purposes, the column headers would be A,B,C,D,E,F,G.
I tried using Columns("D,F,I,J,K").delete but I kept on getting 13 error.
[Code] ......
Attached File : Test VBA File.xlsx
View 3 Replies
View Related
Feb 4, 2010
I am paste valuing from one sheet to another. The size of the data changes each time so to manually delete all Null cells is a pain.
If I do not delete them it sucks up 3 megs of space. I have searched the board several times looking for a solution, lots of discussions but no solutions.
It would be great if I could find that first cell that contains the Null string and then delete the cells remaining in the column. Any suggestions would be greatly appreciated.
View 9 Replies
View Related
Feb 1, 2007
My dates are coming up in serial format even though I have the cells formatted to date. It doesn't matter which date format I select they all remain as serial dates.
View 4 Replies
View Related
Feb 27, 2007
I have an excel spreadsheet that has several fields which should be connected. If one of the fields is selected via a drop down, then several other columns should autopopulate with the data in the list set up on another page. What Im trying to figure out is:
1) How do I make it so it does this with every row on the spreadsheet? I've seen code in the formula bar so that it works for one row, but I need it to work regardless of how many rows are added to the sheet...
and
2) Is there VBA code so that if someone selects A value from a drop down list in, say, column F, that data corresponding to that selection is placed in other columns in the sheet?
View 2 Replies
View Related
Apr 1, 2009
A1, B1, C1 and D4 are cell in Excel worksheet and values are 2, 4 and 6 in A1, b1 and c1 respectively.
A1 B1 C1 D4
2 4 6 C1-Formula is: =sum(A1+B1)
Now I have to write formula for D4-cell:
i.e. =sum(C1/Total days remaining of the month)
Suppose Today is April 01, 2009, C1/should be devided by 30,
Tomorrow will be April 02, 2009, C1/should be devided by 29.
View 10 Replies
View Related
Apr 9, 2009
how i can fix the formula below to show the number of remaining days between the given date and the current date.
View 3 Replies
View Related
Oct 7, 2008
I am looking for a method which would delete empty cells in a row, and then shift the remaining data to the left (filling the cells with data). I know that this could be done manually, but I need it completed for 3000 rows! I have attached a simple sheet to show what I'm Looking for.
View 2 Replies
View Related
Apr 24, 2009
In the code below I find rows containing "$$ #" at the far left and process it.
For all the remaining rows I want to delete the entire row, my macro only deletes some rows. Obviously I am not grasping something about looping throught the rows to delete unwanted data.
View 2 Replies
View Related
Aug 15, 2009
A column (A1:A60) is being progressively filled in with numbers, and occasionally some blank cells are between.
I need a formula to work out the number of the remaining cells (that are yet to be filled in) from the last entry till the last cell (A60) of the column.
View 7 Replies
View Related
May 14, 2013
Having trouble with this one. Searches seem to bring up every other variation of extracting info from strings except this.
I have cells which contain alphanumeric strings as below and, using a formula, I want to extract everything from and including the last letter to give A 2-3, B 3 and C 3-4 in the examples below.
Sub-base A 2-3
Sub-base B 3
Paving C 3-4
View 7 Replies
View Related