The discussions
Excel comparing 2 columns removing duplicates
SolvedHi, I would like to cmpare 2 columns in an Excel spreadsheet & remove duplicates from Column B if any matching fields are found e.g. A B 1 ...
Excel 2007 vlookup and match problem
SolvedHello Long time lurker, first time poster. I'm having an issue with a Vlookup and match function. I have a set of data that is organised and sorted...
Transfer barcode info to inventory quantity
SolvedHello, Is there a way to create a macros that would keep track of inventory quanitity by scanning a barcode? I have many boxes that have barcodes...
Office 2010 requirements
SolvedHi, What are the requirements to install office 2010 on system?the minimum ram required? Please reply as fast as possible
Dell d505 booting password reset
SolvedHello, DELL MODEL D505 BIOS REV. A09 laptop show service tag #9R1ZM1J-595B PLEASE TELL ME IF ANYONE HAVE SOLUTION Dell Latitude Bios Password un...
I forgot my password
SolvedHello, could some one please help me i have a dell laptop inspiron 7500 and i cant log in i forgot my password can you help me ...
Pie chart comparison
SolvedHello, I have made a number of different pie charts & want to compare them with each other. Each pie chart is comparing the same thing but the ...
I forgot my login password for my compaq cq60
SolvedHello, i forgot my login password on my compaq CQ60 laptop, i just recently changed it and now i can't remember it. Can i please get a reply ASAP
How to do if statements in excel
SolvedHello, I am having a problem trying to get an if formula right. If fig1 is +- 10% of fig2 I want it to say Fail If fig1 is within 10% of fig...
Summary sheet
SolvedHello Sir, I Have 30 Data Sheets Of Individual Date & 1 Summary Sheet. The Example Of Those 30 Sheets Are: A1------------B1------------------...
Assign a value depending on the font color
SolvedHello, Can someone help me with this. I have a column with some text in each cell of that column. The text font is in either red or black co...
Searching a column for a list of values
SolvedHello, I am using a macro to search for a list of values that i want to be written into the macro (Permanently). currently i am looping after each s...
Count appearances of specific words in excel
SolvedHello, I have a spread sheet with names of countries in the first column and over 1300 lines of text in the second column. I want to count number of t...
Regarding samsung sgh-m20 slider password
SolvedHello, please help me to reset the password for my mobile samsung sgh-m20, whose password has been forgotten by me. regards rajesh
Bar and stacked bar graph in single graph
SolvedHello, hi i have to make chart using three field month wise. and i want to make bar for first field and stacked bar for next two within same graph...
Dell latitude d-505 config password lost
SolvedHello, Dear I have forgot the Confiq password of my Dell latitude D-505, which tag No. is 52MSW41 PLZ do help to reset or deactivate the said p...
Found cell color and worksheet viewing
SolvedHello, The code below had cause the found value cell color to remain there even after I closed the Input Box.I would like to have the color to be re...
Compare the values and multiply the greater
SolvedHello, A B 58.85 503.171 I want to compare the values in Column A and Column B and then multiply the greater with nu...
Startup password
SolvedHello, I just purchased a d260 mini secondhand and I stupidly thought I could change the administrator name, but of course it would not let me cha...
Remaining retirement calculation
SolvedHello Sir, I Wanna Calculate Few Things A1 Is My Date Of Birth A2 Is My Date Of Joining I Want Few Formulas Using These Two. First Thin...
Lost password -sa6 pink
SolvedHello, My grand kids changed the password on her laptop cannot rember the pasword i need a disk.Thanks Configuration: Windows Vista / Internet ...
Macro to define a interval
SolvedHello, i have a excel sheet of details of employee of the organisation. in that sheet I have a column D of age. I have to define age interval f...
How to make xl readonly true or false on cond
SolvedHi, I have an requirement like need to open an excle workbook and make it as readonly false then copy some rows to dat workbook then again make it ...
Vlookup
SolvedHello Sir, In Sheet1 I Have Numbers Like A-----------------B------------ 4050 6080 9060 And In Sheet 2 I Have Data Like: A--------...
Find, select, copy, paste elsewhere in para
SolvedHello, Can anyone help in the following matter: How to find, select, copy and paste elsewhere the paragraphs containing specific terms in...
Adding new data sets to multiple worksheets
SolvedHello, I am creating a spreadsheet database for data to determine the best vendor to use. I have multiple vendors on different worksheets and the...
Macro to copy rows from one worksheet to anot
SolvedHi , I'd like to know if there's a macro that can be run to check one worksheet. In this worksheet there is a column where the value should be "true"...
One button to execute two macros
SolvedHello, I got one macro in Sheet1 and another macro in sheet2 under the same workbook.I want to assign a button in sheet1 so it can execute both the ...
Excel formula a+b=c with the following except
SolvedHello, I really could use some help please. I am working on an 2010 excel spreadsheet. Would anyone know if there is a formula to do the following....
Use excel vba to create an e-mail w reminder
SolvedHello, I create a file in Excel that does some calculations based on a small database and some user input. I then added a button to open an e-mail...
Overtime calculation
SolvedHello Sir, I am having problem doing my work at office. I want to calculate the overtime hours of the employees. A1 is Time In where i...
Filter all pivot table by same criteria
SolvedHello, I am using excel 2007. I have a data on sheet1: I had make 4 pivot tables from that data in four different sheets: Now I have ...
Toshiba password reset disk
SolvedHello, hi how r u good i hope anyway i forgot my password on my toshiba satalite laptop is there any thing i can do from home to fix this Confi...
Codes explaination
SolvedHello, I have an text in excel as below. 1 1 1 2 2 2 3 3 3 After running a macro Iam getting the result as below. 1 ...
Macro to highlight a row if cells match value
SolvedHello, I sorry but I am very new to macros and trying to create one in Office 2003. I need to bold a row if for example column E is greater than a...
Count if macro on multiple criteria
SolvedHello, Could someone please help me out with a count-if macro on multiple criteria. I have attached a sample file in the below link http://ww1....
Number convert to word in excel which formula
SolvedDear Sir, Please help me number convert to word in excel which formula Hello, Configuration: Windows XP / Safari 534.13
Help with excel
SolvedHello, i have two speadsheets. the first sheet contains a total column EX: in C4 =SUM(E4+G4+I4+K4+M4) Value of C4 = (339816) on the ...
Macro not saving file in excel format
SolvedHello, I have a coding like this: filename = Range("B3").Value Workbooks.Add Set newwb = ActiveWorkbook ChDir "D:\P3\Jan-11\B2B" ...
If then excel entry
SolvedHello, In excel, I have a row where hours worked is entered. Directly underneath that row is another row where allotted break time needs to be ...
Repeat formula within cell
SolvedHello, im a newb with excel and I need to know how would you make this formula repeat within the same cell.. =IF((AND(E9="DOA",S9="Hardware")),...
Create a backup copy
SolvedHello, How do I create a backup copy of original file every time I run macro in excel? Thanks Configuration: Windows 2000 / Firefox 3.6.13
Add same value of a column
SolvedI have two columns A & B like this A B 32 7000 33 8000 32 9000 33 6000 39 10000 and so on, I would like to get in column...
Conditional formatting in excel 2007
SolvedHello, I am trying to apply conditional formatting to a calculated cell (For ex A). Criteria: If Cell A value = Cell B or " - " then ...
For got my yahoo password
SolvedHello, sir i forgot my yahoo password in 2 question i remember one and another i do not remember please help me iwill be obliged i am orgnly i...
I forget my yahoo password
SolvedHello, my name is roshan i loss my yahoo account password. i remember only my alternet email and one secret question .pls hep me Configuratio...
Select and copy only nonblank cells
SolvedHello, many thanks in advance for any responses I get here, I have toiled in vain on this for hours now. At first it was acceptable to simply c...
Help with conditonal formatting
SolvedHello, On our work tracker we have a 10 business day turnaround to get work completed. Currently we have a formula that works out how long it...
Date diff in excel 2010
SolvedHello, So I want to figure out how to write a formula for a difference in days on a "visit log". I want excel to look in multiple cells. (basicall...
How to name excel sheets on values in columns
SolvedHello, I have a list of people names in a column in one sheet with additional cells in each row for adding data. I want to create separate excel s...
