Office Software Forum - solved topics
- Excel (9,851)
- Open Office (117)
- Outlook (652)
- PDF (334)
- PowerPoint (185)
- Word (2,189)
- Solved
-
forgot password of memorycard Solved/Closed
Hello, i forgot my password of my memorycard of nokia 3110c.. pl help me to change password.. thank u
-
Excel If Function over a range of dates Solved/Closed
Hello, Can anyone help please? I am trying to add a divisions column, which are taken from a date range in another column. i.e. I would like to add "...
-
INSERT AND ORDER THE COLUMN Solved/Closed
Hello, It has A, B, C, D, E Columns and less then 6500 rows as per given example. A and the B column are fixed. I want to reorder compare "C" co...
-
Add cells, div by cells with value (Excel2007 Solved/Closed
Hello,can any help!(excel 2007) A B C ...
-
Excel Formula to show Zero Solved/Closed
Hello, I'm using the formula =A2/(A2+A3) in A4, same in B to AF, i need the A4 line to show a zeros when A2-AF2 and A3-AF3 do not have values in. ...
-
compairing two columns A&B Solved/Closed
Hello, column A column B 5000 4001 5001 4080 5002 4445 5003 4493 5004 4...
-
Network Days Solved/Closed
Hello, I need some help if any one can assist, please... I have a date in a Excel S/S so i.e. 15/02/2010 and under this i have a number of days ...
-
Excel formula converting time difference Solved/Closed
Hello, i want to know the excel formula...below iam giving the details, In table A is my starting time e.g.10.49 and in table B is my reaching time...
-
deleting alternae rows Solved/Closed
Hello, I want to delete every alternate rows from my work sheet. I tried recording macro, but it only deletes a particular row as shown in macro bel...
-
Linking Spreadsheets Solved/Closed
Hello, I'm trying to set up a cell that will draw information from another spreadsheet using excel 2007 The spreadsheet I'm pulling the info fro...
-
Copy rows to total page Solved/Closed
Hello, I have an Excel spreadsheet with 13 worksheets. The first 12 worksheets are January through December. The 13th worksheet is a total. Each...
-
Creating a directional macro Solved/Closed
Hello, I am not familiar with writing macros at all. I created a form and I need a macro so that when I input data in a cell the cursor will automat...
-
Conditional Formatting or IF using Dates Solved/Closed
Hello, I am trying to change the colour of an entire row to 3 different states depending on the result. The row needs to stay clear if the date ...
-
Formate date to TERM or warranty period Solved/Closed
Hello, I have Purchase date and expiration date in a format of yyyy/mm/dd. I want to get the term of how long will it take from purchase date to e...
-
Excel - delete rows when alike Solved/Closed
Hello, I am in need of a formula to solve this problem. I want it to find similiar cells and delete those cells from the worksheet. Here is a sa...
-
Network days Solved/Closed
Hello, I am trying to run the network formula days using the below formate as teh date, clearly this doesnt work anyway I can adapt this suit or anyw...
-
Subtract a Date/Time Solved/Closed
Hello, Can anyone help me with a formula in excel 2007 to subtract eg 11/01/2010 5:12 AM from 15/01/2010 7:30 PM. Thanks
-
How To Create Macro to Search, Copy, & Paste Solved/Closed
Hello, Here's what I want to do. I have a worksheet with customer data by row and I also have a worksheet with an invoice I want to auto populate w...
-
comparison between two excel sheet Solved/Closed
Hello, i have two excel sheet with same value which i need to compare every day .with in same excel sheet i can compare easyly using conditional form...
-
compare two lists and change row colour Solved/Closed
Hello, I have two different workbooks, lets say workbook 1 and workbook2. In both workbooks i have a column with barcodes. I need a vba to check ...
-
Excell Solved/Closed
Hello, I need a formula that will take the sum of a group of cells from a worksheet and apply them to a specific place on another worksheet. All i...
-
ms frontpage Solved/Closed
Hello, I can not find ms frontpage, I have clicked form start menu ==> all program ==> ms frontpage is nothing. How to add this ms frontpage & whe...
-
help with interface/msgbox in vba Solved/Closed
Hi, I'm in a VBA course and I'm having a lot of trouble with one of the problems: The settling velocity of a particle of liquid can be estimated us...
-
Excel: use if to find & change text in column Solved/Closed
Hello, i want to search column "a" with numbers as text as follows: #305 #777 #78 #82 #884 i need a formula that will search column A an...
-
Excel Macro Programming Solved/Closed
Hello, It's been a while since I last wrote my own macro and I can't remember how to do this one up. I have a pull down list in excel, using data ...
-
Date formating in letters using Mailmerg Solved/Closed
Hello, I use mailmerg in Microsoftword to format various letters. data is imported from an excel sheet and letters are formatted in Microsoftword. No...
-
RANKING ON EXEL Solved/Closed
Hello, In exel i know its possible to rank data, but im stuck on how to do this: Say i have the following data: Activities: 16...
-
macros excel 2004 problem Solved/Closed
Hello, guys i please need help with this problem...i have macros that i use daily, i recently got a mac and i have mac office 2004, i try to copy and ...
-
Macros to sort data with respect to the colum Solved/Closed
Hello, I am facing a problem in sorting the data w.r.t to column header. I have 25 columns in which i need to sort the sata w.r.t to two of the col...
-
EXEL HOW TO FIND MAX Solved/Closed
Hello, On exel i know its possible to get the computer to find the MAX value from a set of numbers, but in my case i want it to find the max value but...
-
extract a specific data from a cell Solved/Closed
Hello, I have a column of data in text format in excel, that has a persons name, date and time. I am only interested in one person's name, date and ...
-
return zero in cell that contains a function Solved/Closed
Hello, need to return zero within a cell when the cell contains a function already: I have this function already, but cannot paste the function...
-
Excel Macro to Scan document and combine rows Solved/Closed
Hello, I'm trying to write a Macro that will combine text from several rows in a given column (column B in the example below) into one cell as long...
-
Values Lookup in excel Solved/Closed
Hello, i want to match sheet2 with sheet1 WHERE sheet1 is the master sheet and has all columns. sheet2 has only two columns as in below demonstrat...
-
EXCEL 97 if then Solved/Closed
Hello, I would like a Cell "1" to look at two Cells, Cell "2" and Cell "3" and depending on the answer enter a positive or negative vaue of Cell "4...
-
splitting values of cell Solved/Closed
Hello, My question relates to trying to place a value of one cell separately elsewhere in the speadsheet but broken down into two cells (if needed)...
-
Excel / after print +1 Solved/Closed
Hello, My name is David (form Slovakia)! I would like to ask you for help with the folowing situation to solve: I need to prepear one document wh...
-
EXCEL 2007 NO VALUE= NO COLOR Solved/Closed
Hello, I've conditionally formated multiple cells to highlight green when the inputted date is within a 2 year period and red if it exceeds 2 years...
-
comparing cells and in multiple columns Solved/Closed
Hello, I have two columns A and B A has items that have been priced B has items price (no dollar sign) Is it possible to have a macro go down co...
-
Comparing value to master coloumn Solved/Closed
Hello, I am basic excel user. I have issue where i need to compare value from master table and show in the sheet. Below is the actual example. The Sh...
-
Excel Macro-Highlight if difference > or < 2 Solved/Closed
Hello, I need help writing an Accounting excel macro I am working on. It appears that everything is working fine, except for one part I need some h...
-
Excel "IF" formula problem Solved/Closed
Hello, I have a row of 4 cells each containing an "if formula" to get information from another worksheet. An example of the formula in these cells i...
-
Figuring percentages in Excel Solved/Closed
Hello, we are doing a weight loss contest and trying to figure out a formula to do the math. We need a formula that will figure the cumulative pounds...
-
Marco help! One macro for multiple row tasks Solved/Closed
Hello, I have two separate workbooks that I need to compare. Task at hand is I have to find specific text in workbook 2 (col A) and once found - ...
-
unique text formula question in excel Solved/Closed
Hello, I have 2 columns of names in columns a & b and a list of dates in column c. Column A has a unique name in each cell. Column B had the same 5 o...
-
update dates in excel spreadsheet each year Solved/Closed
Hello, i have 4 spreadsheets linked together which i use to keep track of my accounts. all 4 spreadsheets are in one folder. On each spreadshee...
-
To add row after 24 rows and get the sum Solved/Closed
Hello, I have hourly data of one year in rows without any break. I want to add row after 24 hrs and get the sum of all the coumns in that row. In oth...
-
Greater Than 0 & Less Than 30 Solved/Closed
Hello, i need the formula of this quotation: B2 Is Input Value Cell D2 Is Formula Cell If Cell B2 Is Greater Than 0 & Less Than 31, Than For...
-
Count number of days between two entries? Solved/Closed
I have an Excel workbook with daily entries of my lunch and dinner meals. On a separate sheet, I'm counting the total number of occurrences of each me...
-
Find and return a specific number Solved/Closed
Hello, I am trying to find out how to display a specific number. I have 3 columns, each showing a results from a test as follows: 3 =fail ...
