A Different Kind Of "missing" Detection
Mar 12, 2009
Background: I have 3 lists. List 1 is a column of unique identifiers. List 2 is a column of unique identifiers. List three is supposed to contain as many rows as the number of rows in List 1 * the number of rows in List 2. Each row in List three has as its unique identifier a value from List 1 concatenated with a value from List 2.
What my problem is: I want to determine, when looking at each row in list 1, if there is an corresponding entry in list 3 for every row in list 2.
View 10 Replies
ADVERTISEMENT
Mar 28, 2009
Does any know of excel code to know what know what kind of border it is. I converted a pdf file and now the data are on excel and there are borders and it looks to me like it is border with thickness of medium but when I run a code I produced and mark X to the column next to it to show that it is that border it gave me X on all the rows and so the medium thick border is excel grid without any borders.
View 9 Replies
View Related
Apr 2, 2008
I have a spreadsheet that has a lay out like below
A A A
* A A
* A A
B B B
* B B
* B B
and so on where every letter is a new cell and * = empty cell
I need a peice of code that will highlight all of section A. Section A could have 1 row or an infinate number of rows.
What I need is like a peice of code that means that it will start selecting rows starting from "A3" which is the 1st cell with data and stop selecting rows when the next row has data in the A column.
View 9 Replies
View Related
Jul 10, 2009
I have built up quite a few macros for automating functions in some spreadsheets, and I want to start being able to detect when errors occur. Right now I just have the function or sub terminate itself if an error occurs, but that just returns control to the calling sub/function.
I need a way to detect if an error occurs, and immedatly terminate the whole process so that it does not continue and make eronious changes further down the line.
I had thought of declaring a pubic boolean variable that i could flip if an error occurs, but I am not sure how to detect this flip without programing in an if statement every time i call a function.
Question1: Is there a way to write a function/sub that will automaticly triger if a public variable becomes a certain value?
Question2: How do I unload a macro (terminate it) from a public function? I have found that for user forms, the Unload Me command does not work in a public function. I suspect this is becasue the function is not directly attached to a form.
View 9 Replies
View Related
Jun 13, 2009
i have a workbook system that is used on 25 standalone machines that all have different printers everytime i install on a new system i have to reconfigure all of the printers that i have set up in VBA i am curious to find out as to whether or not there is a macro i can use that will generate a list of all printers on a machine that i can then use to refrence a printer name in my VBA
View 3 Replies
View Related
Aug 7, 2007
I have a spreadsheet that grows rapidly each day of addresses I service. Duplicates are not welcome. When the spreadsheet was smaller, I would type in an address and if it was a duplicate, Excel would auto fill the cell with the duplicate data. Now that the rows are over 2000, I wanted to see if this primitive method for weeding out duplicates was still working, however when I type the first address I have in cell A1, it does not auto fill in A2001, even though it is a duplicate.
Is there any way to have on-the-spot detection of duplicates sans macro?
View 9 Replies
View Related
May 19, 2006
The code in the file works but, I wonder if you could comment and suggest an improvement to the code in the attached file. With the generous help of good folks on this site, I have developed a code to use in my workbook (a sample is attached). Before I use it I would like to be sure that it will not generate any errors.
View 3 Replies
View Related
Feb 27, 2014
I have an array and I need to be able to detect when a varying number of consecutive array elements are equal. I want to be able to call the code and give the number of elements I need to find.
The following does not work but illustrate what I am looking for.
[Code] .....
I have been looking at ways of recording the number of equalities in the p loop, but I am sure there is a more elegant way.
View 2 Replies
View Related
May 26, 2014
I have a drop down list that shows phrases for different math functions, like "divide by 2," "divide by 4," divide by 8," etc. When one of these items is selected, I want it to perform that specific calculation on a range of nearby cells.
However, I also want the user to be able to see the original value of the cells if they select "show original value" from the drop down list.
I have attached a workbook as an example. I think macro would probably work best.
oz_list_math.xlsx
View 5 Replies
View Related
Sep 22, 2009
I need to populated a specific range of cells based on a value of any kind in a header cell. Attached is a sample of the end results. Please remember each header cells needs to determine what happens the range of cells below the header cells.
View 3 Replies
View Related
Jul 8, 2008
I have two columns which i want to compare, they contain text data such as A123.
what I'd like is if its in column A and not in Column B then add to bottom of column A.
Once its in column A i can do the vlookup's to draw the other data, costs etc, over but don't know how to identify, and add, the missing codes to the list.
View 9 Replies
View Related
Aug 14, 2008
I have done the two obvious checks regarding my missing Status Bar, both in View and Options and still the Status Bar refuses to show itself. I have shut down Excel with the options unticked hoping that on restarting and ticking them the bar will re-emerge but still no joy and also done vice-versa. how to get the Status Bar to reappear?
View 5 Replies
View Related
Jan 29, 2010
I have attached a screen shot of vlookup formula. Whilst selecting a range a little tooltip comes up showing how many rows and columns have been selected (6R x 2C) ...
... at least that's what used to happen. Now this handy tool tip does not show on my PC - and I have no idea how I turned it off, or more importantly how I can turn it back on again.
I am running Excel 2002 SP3 on Windows XP.
View 7 Replies
View Related
Mar 3, 2014
I have received a spreadsheet by email and when I opened it the formulas all had errors. I did a little investagating and found that when I use the viewer to open it there is an additional tab that is missing when I open it in Excel. I did check for hidden tabs but then realized that the formula would have still worked even if the tab was hidden, in this case it is just missing.
View 2 Replies
View Related
Mar 15, 2005
The title bar is missing for one 2002 file. This is the same bar that has the minimize/maximize button in the right corner.
My mind is drawing a blank for a fix. I've tried the *view, tool bar, customize* and can't find the missing bar.
View 9 Replies
View Related
Dec 7, 2005
I have a hyperlink in my excel file which refers to cell in a separate excel file (which no longer exists). I therefore would like to remove this 'dead' link as it keeps trying to update it when I open the file.
I don't remember where this hyperlink is in this huge multi-sheet file so I can remove it! How do I have excel show me all hyperlinks and the option to remove them?
View 9 Replies
View Related
Apr 16, 2007
I have 2 spreadsheets. One has one type of info and another has another type of info for the same items.
For example:
1st spreadsheet has: server name, serial number, model.
2nd spreadsheet has: amount of memory for each server, number of CPUs, etc.
Note that some servers are missing from one or another sheet. So all info needs to be combined.
What is the easiest way to combine all info in a single spreadsheet?
View 9 Replies
View Related
Jun 9, 2007
I am facing a problem importing Excel data into a finicky graphics program. This program can't accept strings and numbers in the same column. Hence, strings such as #NA, or Excel's standard "" can't be used where there are missing values, as the entire column is then ignored.
But, I would like to provision for future data below the rows that currently exist.
Let's say I am trying to read data from Sheet1 of a workbook. The rows in Sheet1 contain formulas referencing other sheets (e.g. Sheet2!C1-Sheet2!C2). So, if Sheet2 doesn't have data in a certain row, Excel would show 0 in the formula on Sheet1. That would mess up my graph. If I use any other string or "" using a If statement for missing data, then the graphics program doesn't work.
Is there any way say, using dynamic ranges or similar, to populate blank cells in Sheet1 as data arrive in Sheet2, without a pre-existing formula being present in these Sheet1 cells? I can imagine that VBA macros will easily do this (e.g. the thread on Autofill below). But, is this possible without having to trigger a macro as and when additional data arrive?
View 9 Replies
View Related
Aug 10, 2007
number and number 2 is what i have.. I would like it similar to the right side of this sheet where the missing ones are at the bottom of E
sheet: ...
View 9 Replies
View Related
Aug 10, 2007
i have a workbook with missing dates and would like excel to insert any missing dates and add 0's into that missing dates if there is no data...
for example....
View 9 Replies
View Related
Jun 24, 2008
i have a bunch ofdaily rates back from 2005. sometimes ill have one or even 2 or 3 missing rates in a row. when there is a blank rate, i just want excel to calculate the average of the date below and the date after. right now, ive just been going manually to each missing date's rate and calculating the average.
View 9 Replies
View Related
Oct 2, 2008
I have created a 4 page chart in landscape with text in each of the 4 columns in the chart.
When I looked at it in print preview the chart did not fill the page and so to widen the last 2 columns I dragged them over to the right hand margin. I am still definitely within the right hand dotted line showing the margin limit.
The problem is that I cannot now put a border line down the extreme right hand column. Every time I click on any of the border instructions in the Font tab nothin appears on the right hand side of the box.
View 9 Replies
View Related
May 20, 2006
I want to write code that will allow me to show the Missing Names in the Old sheet that aren't in the New Sheet.
I want the code to go along these lines:
Dim a As Long
a = 2
Dim o As Long
Dim p As Long
Dim last_row14 As Long
Dim last_row24 As Long
View 5 Replies
View Related
Sep 27, 2006
Can anyone answer this one for me - why does this piece of code run on some machines but not on others - I suspect it is something to do with a missing library but I have no idea which one.
When the code fails it highlights the word " Date" inside the brackets
TrainingDateBox.Value = FormatDateTime(Date, vbLongDate)
Is there an alternative code?
View 9 Replies
View Related
Apr 25, 2007
I have been working on a pretty extensive Excel Workbook for quite some time, finished it today after testing it multiple times, everything was working fine on my PC. But after I pasted the document on one of the network drives at work, I started getting compile errors. I am getting these errors on basic functions that I used in my code such as Date, and the Left and Right functions. I figure I must be missing some sort of reference...the error I am getting is (Compile Error: Can't find project or library).
I can't understand why everything worked fine on my computer and as soon as I paste it on the network, the application blows up for my coworkers.
View 4 Replies
View Related
May 4, 2007
For some reason colors will not show on any EXcel doc. When I type colored text in a cell, it shows the color until I press enter, then it goes black. Cell fill colors do not show at all.
However when I send the doc to another computer the colors wil show.
View 6 Replies
View Related
May 9, 2007
we are currently upgrading from Win2000 and Office Pro '97 to WinXP sp2 and Office Pro 2003. I am testing our applications for compatibility and am discovering many that fall over because mscomct2.ocx is missing. Does it normally come as standard in Office 2003 or not? If not, when did it stop being standard?
View 2 Replies
View Related
May 15, 2014
I need to take in third sheet all data which are missing in second sheet from first sheet, for example:
IDName LastName
1John Doe
2Jany Tine
3Paull Marphy
4East Doe
5West Marlyn
6ThirstanWist
7SecondEast
8ExampleMiddle
9Doe Tryer
10MarlynEarly
Sheet 1
IDName LastName
1John Doe
4East Doe
9Doe Tryer
10MarlynEarly
Sheet 2
And in Sheet 3 to get result
2Jany Tine
3Paull Marphy
5West Marlyn
6ThirstanWist
7SecondEast
8ExampleMiddle
Sheet 3
View 14 Replies
View Related
Sep 21, 2009
I have a formula that looks like this:
=HLOOKUP('Output'!$B$3,'Input'!$B$1:$P$300,'Input'!$A3+1,FALSE)
It is working very fine, when the cell has a value, but when it doesn't - it will return 0. So my question is: is there any way to make it return certain value or word like "No value" instead of zero?
View 9 Replies
View Related
Dec 6, 2012
I am trying to import data from web to excel. I posted the link below to the website I am attempting to import from. The only part I need is the statistics. However, I cannot get it come thru by getting external data from web.
The goal is to great an auto updating spreadsheet with multiple sheets so copy and paste is not feasible.
[URL]
View 1 Replies
View Related
