The discussions
Range change colour
SolvedPlease help. If I have a range of Data in cells say A1 to E1 and I wish to change all to red when I enter the word "lose" in A1 only what do I need...
Bringing in 1 row - in excel
A B C 1 ND=5127558 NE =007-09-092 00426638 2 TY= KLA+ SR3 3 CAT= CAC17 1 ND=3...
Extract date from a series of numbers
SolvedHi, I need to extract date from a series of numbers like 250420102356478 where 25(date)04(month)2010(year)2056478(sequence number) and answer sh...
Pls help me with excel formula!
SolvedDear excel experts, I have a dataset of A1:A15. I want to make a formula stating that if 10 cells of the range A1:A15 are greater than or equal 2 ...
Recovering downloaded excel
I downloaded an excel document to my pc laptop from my school website(schoolloop) and made changes to it and then deleted it from the site folder(My L...
Reference number in excel
Hello! I have two sheets in a workbook, Sheet1 is for summary with reference number (reference number is alpha-numeric), Sheet2 is the raw data. Is t...
How to display add'l rows based on dropdown
Hi, I am trying to create a template with a series of questions with responses of Yes or No. A Yes answer would require further information. If th...
Locked cell and setting set focus in excel
Hello Guys, How can I locked certain cell/s in excel? I've tried the "Protect Sheet" but all cells in my worksheet were locked. Also, I want to defin...
Forgotten user password
hello i have a compaq evo n600c with vista buisness i dont have a recovery disk or a system disk its been over a year sence i last used my laptop. my...
Count number of days between two date entries
NEEd help Configuration: Windows Vista / Internet Explorer 8.0
Matching multiple columns & highlight matches
Hello, I need to match related columns A and B to comparison columns D and E. A and D are assigned codes and will be compiled of random letter, numb...
Rearranging data to another sheet in excell
The excell in which i am having consists of lot of data. I need to get few particular calues out of it to another sheet. Ex.) Male ...
Excel formula
in a separate cell, i have a number. If that number is greater than 11, i want a certain entry. if that cell is >6
Finding the last row dynamically
SolvedHi, I am using VBA in Excel 2007. I have a worksheet which has multiple columns. Each column has different number of rows. I want to find the la...
Username and password not working
i can not get my username or password to work for microsoft mail or thunderbird. it is a yahoo account but i even download gmail and it has the same ...
Password forgot
Hello, i forgot my memory card password .i am using motorola a810 .how to recover the password
Please help. vlookup thing..not sure
Please help! I have a schedule@ which looks like this. In sheet1 A2:A13 has names of workers. B2:B30 has dates in serial wise. B3:S13 has the shift ti...
Ms office 2007 & 2003
Currently i have installed MS 2007 installed in my laptop of which the size it comsumes in RAM is around 600 MB. I want to know the size of MS 2003 so...
Password problems
Configuration: Windows Vista / Internet Explorer 8.0my password wont work and make another wont ive tryed every thing help thank you my email is manue...
Excel (searching, finding and returning)
Hi I have not yet learned how to write working excel formulas very well, and I was looking for a short bit of help... I would like an arbitrary...
Ip address and password
Hello, i was wondering if ur able to find out the Users IP address and/or Password of x-kristacarvalho-x@hotmail.com thanks.
Excell value error
Would you be so kind as to evaluate the formula and see what I did wrong. It returns a VALUE error. I tried the evaluator, but im not clear where th...
Date formatting problem
SolvedI have a date in a cell that is 23/10/2008, and shows up as this in the editing bar, but in the cell address it shows a figure, ie 39744. Why is this ...
Please help. vlookup thing..not sure
Please help! I have a schedule@ which looks like this. In sheet1 A2:A13 has names of workers. B2:B30 has dates in serial wise. B3:S13 has the shift ti...
Vlookup formula
SolvedHi, Could you please anyone help me in this? (column headings : Roll No. , correction date , Type , code , rank , Marks , exam date , time ,...
Combining data from 2 worksheets
I have 2 worksheets that I am working with. They have very similiar information, but what I would like to do is combine them. The common factor is t...
Excel-macro to auto populate value in cell
Hi, I am new to Macros.I would really appreciate if someone can help me with the following problem. I have created a validation in Column c a...
Copy & paste filtered columns
Hello, Since changinging to windows 07 I can't work out how I can copy & paste in a filtered column without losing the formating of individual cell...
Lost my hot mail pass word
lost my hot mail pass word please help me? Configuration: Windows 7 / Internet Explorer 8.0
Excel multiple functions in one cell
Thanks for the help on the formula. I have one more for you. I would like one cell to look at four different arguments and return the result. Wha...
Execute macro on calculated cell change
Have tried several approaches, but nothing works Have a cell that has a formula and changes based on other cells - want to execute a macro when ev...
Print macro for a cell list
can you help to create a print macro for excel that will print the sheet continually after updating each time from a cell on a different sheet Config...
How i can choose some number from the excel
dear all, I am working on excel, situation : I have write different item names in one coloumn say coloumn a, and all the disciption of these items ...
Highlight a cell greater than the one above
SolvedHello, I am trying to use conditional formatting to highlight cells in a column (formatted as a table) that are greater than the number in the cell...
Xcel formula needed to return multiplication
SolvedI need a formula that does the following: if b10 is => than 10.03 AND c10 is => than 6.69, then multiply b10 times 328 It seems simple, but I ...
Incentive calculation with few condition
SolvedHi, I need help... each month I need to calculate the incentive. manual calculation is wasting my time. i know excel can do it, but I am not ...
Title...forgot my password
HI THIS RAJA MY MOBILE NOKIA 5130 IS OCCURED A SOFTWARE PROBLEM SUDDENLY I SOLVED THE PROBLEM IN NOKIA SERVICE CENTRE WHEN I PUT INSIDE MY MEMORY ...
Multiple sheet formatting based on cell info
I have multiple spreadsheets. I want to creat a formula/format so that when I color a particular cell on the first sheet, any cells on subsequent she...
Password samsung f 480
i can't remember my pass 4 my samsung f 480. Pls help me
Macro to select & email
HI, I have been trying hard to read all the posts here and find a solution to my problem but am not able to do so.. I have attached an excel ...
Browser and address bar
When I click on my internet explorer on my desk top and go to my home page theres no address bar at the top of my page there to put anything in like t...
Product key
Solved/ClosedHello, I've trying to enter the product key so many times as behind my laptop. my lap is very new. i can't work with any software without this produc...
Out look setings
outlook setings for rediffmail account
Word file dont open with any script
Configuration: Windows XP / Opera 9.64 my word documents are all corrupted by virus.now i ve cleaned all virus but the files are still corrupted.wh...
Ms excel 2007 version
Hi, does anyone know where I can find "Tools" in using 2007 version of spreadsheet? Thanks very much^^
Word 2007
how 2 give page nos 2 some selectd pages?????
Need help! unretrievable documents
Help! I am a full time online student and save all of my discussions, projects etc. in a seperate folder for each class. For some reason I recently tr...
Compare columns macro
Hello, What I am trying to do is come up with a macro to compare 2 columns of data in sheet 1, columns A & B. One is a master list, and another is ...
How to cinvert number to text
Dar friends, kindly halp me by providing the formulla to convert number to text such as Rs.2,16,57,868.56 to (Rupees: Two Crore Sixteen Lakh Fifty...
Yahoo id & password
Hello, please email me my password