The discussions
Compare lists in excel
Hello, I have 3 lists. A1:A500 contains names. B1:B500 contains dept codes associated with names in A1:A500 C1:C500 contains names of people wh...
Need help comparing data in two spreadsheets
Hello, I have two excel spreadsheets, both of which contain customer account information. I need to compare the two to find all accounts that are ...
Date ofbirth between 01/01/1995 to 01/01/2005
SolvedHello, I have a userform with a text box name txtdob. i m trying to do if i add a date in text box between 01/01/1995 to 01/01/2005 then msgbox ...
How to apply sumproduct formula
Hello, i am facing a problem while applying the sumproduct formula. pls, solve this for me eg sheet2.:=SUMPRODUCT((sheet1!$C$2:$C$65...
Copy non-contiguous cells to another sheet
SolvedHello, I have the code below that only works for copying cells B2,B3,C3,E2,E4 from active sheet to the same identical cells on sheet2. Cells, B2,B...
My new hotmail 8.2010
SolvedHello, Its Graham here, when thay changed the windows live to hotmail about a week ago,something went wrong. I can recieve email but cant send. And th...
Mail.com messages to blackberry
SolvedHello, i have a blackberry and my mail.com messages are not coming through as from this morning, does anyone know how to resolve this problem? ...
Outlook: who did i forward an email to?
Hello, I'm a gmail person but at work I have to use Outlook 2003. I've searched all over the internet but cant seem to use the right string of wor...
Webcam password
SolvedHello, I have loptop dell inspiron 1545 windows xp I have a problem in my webcam, when i logon webcam it need a password but i don't know the password...
Repeated number and multiple results
SolvedHello, Want to know i have two columns in excel, sheet 1 Column 1 - date Column 2 - Unique number Now, dates are not given in a customised fo...
Excel lookup latest in list
Hello, Oh what a challenge this is turning into! In a nutshell i would like to lookup the description of a product in a cell, based on the product...
Password recovery?
SolvedHello, I need a password for dell latitude c840 #7TFHX11-595B. i put in admin. pw but then it asks for hard drive password and I have no clue....
Forgot my password
SolvedHello, CAN I HAVE A INPUT PHONE LOCK CODE FOR A CHINESE GPS PHONE Configuration: Windows XP / Firefox 3.6.9
Samsung m310 forgot my password
SolvedHello, I forgot the password for my samsungsgh-m310l can u assist??? Configuration: Windows 7 / Safari 533.4
I forget my imation 2gb pendrive pasword
Hello, i forget my imation pendrive pasword in this pendrive my imprtent datda if this data is not in pendrive so my ceriar in the tention so pleas s...
Internet works... but not for msn apps?
SolvedHello, I recently wiped my whole computer and reinstalled Windows XP sp2. After some toil, I got everything working right. Well, I actually had to ...
Password to login...
ClosedHello, I didn't forget my password, but today when I've typed my password I couldn't login. I have Sony Vaio with windows Vista business. To reset pas...
Date to number format using macro
Hello, in a macro I have captured the date into a variable. I need to convert that date to a number format to used for further processing. thanks,
Excel help needed: comparing cell contents
Hi all, Is there a way to compare the contents of a cell with a different cell using TRUE/FALSE results? For instance, cell A1 contains: Jr3 ...
Conditional formatting 2003 - highlight cell
Hello, I am looking for ways on how to apply conditional formatting if column B cell value appears to be lesser than column A. What should be t...
How can i lock my computer by password ms dos
SolvedHello, Please I Pintu how can I lock computer by password by dos and re open by password?Configuration: Windows XP Internet Explorer 6.0
Office -2003 short cut keys in excel
SolvedHello, How to merge cells in ex-cel-2003 by key board short cut key.
Selecting excel button using arrows
Hello, I have been using vba programming to make excel workbooks usable by those with visual disabilities. I need to make a button that can be se...
Copy nos from filter menu of excel sheet
Hello, How can I copy numbers / names / etc from filter menu of excel sheet
Ms office (2003)
Can anyone help. I've got a problem today, as Outlook lost all my e-mails (and all my folders where I've saved e-mails). The problem arose when I...
Two work sheets cell comparison..
Hello, Im trying to do a vba excel, how can i compare a Range of cell in worksheet A to worksheet B, whein if the condition is true it will upda...
Excel formula/function help
Hi I need to create a formula in excel that will copy only values over 0 in column AH into new worksheet along with the corresponding text in colum...
Login password will not work
Hello, I set my administrator password for my computer last night and after restarting was not able to login. This is the first time I've tried to us...
Type one function in one cell but output...
Hello, sorry for bad english....i wanna see selected or multi-cell will show result if i type function in one cell...how could it possible ple...
Amount in words pogram
Hello, sir ple. give me a ans. for my ques. my ques. is how to use for windows -7 formet of indian amount transfer in words Configuration: Win...
Help with formula
Hello, I am trying to create a fax coversheet that autofills in a specific cell the data that correlates to a particular name selected from a drop...
I need a macro that compares a list of words
Hello, I have an Excel sheet with a list of words in a column C. I Need a macro that compares the list of words in column C cell by cell with a...
Change color of 2nd high value
Hello everyone,, Last time thanks to venkat1926, i solve my problem. Right now i just wondering is there anyway i can find out second high valu...
Word to pdf
ClosedHello, I'm facing a serious problem while converting word document to PDF file. The main issue is the images with some text part. During convertio...
Autofill macro or anythin tht could help.....
Hello, I have a XLSX file of my products list, there are 3959 parts total. They go like this Column A 07 11 9 900 250 07 11 9 900 673 0...
Compare 3 columns
Hello, Please help me. I stuck with excel formula. Need help....if two consecutive "y", the comment is "action". A B C Comment y y y - y ...
Locked my drive with folderlock password
Hello, Configuration: Windows XP / Firefox 3.6.8i have locked my drive with folderlock and i forgot the pasword .please tell me password.
To calculate percentage
Hello, i have to calculate percentage of 643 out of 850 please solve it.
Storing previous result....
Hello, This is probably ver simple but I cant figure it out. I have a sales spreadsheet that has Month Target and then lists each date in a month ...
Updating one worksheet using data from anothe
Hello, Document name: csg_na_event_table_D-2010-09-03.xls Tab/worksheet to be updated: csg_na_eventinfo Tab/worksheet that has data that needs t...
Excel spreadsheet
Hello, I would like a cell to contain the sum of one row, but if the second row has figures entered i would like it to show that; e.g. Q8 has 2...
Create a list of referenced worksheets
I have a massive Excel Workbook with 200 tabs in it. One of the tabs references many of the other tabs in the workbook. I have been hunting and havi...
Wrong page numbers in word 2007 toc
Hello, When I open a Word 2007 document that utilizes the SimSun font on my PC (running Office Word 2007 SP2), the page numbers in the TOC are not...
Calculations using two seperate spreadsheets
SolvedHello, I am wanting to gather a number value already calculated in one excel spreadsheet and bring that number to another spreadsheet so I can use...
Assistance with formula
Hello, I need to come up with a formula to do the following.... Here is what I need, I need to go through column A and pull out anything doll...
Adding the results of cells w/count formulas
Hello, I'm trying to add the results of multple cells that contain count formulas to get a grand total of several lists of items. The lists are sepe...
Help formula
Hello, Hi My question more than5000 is PT 175/- & More 10000/- Salary is PT 200/- but excel formula is including tow amt is what type means PT c...
Logical test formula
Hello, Does anyone know the reverse or opposite of the following formula: =IF(N9=0,IF(O9=0,P9*(-1),O9),"") In the formula, N=Wingding2(che...
Excel droplist
Hello, In one sheet list of names will be there. While entering data in the second sheet data i would like to choose from drop list from sheet o...
Comparing data on 2 spredsheets
Hello, I'm using Excel 2007. I have 2 spreadsheets. 1 of them has a list of about 9500 post codes(spreadsheet 1 for future reference), and the 2nd ...