Thanks that works.
Type: Posts; User: Seba; Keyword(s):
Thanks that works.
Sorry-MID(B2,5,3). the Budget in the vlookup is a label to a range coming from another worksheet in the same spreadsheet
Hello Everyone-I have MS Excel 10 and need to do a vlookup function. The vlooup function is looking up a cell that has the following formula in it "="1"&mid(5,3) in A2. When I do the vlookup...
Hello-I am doing some VBA for excel 2010 and have some questions about how to have user input multiple numbers in an inputbox field. I am using the index(es) to filter a table. Maybe this is not...
I am trying to write a VBA if statement. What I would like to do is for the pivot table to only show the PivotItems where the number is 1700 and everything else to not show. Any help would be...
Hello-What is the best way to make a Visio document ADA compliant in PDF? I have Visio 10 and Adobe Acrobat X Professional. I have tried to use both Adobe add-on in Visio and Visio's own PDF...
Hello-I need to create a formula that counts unique values in rows. I know I can use the filter option, but need to create a formula. For example
Row1 "david"
Row2 "david"
Row3 "Jessie"
Row4...
Does that mean even when you are not using the Xbox? No. It works fine when not using Xbox.
Only when you use the Xbox? I get problems loggin into X-box live sometimes and I end up having to...
Hello Everyone-lately I been having to reboot my 2wire gateway to be able to connect to x-box live. I have the x-box live connection hardwire into the 2wire gateway and 2 laptops connect wireless. ...
JJDetroit-is there a way to encrypt the drive before putting it on to a Pogoplug? I have to USB harddrive that I will be using with the Pogoplug, but I am afraid to put sensative information there...
I have a database that has a form to track information that I do everyday. Sometimes I get request via email to do a task that I need to include in the tracking form of the database. I would like to...
I would like to do the have a formula or pivot table that displays only information where the name is the same, but the titles have change. This way I can tell who got promoted or not. I would like...
I want the user to get an email from their pst file and attach it to the form for record keeping and the only way I can think of this is by using a combobox.
Every employee has a new row with information if they change job titles. Basically, what I want to do is to have the pivot table display only the names that have multiple titles and not the ones...
Hello-I have an excel spreadsheet with over 10,000 rows of information. In the rows I have the following columns: Name, position title, salary. I create a pivot table by using Name as one row and...
Hello-I have a database form that I would like the user to have the option of attaching an email message to. What is a way to accomplish? Is it done via VBA programing or are there other options? I...
Thanks chowur.
Hello-Is there a video/book or articles that explain the differences between users and groups management in win7 and winxp (both local and domain). I am supporting some computers and need to know...
Hello-I am trying to do Video on Demand on Directv. I have a wireless modem/router (2wire) dsl set up. I want to connect wireless to my HR-200 from Directv. What device do I need in order to do...
By googling I found an article that said to run the line below and this solved the issue.
secedit /configure /cfg %windir%\inf\defltbase.inf /db defltbase.sdb /verbos
Hello -I just installed Office 2010 and everytime I try to open any application (excel, outlook, etc) I get this windows installer screen follow by another screen that says that windows is trying to...
Hello everyone-I downloaded some software in form of an ISO from my MS Technet subscription and would like to know if there I can extra this to a hard drive. I tried using windows disc image burner...
Thanks Joe. I think this would work.:)
I won't be there for the installation and therefore want to limit the calls I get from them asking me what to do as the installation is proceeding. I just want them to put the DVD in and have all...
Thanks for the recommendations. This will be a new install and not an upgrade. Would microsoft MDT work for this?