The discussions

Conditional formatting (> 3 conditions)


Hello, I am creating a grade book in EXCEL (Office 2003) and need to have more than three conditions for colouring the cells. Very simply, I have x...

2 replies Last reply on 10 Feb 2011 by

How to insert rows dynamically with in group


Hi, currently I am creating a macro, in to that I have data for row and columns. now I want to count the product in column A, with formula =counta (...

1 reply Last reply on 9 Feb 2011 by

Split and combine name


Hello, i have 200K data that need to be fix. let say: a1: Dr. John G. James and Mel James a2: John H. James a3: James X. Brian and Timothy F. ...

7 replies Last reply on 8 Feb 2011 by

Counting values in colums


Hello, can you help, with this i need to count the values in a colum let's say, row 5, colums b5 to b15 in those coloms are numbers, 0 and ...

10 replies Last reply on 7 Feb 2011 by

Macro to class interval


Hello, I have a workbook of employee data and at dth column i have ages of employee. in eth column i have to define age interval like. 18-25...

1 reply Last reply on 7 Feb 2011 by

How two count values matching other values


Hello, I'm been trying to figure this one out. Anybody can help? Thank you! Each student recorded both current weight and desired weight. For s...

2 replies Last reply on 6 Feb 2011 by

Excel less than but greater than


Hello, How would I get into L2 if J2=>10 then "lates", if J2=

2 replies Last reply on 3 Feb 2011 by

Vlookup sample problem


Hello, I'm trying to learn vlookup and I made this sample problem and I'm not sure how I could get the formula done correctly to get the value I n...

4 replies Last reply on 30 Jan 2011 by

Forgot admin system password/no cd drive


Hello, i have sony vaio PCG-R505TFP (with no CD -drive),how i can log-in to my system?? please help. all the solutions available on internet inc...

1 reply Last reply on 27 Jan 2011 by

How to add iferror to formula


Dear all i have an excel database which search for a word in a cell and if it finds it, it puts it in another cell. The problem is the sell contain...

5 replies Last reply on 26 Jan 2011 by

Excel if function


Hello, Could someone please help me with the following problem. I want to know how to do a if function in vba to search for a value (output), a...

4 replies Last reply on 20 Jan 2011 by

Lookup name & return column value


Hello, I am looking for assitance with a formula and all help would really be appreciated. I have 2 sheets sheet 1&2,on Sht1 is cells J2 & K2 w...

2 replies Last reply on 20 Jan 2011 by

Copy between workbooks from a third workbook.


Hello, I would like to make an excel macro that will sit in a stand alone workbook (Workbook1). This macro would select a single user-defined works...

1 reply Last reply on 19 Jan 2011 by

Formulas in conditional formatting


Hello, In Excel 2010, I'm trying to color entire rows in a spreadsheet based on values in a certain column. I have been able to do this for numbe...

4 replies Last reply on 17 Jan 2011 by

Dsi flash player


Hello, how do you download a flash player to a dsi to watch videos and watch and play other things plzConfiguration: Opera 9.50

4 replies Last reply on 15 Jan 2011 by

Ms excel


Hello, I want to use ms excel but i am not getting any option of ms excel in my computer how can i use ms excel when i don't have it.......? ...

1 reply Last reply on 10 Jan 2011 by



Hello, Please help! I have 4 columns A,B,C & D(sheet2)Col A got names and B a value for the name in A,Col C names and D values for the names in C. ...

2 replies Last reply on 9 Jan 2011 by

Lost password for user & admin


Hello, I'm trying to fix my brothers PC. The problem I'm having is he's running windows xp home edition SP3. The problem is he made a user a...

4 replies Last reply on 9 Jan 2011 by

Button to color sertain numbers (excel)


Hello, Im looking for a way to make a button color all numers equal to the the number on the button.. as an eksample, lets say i have a row of...

2 replies Last reply on 7 Jan 2011 by

Import excel data into mysql database


Hello, This is Nischala .Can any one suggest me wheather we can import excel sheet data into mysql database using .net application( or asp....

4 replies Last reply on 5 Jan 2011 by
Er.mayank khandelwal

If-then statement to copy rows


Hello, I am wondering if there is a way to copy a specific row from one worksheet to another in the same workbook based on an IF-Then statement. ...

5 replies Last reply on 4 Jan 2011 by

Excel macro assistance


Hello, I have a macro running a process of performing a couple of formulas in a workbook that uses VLookup. Every week I have to re-edit the r...

8 replies Last reply on 2 Jan 2011 by

Converting date in vba excel


Hello, I have a spreadsheet that has: Column A: Year Column B: Month Column C: Day Is there a way to convert these 3 columns into the actu...

4 replies Last reply on 28 Dec 2011 by

Ms excel 2007 if function problems.?


Hello, I need immediate assistance. basically i am trying to use the IF function to display less than 18 "no", more than 18 "yes". but if 23.5/...

3 replies Last reply on 23 Dec 2010 by

How to remove password in 3230


Hello, how to remove the password in 3230? if u no any software means plz sent me d link to dis email ID , thanks. E-Mail ID is removed f...

1 reply Last reply on 21 Dec 2010 by

Excel macro copy data to next sheet using <


Hello, I'm looking some time now around this forum and ditn't find what i'm looking for. So i'm just gonna ask it here and hopefully someof your s...

1 reply Last reply on 21 Dec 2010 by

Macro to fill down in a range


Hello, Thanks to all who provide help on this site. I'm new to writing macros so hopefully you might be able to steer me in the right direction wi...

2 replies Last reply on 21 Dec 2010 by

Forgot my laptobp bios password


Hello, i am having compaq laptop and i just add bios password and now i forgot what i type is there anyway to break it ? Any help will be greatly ap...

3 replies Last reply on 21 Dec 2010 by

Excel copy and paste


Hello, I have been given a list of 200 codes but they are in the wrong order. for example it goes 12378945610. so i want to swap the 456 and the 789...

5 replies Last reply on 15 Dec 2010 by

Excel - check rows for data, copy to new


Heya folks! I've been reading the answers to similar questions and I plan to try and patch something together, but I thought I'd put a (more) specifi...

4 replies Last reply on 15 Dec 2010 by

Unlock password of kingston msd card 1 gb...


Hello, my 1 GB MSD CARD is locked due to password error, means I have forgot password. plz help me how to unlock it? Is it possible to unlock with...

3 replies Last reply on 15 Dec 2010 by

Lookup or find in excel help


Hello, I have 2 data sheets sheet one contains my Master list of items by number Row 1 Column 1: 453658 Row 2 Column 1: 839565 Etc my secon...

2 replies Last reply on 14 Dec 2010 by

Ms excel, stripping out char(10) data


Hello, I working in Excel with VBA and have 5 or 6 rows of data located within 1 cell. The user has decided to use Alt-Enter whilst entering the da...

8 replies Last reply on 13 Dec 2010 by

Security password


Hello, i have forgotten my previous security code,nd when iam trying to change it ,it neede my previous security code....plzz help me Configura...

1 reply Last reply on 13 Dec 2010 by

If advance function


Hello, Ok here is the situation Data is 9:00 am 4:30 pm Now i want the If Formula to function , that if the range between 9:00 am to 4:3...

14 replies Last reply on 12 Dec 2010 by

Can ping but can't use browser in normal mode


Hello, I also have the problem where I was unable to connect to the internet via any browser, but I can ping my router. I noticed that turning off...

1 reply Last reply on 9 Dec 2010 by
Brain Drained ;-)

Excel work sheet how to i open


Hello, When i am trying to open an exel sheet saved from windows 7 platforms, i am unable to open in windows xp plantform. the file that i was co...

2 replies Last reply on 9 Dec 2010 by

Copy rows n times and then fill a series


Hello, This is variation of a question that has been answered previously. Does anybody know how I can repeat rows in a spreadsheet by n number of...

2 replies Last reply on 8 Dec 2010 by

Dell inspiron mini password removal


Hello, i need help trying to unlock my dell inspiron mini. I get passed the hdd password by inserting all 0's. then it brings me to my account th...

1 reply Last reply on 7 Dec 2010 by

Automate an email address from a name


Hello, I have a list of names, (first and sirname) in Cell A1. In cell A2 i would like excel to populate the email address by getting the name in ...

2 replies Last reply on 6 Dec 2010 by

Forgot password


Hello, my handset is samsung sGH-M200, for the security i give the password but now i forgot it so please help me, what can i do to remove the pas...

1 reply Last reply on 4 Dec 2010 by

Mobile password


Hello, i forget my 3110c security password how can i restore my mobile..rply please and thanks for any help. Configuration: Windows 7 / Firefo...

1 reply Last reply on 2 Dec 2010 by

Dell password


Hello, please ,we still need the password for DELL XPS M 1330. service tag: # 4qkl94j-595B Configuration: Windows XP / Internet Explorer...

1 reply Last reply on 1 Dec 2010 by

Pie chart in excel


hi there im trying to make a pie chart in excel but i don't really know where to start...can someone help me thanx!

4 replies Last reply on 1 Dec 2010 by

How to interchange the columns in notepad


Hello, I have data in three columns. I want to inter change the values of first two columns without changing the third one in notepad or in word p...

2 replies Last reply on 1 Dec 2010 by

I forget my mobile password


Hello, i'm using micromaxx q5(fb). i forget my mobile pls tel me how to recitfy that Configuration: / Opera 9.80

1 reply Last reply on 30 Nov 2010 by

Excel sum greater than but less than


Hello, I am trying to get a cell to show the answer if - The date in B5 minus the date in B10 is less than 60 but more than 30 then F10 should sh...

4 replies Last reply on 29 Nov 2010 by

My word file documents given adobe properties


Hello, I have downloaded A new adobe reader and I found that all my word document files have appeared in my desktop as having PDF properties. I hav...

2 replies Last reply on 29 Nov 2010 by

Unlock password


Hello, i 4 got the password of mobile security of my mobile nokia n 73, so please tell how to unlock Configuration: Windows XP / Internet Explo...

1 reply Last reply on 28 Nov 2010 by

Comditional formatting relative recording vba


Hello, I want to compare a cell to its adjacent cell on the left. If the value of the selected cell is higher I'd like to colour it green, if it's...

4 replies Last reply on 26 Nov 2010 by
Results 1801 - 1850 out of a total of 2,608