The discussions

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...

1 reply Last reply on 6 Jun 2011 by
rizvisa1

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...

1 reply Last reply on 6 Jun 2011 by
bionik

Text function does not change date format

 Solved

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...

1 reply Last reply on 6 Jun 2011 by
TrowaD

Simple excel formula help

 Solved

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...

1 reply Last reply on 6 Jun 2011 by
TrowaD

Forgot my admin password on my old dell 630c

 Solved

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...

1 reply Last reply on 4 Jun 2011 by
bionik

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...

5 replies Last reply on 4 Jun 2011 by
amaresh

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...

1 reply Last reply on 3 Jun 2011 by
rizvisa1

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...

2 replies Last reply on 3 Jun 2011 by
vreexs

Msgbox retry/cancel buttons are confusing me

 Solved

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...

9 replies Last reply on 3 Jun 2011 by
TrowaD

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...

3 replies Last reply on 3 Jun 2011 by
rizvisa1

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...

3 replies Last reply on 3 Jun 2011 by
rizvisa1

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...

1 reply Last reply on 2 Jun 2011 by
xpcman

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...

1 reply Last reply on 2 Jun 2011 by
rizvisa1

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...

1 reply Last reply on 2 Jun 2011 by
rizvisa1

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...

1 reply Last reply on 2 Jun 2011 by
rizvisa1

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...

3 replies Last reply on 2 Jun 2011 by
rizvisa1

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 ...

1 reply Last reply on 2 Jun 2011 by
RWomanizer

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...

1 reply Last reply on 2 Jun 2011 by
RWomanizer

Excel name match query

 Solved

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...

5 replies Last reply on 1 Jun 2011 by
Guest user

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...

1 reply Last reply on 1 Jun 2011 by
bionik

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...

7 replies Last reply on 1 Jun 2011 by
rizvisa1

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...

2 replies Last reply on 31 May 2011 by
nandu

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...

16 replies Last reply on 31 May 2011 by
rizvisa1

Split data into multiple sheets using macro

 Solved

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 ...

16 replies Last reply on 31 May 2011 by
rizvisa1

Colored signature in thunderbird

 Closed

Hello, How can I put color in my thunderbird signature.

2 replies Last reply on 31 May 2011 by
krish

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...

3 replies Last reply on 31 May 2011 by
rizvisa1

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...

1 reply Last reply on 31 May 2011 by
RWomanizer

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...

3 replies Last reply on 30 May 2011 by
Ambucias

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...

3 replies Last reply on 30 May 2011 by
Anonymous User

If function error !!!

 Solved

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 ...

38 replies Last reply on 30 May 2011 by
Waseem

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...

1 reply Last reply on 30 May 2011 by
rizvisa1

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, ...

1 reply Last reply on 30 May 2011 by
RWomanizer

How to calculate a alphabet

 Solved

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 ...

12 replies Last reply on 30 May 2011 by
Hilda

Memory card password

 Solved

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 ...

2 replies Last reply on 29 May 2011 by
shareek

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...

1 reply Last reply on 29 May 2011 by
bionik

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...

1 reply Last reply on 27 May 2011 by
rizvisa1

Matching word phrases over different cells

 Solved

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...

5 replies Last reply on 27 May 2011 by
rizvisa1

Excel macro help.

 Solved

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 ...

7 replies Last reply on 27 May 2011 by
TrowaD

Excel macro to identify/modify/combine cells

 Solved

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...

3 replies Last reply on 27 May 2011 by
TrowaD

Formula of greatest common divisor

What is formula of Greatest Common Divisor in Excell 2003. Please reply me through mail. regards, Goutam Goswami

1 reply Last reply on 27 May 2011 by
RWomanizer

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...

1 reply Last reply on 27 May 2011 by
RWomanizer

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...

1 reply Last reply on 27 May 2011 by
RWomanizer

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...

2 replies Last reply on 27 May 2011 by
RWomanizer

Excel search macro

 Closed

Hello, 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...

4 replies Last reply on 26 May 2011 by
Birpal_Buttar

Conditinal formattin

 Solved

Hello, If e1 cell is contains "closed" the entire row (or) a1:e1 should be highlighted in red color. Configuration: Windows XP / Internet Explo...

2 replies Last reply on 26 May 2011 by
TrowaD

Excel macro for moving content

Hello, I need a macro that will search for a specific set of values in a specific column for each row of a subset of rows. Example data can be ...

6 replies Last reply on 26 May 2011 by
rizvisa1

Vba code for a if function

 Closed

Hello, I need help on the following: Selecting a range on data e.g A1:A14 Searching for a certain value e.g 3000 if query is true then copy a ...

5 replies Last reply on 26 May 2011 by
Mukesh

Multi criteria conditional formatting

 Solved

Hello, I am trying to work out how to reference to cells for an if statement using conditonally formatting (through VBA), I have come up with the ...

4 replies Last reply on 25 May 2011 by
bretsh

Adobe acrobat setup problems

Hello, during the setup of adobe acrobat, an error telling me that it could not connect to the server comes up. how do i fix this or what am i doing...

1 reply Last reply on 25 May 2011 by
xpcman

Comparing data

Hello, I would like to look at two columns A and C and then if they match take the quantity in column D and insert it in Column B. So Column A ...

2 replies Last reply on 25 May 2011 by
rizvisa1
Results 6251 - 6300 out of a total of 12,262