Office Software Forum
- Excel (9,733)
- Open Office (113)
- Outlook (637)
- PDF (334)
- PowerPoint (174)
- Word (2,183)
-
conditional formula [Solved/Closed]
Hello, Hi everyone, Just want to seek for your help about some conditional formula about excel. I just want to create program about our inven...
-
Macro help [Closed]
Hello, i use a macro for filering my data into another and macro code is Sub Extract1() ' ' Extract1 Macro ' extract ' ' Keyboard S...
-
Excel 2007 [Closed]
Hello, I am a very novice/beginner Excel user. I have a table of Company information in a vertical column which I want to convert to a horizontal...
-
Word settings [Solved/Closed]
Hello, I change some of my settings when I went to word options on my vista word document, now when i open a blank document it is full of grid square...
-
EXCEL Move A1 to A2 in a formula [Closed]
Hello, I have a 9 digit zip code in column A. I need to phyically move the first 5 digits to column B cell by cell, i.e. A1 to B1, A2 to B2, e...
-
Conditional counting of days. [Closed]
Hello, If you could help with some coding in MS Excel, it would be really appreciated. I want to basically have a cell that starts counting the ...
-
Word search in Excel [Closed]
Is there a function that can search the entire worksheet (all columns & rows) for a given word that the user inputs and then the output would be the c...
-
Excel question [Closed]
Hello, I am using Excel for inventory and invoicing. They are in different workbooks. I have to fill in the information in each workbook. My ques...
-
memory card password [Closed]
hi i have micro SD memory card i am using nokia 3600 slide very long back i kept a password to memory card but have forgot the password if i want to o...
-
TEXT function does not change date format [Solved/Closed]
Hello, I'm using the CONCATENATE function to put together a sentence mixing text and date. The formula I'm using is: =CONCATENATE("Text part he...
-
Simple Excel Formula Help [Solved/Closed]
Hello, Configuration: Windows 7 / Firefox 3.6.17 Hey guys I'm doing some project on Excel for a class. When it comes to entering and crea...
-
forgot my admin password on my old dell 630c [Solved/Closed]
Hello, i forgot my admin password on my old dell 630c can you help me reset or delete the password so my laptop will boot up>? windows vista/os i...
-
Excel row removal/selection [Closed]
Hello, I am trying to select certain rows from a very large data sheet. Ideally I would like to select every 25th row so as to get a random sample of...
-
Excel 2007 conditional format question [Closed]
Hello, I have an excel 2007 file which I wish to be able to highlight a row if the first two cells in that row equal "Large code model" in the fir...
-
Excel - Macro|group by|based on time interval [Closed]
Hello, I need to write a macro for following example (copy and paste to excel with comma separated ',' delimiter). MS start and MS end column have...
-
Msgbox Retry/cancel buttons are confusing me [Solved/Closed]
Hello, I can't figure out what's wrong with my code. Hopefully someone can enlighten me. Here is the code I'm using: Dim x As Integer Sub Adj...
-
Cut Entire Row To Another Sheet Based on Cell [Closed]
Hello Dears, If any one can help me. I have 2 excel sheets, Sheet1 "All Invoices" and sheet2 "PAID Invoices". In sheet1 I have several column...
-
Excel: check text in cell, add values [Closed]
Hello, I'm trying to create a formula to check a cell for a certain string of text, and then if it contains it, take the value of a number in that...
-
having difficulty loading Outlook Express 6 [Closed]
Hello, I am having difficulty since switching to Comcast X-finity server in loading my Outlook Express. I usually use Mozilla as a browser, is tha...
-
INDIRECT formula alternative? [Closed]
Hello, I would like to know if anyone can offer an alternative to using the INDIRECT function in a formula in order to pull from another worksheet...
-
Comparing & replicating data, 2 Excel sheets [Closed]
Hello, all. I have 2 sheets of a spreadsheets I'm looking at in Microsoft Office Excel 2007. On the first sheet: a) I have 300,000 rows of user inf...
-
Returning a column and row location [Closed]
Hello, I Have a 2 tables that are identical (3 column by 11 rows) that have unsorted data. I set up a formula to take an inputed row numbe...
-
Excel Help [Closed]
Hi Everyone. Hope you guys can help. This is what I need I have 3 sheets in excel. Sheet 1 is my master and has products listed according t...
-
Excel Formula to Create Rows Based on qty [Closed]
Hello, I have an Excel 2010 worksheet with the following data Name ID Qty Joe 123 15 Bob 456 8 Ed 234 ...
-
times formate [Closed]
Hello, I have one doubgt, i,e. i had a excel 2007 model, i want time formate i,e. start time & end time = how much time he taken, so please tell m...
-
Excel name match query [Solved/Closed]
Hi I have a column (A) in excel that lists all of the staff in an organisation, and in column B is their telephone number. In column C is a list o...
-
Memory card password [Closed]
Hello, I have NOKIA 2700 and i had put a password for the memory card and now I have forgot the password so if u can help me thank you Con...
-
Need Individual Sheet Data to Copy to Main Sh [Closed]
Hello, I have a workbook I've created to track sales leads. I have a main sheet called "directory" and individual sheets for each business I conta...
-
http status 404...apache tomcat/5.5.20. error [Closed]
Hello, ........please help me...to over come from.....HttpServletResponse.....problem......i getting....http status404...apache tomcat/5.5.20....error...
-
Recording Macro with IF(OR(AND function [Closed]
Hello, I have recorded a macro on Excel with the function IF(OR(AND done but when I try to run the macro file in the test datafile, an error occur...
-
Split data into multiple sheets using macro [Solved/Closed]
Hello, Configuration: Windows Vista / Firefox 4.0 I have an excel sheet with the data in following manner. a b c d 1 1 1 1 2 2 2 2 3 ...
-
Colored signature in thunderbird [Closed]
Hello, How can I put color in my thunderbird signature.
-
Inserting rows with formulae on existing data [Closed]
Hello, I wanted to know if a macro could help me deal with the following: The data is something like this: Column Field1 Field2 Field3...
-
Filter excel data using formula [Closed]
Hello, I have some data in excel, where I need to run filter option. But due to some constraints, I cannot use the manual option of filter in exce...
-
WinWord 2010 icon weird in taskbar [Closed]
Hello, when i open microsoft office 2010 everything isSTUFFED the icon does not show it is meant to and some other exe have weird taskbar icons...
-
import contacts from outlook to MS Works [Closed]
Hello, Will anyone please tell me how to import contacts from Microsoft Outlook 2007 to Microsoft Works. Configuration: Windows 7 / Safari 4264...
-
If Function error !!! [Solved/Closed]
Hello, I have created a time tracker worksheet for my process. Am just stuck up with one function. I have used the below function which has 8 ...
-
Need Excel Macro [Closed]
Hello, I am looking for a function or macros to compare two cells in two rows and return True if it has partial match. And one more condition to s...
-
sum only numeric value [Closed]
Cell A1 Rs.100 A2 Rs.150 A3 Rs.160 Please tell me how I can sum only numeric value. Please tell me the formula. Regards, ...
-
how to calculate a alphabet [Solved/Closed]
Hello, for my workers I am mainaning attandance sheet and every month I have to send it to my head office. for their presents iam putting P and for ...
-
Memory Card Password [Solved/Closed]
Hello, Hello, i have a micro SD card for my phone2700 Classic NOKIA and its password protected and i forgot password i cant open it from my ...
-
micro sd card password lost [Closed]
Hello, i had a nokia 7210 supernova phone and i had put password to its micro sd card (1GB) bt nw i am using nokia 3110c phone but the same memory...
-
Excel linked to database [Closed]
Hello, i m working on a excel sheet which is linked to database ,which means whenever i refresh it gets updated.i have created a new column in tha...
-
Matching word phrases over different cells [Solved/Closed]
Hello, I receive batches of text and need to weed through the duplicates. I have figured out how to find exact matches like "Good Food"repeated t...
-
Excel Macro Help. [Solved/Closed]
Hi, I was wondering if someone could help me develop a macro that would reference a row in another worksheet. So for example if Column H = "x" in ...
-
Excel macro to identify/modify/combine cells [Solved/Closed]
Hello, I have a collection of survey results in Excel that are coded from another software that I need to prepare to put in SPSS, the results come...
-
formula of Greatest Common Divisor [Closed]
What is formula of Greatest Common Divisor in Excell 2003. Please reply me through mail. regards, Goutam Goswami
-
on the excel codes [Closed]
Hello, I have copied the code, but from tools i try to run and a msg "type mismatch" pops up..what next?thanks Configuration: Windows XP / Inte...
-
Excel help required [Closed]
Hello, I have data from A1 to A10 I want A1 in sheet2A1 A2 in shett2A2 ........ and so on will u please hel...
-
MS Excel 2007 Date format issue... [Closed]
Hello, I have an XL spreadsheet with abt 15k rows, with a variety of data, the important ones being the dates - a start date and an end date. Based...
