The discussions
Excel 2007
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
SolvedHello, 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
ClosedHello, 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.
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
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
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
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
SolvedHello, 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
SolvedHello, 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
SolvedHello, 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
ClosedHello, 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
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
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
SolvedHello, 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
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
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
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?
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
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
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
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
Hello, I have an Excel 2010 worksheet with the following data Name ID Qty Joe 123 15 Bob 456 8 Ed 234 ...
Times formate
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
SolvedHi 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
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
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
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
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
SolvedHello, 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 ...
Inserting rows with formulae on existing data
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
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
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
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 !!!
SolvedHello, 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
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
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
SolvedHello, 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
SolvedHello, 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
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
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
SolvedHello, 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.
SolvedHi, 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
SolvedHello, 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
What is formula of Greatest Common Divisor in Excell 2003. Please reply me through mail. regards, Goutam Goswami
On the excel codes
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
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...
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...
Excel search macro
ClosedHello, I have a very tricky problem. I have got an excel sheet having some columns but more than 5000 rows. In those columns there are some names w...
Conditinal formattin
SolvedHello, If e1 cell is contains "closed" the entire row (or) a1:e1 should be highlighted in red color. Configuration: Windows XP / Internet Explo...
