Office Software Forum - solved topics
- Excel (9,854)
- Open Office (118)
- Outlook (652)
- PDF (337)
- PowerPoint (187)
- Word (2,189)
- Solved
-
looking for duplicate numbers from one column Solved/Closed
Hello, i have 4300 old applicant numbers which i need to check against 3300 new applicant numbers and highlight duplicates. these are in two colu...
-
Excel: If A1 = a 4 the comy content of b1,2,3 Solved/Closed
Hello, Please help! If A1 = a 4 the comy content of b1,2,3,4,5 to c1,2,3,4,5 The 4 in a1 are generated by a formula. Thanks Confi...
-
Formulas to search for certain words in cells Solved/Closed
Hello, I have monthly bank statements that are downloaded into excel, over 2500 line items. In Column A, I have the description of the transac...
-
system password remove Solved/Closed
Hello, how i can remove system password Configuration: Windows XP / Internet Explorer 7.0
-
Excel - Help! Solved/Closed
Hello, I require a formula which will recognise months in a column and select taht value from a different cell on the same row. The data is the...
-
Format using Macro Solved/Closed
Hi I have some data in sheet1. Eg: Column A Column B Column C Column D 1 2 3 4 ...
-
Filter rows in one sheet Solved/Closed
Hello, I have large amounts of data in one work sheet(say it as Sheet1) and another worksheet(sheet2) has few records(100) which are also present ...
-
converting rows data into columns on conditon Solved/Closed
Hello, I have data which looks like below ColA-----------ColB-------ColC--------ColD------------ColE---------ColF-------ColG----ColH-------- AA-...
-
delete cells/rows but keep row info intact Solved/Closed
hello, I am trying to import data from an excel spread sheet to access. I want to clean up my excel report before I import the date. In my report...
-
Looking for value in a column A Solved/Closed
Hello, I have to prepare an invoice and calculate the amount of shipping. This is the lay out: I have to compare the subtotal value, E16, in ...
-
Dates in Excel Solved/Closed
Hello, I have a list of people's birthdays in a list in Excel. I want to retain only the day and month of the birthday and get rid of the year. For ...
-
Excel Comparing 2 columns removing duplicates Solved/Closed
Hi, 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 Solved/Closed
Hello 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 Solved/Closed
Hello, 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 Solved/Closed
Hi, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hi, 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 Solved/Closed
Hello 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hi , 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Dear Sir, Please help me number convert to word in excel which formula Hello, Configuration: Windows XP / Safari 534.13
-
help with excel Solved/Closed
Hello, 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 Solved/Closed
Hello, I have a coding like this: filename = Range("B3").Value Workbooks.Add Set newwb = ActiveWorkbook ChDir "D:\P3\Jan-11\B2B" ...