The discussions
Serial number
Hello, i want to use formula for adding serial number which contains text also, for example MAH10001 MAH10002 I Want in next row it will be M...
My password of the folders lock don't work
Hello, i'm having trouble with my new folders lock 6 .3.0 because when i make a new locker and set a password and try to open it it just don't open ....
Simple macro error help
SolvedHello, I am using Excel 2007 on Windows XP I am trying to write my first macro that will simply place the following formula into a cell. The ...
Deleteing rows in excel
SolvedHello, I work with a lot of files every day and the number of data in column A is different from the rest of the column. The number of data ar...
Display yes where data is present in excel
Hello, In excel, how can I get column W to show "Yes" in red, if there is data is column L. Please share... :) Thanks in advance
Password recovery
Hello, sir,now i'm using nokia 3110c.I protected the sd memory card with password,but i forget the password please help to open my memorycard C...
Cant sync my ipod without loosing all my apps
Hello, I bought a second hand ipod touch recently from ebay. when i plug it in to my itunes it will only let it sync with my computer which means i ...
Match 2 columns of data and delete duplicates
Hello, I have 2 worksheets with data that needs to be eliminated on sheet 1. Sheet 1 column M contains a random list of numbers Sheet 2 column A...
Conditional formatting based on month as text
Hi, I have a list of months in one column, and I want to format it so that if it is the current month, the cell is red; if the month is one month...
Copy selected table rows to different table
Hello, I am failing at copying selected rows from sheet1's "ActiveItems" table to sheet2's "HistoryItems" table. The copy works fine if "HistoryI...
Merge 400 cells of data into one.
Hello, I need to know how to combine the data in a column into a single cell, with the results being separated by a semi-colon and a space after t...
Excel comparison of partial or wild card data
SolvedHello, I have two columns in Excel that I want to compare. The data in work sheet 1, column A has values that are tabbed. This data has the adjac...
Compare cels column a to column b and count
Hello, What i want to do is this ... i want to count how many times the value in column b is greater than the value in column a in a ran...
Karbonn k10 password
SolvedHello, can anyone tell me the master password of karbonn k10 handset Configuration: Windows XP / Internet Explorer 6.0
I have forgot my password of my phoon
SolvedHello, Configuration: Windows XP / Firefox 4.0I HAVE FORGET MY PASSWORD OF SAMSUNG GT S-3310I PLZ HELP
How to copy formula as absolute
Hello, When I copy a formula to another location, Excel automatically adjusts the cell references in that formula to the new location. Is there...
Sheet-1 + sheet-2
SolvedHello, i have a problem plz solve it and tell me solution i want to count some cells which are Sheet-1 and in Sheet-2. Example: (Sheet-1) A1+A...
Forgot the password for my samsung c3510
Solved/ClosedHello, i forgot the password for my c3510 and whenever I tryed to go to my fotos,meseges and stuff like the I had to put the password but when I...
Repeating macros
Hello, Does anyone know how to repeat a macros? I have recorded the following command as a macro in Excel (2007), but I would like the task...
Counting in excel
SolvedHello, In the U column shows "Good" and "Bad" answer that resulted from a formual that I used. How can I count the the toal number of Good a...
Password help on sony viao e series laptop
Hello, I forgot the passwrd of my newly bought sony laptop. :( I tried logging in safe mode but it still asks me for the passwrd. please help? ...
Excel help with what if
SolvedHello, I have all the states in column A and I need to result to display in column B. I need Column B to show "Yes" if column A has: MT, ID, ...
Conditional formatting (more than 3) in excel
Solved/ClosedHello, i am trying to apply more than three options to excel that changes the background colour of the cell. my range is R7:R1000 i need a VBA ...
Delete the first 4 charcters then keeping the
SolvedHello, In excel macro, how can I delete the first 2 characters and THEN keeping the first 5 characters and THEN deleting the rest. The data i...
How to filter out certain state
SolvedHello, I want to be able to filter out certain states in column B. Column A contain all the states and I want the state: CA, NV, TX, MO, MS, ...
One cell calculation
SolvedHello, Need a programme that calculates sum every time I put in one cell a number. For example, in cell A1 to put the number : 1, 1200, 0.50 and in c...
Password softward failed to run
Hello, When i boot up my computer and enter my pasword to log on I am receiving a message that my password profile software failed to run. I am ...
Removing password.
Hello my name is faisal, i forget my memory card password, i have nokia 7230 mobile, please help me and remove my password. Thankyou.
Date format
Hello, My excel sheet used to earlier show all dates as d/m/yyyy format by default . Sometime back I installed a software of a video camera after ...
Run a macro in multiple selected columns
Hello, i have a macro to fill in blanks. Is it possible to run it for multiple columns at the the same time. Thanks Configuration: Windows X...
Checking cells for data, then ....
Hello, hi i'm having a bit of trouble with something in vba and have tried searching but its complicated and i cant seem to find anything on it. ...
For plus or minus
Hello, sir i want one formula for my office work. i have several densities for several products.the density is within the spec plus or minus 0...
Excel macro help
Hello, I need to Open an .txt file & then copy the contents of .txt file into word Macro and run it. I need to do this for many .txt file C...
Locking of micromax q1 by password protection
SolvedHello, with due respect i would bring in your kind attention that I have purchased a Micromax Q1. As I dont have any idea how to lock it by passwo...
Appling a formula to the active row
Hello, I am working on creating a excel vba macro that will be used to perform serveral steps, but I am stuck at trying to add a formula to perfor...
Send file direct on email with attachment
Hello, I have created a survey in excel 2003. I want an email address to hyperlink to an email with the persons email address and attaching the ...
Percentage
SolvedHello, Please help!I'm looking at a formula that i have :=IF(OR(I32=0,I33=0,I34=0,I37=0),0,(I34+I33+I32)/(I37+I34+I33+I32)*100) The formula works...
Need help with macro 2007
Hello, College_Cost() Dim Tuition As Currency Dim Room_and_Board As Currency Dim Miscellaneous_Expenses As Currency Tuition = InputBox("EnterT...
Highlight if there is a difference
Hello, I am trying to highlight every row that has a difference. I need a macro that will perform this task. I am looking at col E. Some lines of ...
Extracting excel data into new file
Hello, I have an Excel like below. Project Code, Site, Donor and Partner are the heading. Project Code Site Donor Partner E...
Help please on select-case auto add new info
Hello, Could you please help me? I have very little-too no knowledge with excels macros, and I have no clue how to solve the next issue: I have this...
Sum color cell that met given criteria
Hello, can someone help me please, I need to count the cell with color that meet the given criteria...i.e. I have two sheet-one for stages of shop...
Saving a file with formulas displayed
Hello, I would like to save an Excel 2010 file with the formulas displayed and be able to open it with the formulas still displayed after it has be...
Can vlookup return more than one value
Hello, I am wondering if anyone can help me find a way to modify a vlookup to return more than one value? I currently have two spreadsheets with o...
Forgot security code and mmc password
SolvedHello, hi i am chandan nama from jaipur rajasthan i have forget my security code and mmc password for nokia 6233 can i un lock then please salve ...
Old vs. new cell value comparison - possible?
Hello, I need to track value changes in a cell as follows. I have sheet 1 - current data and sheet 2 - copy of sheet 1 from yesterday. I'd like ...
Microsoft word trouble-please help!
SolvedHello, I have to edit a letter for school that must be turned in tomorrow. The school uses Microsoft Office 2003 I think, it might be 2007. My lapto...
Excel matching formula
Hello, i am not an expert excel user and i figured what im trying to do is pretty basic. I have data in 2 columns and the result column. I wanted ...
How to install pdf reader in micromax q5fb mobile phone
SolvedHello, Please tell me the steps on how to install pdf reader in my micromax q5fb mobile and how to store file in ebook and how to make use of it? ...
Config outlook 2010 and connct to yahoo
Hello, I wanna config. my Outlook 2010 First question is : "Server" Where can I find the answer please. Configuration: Windows XP / I...