The discussions
How to populate a 'form' with data
Hello, I have a sheet that contains Names, email addresses and other info captured from an online entry form. At the same time I have a scorecard ...
Counting
SolvedHello, I am trying to count the number of cell's from I4:I304 that have "no access" in it, but in those cells not only do some of them have "no acces...
Ytd percentage
Hello, I am doing a fiscal year productivity report that I submit monthly. I currently have a column w/YTD numbers for work hours and the director ...
Filtering only certain columns
Hello, I have to tables side by side in excel and I have autofilters at the top of each table(headers). When I filter by column in one table. It hi...
Excel macro loop to insert pics into more cel
SolvedHello, Could someone please help me in writing a loop in this macro in excel : I have an excel sheet where it contains the name of the pictures in c...
Excel help combining info from2 sheets
SolvedHello, Hello, How can I match and combine records across two excel sheets. I have two excel sheets containing record information, about 6 columns f...
Auto e-mail from excel if a cell value is yes
Hello, I have a problem and need solution for it., I have a excel worksheet with the data as given below... Name Student no. Marks Send E-mail...
Excel if function
Hello, Basically i've set up some conditionally formatted cells and i want an extra cell warning me of how many false cells i have. i want a cell ...
Bios password
Hello, I forget by BIOS password.... How can i change the password again .... If anybody knows pls Reply soon... its very very urgent.....
How to change months only in dates
Hello, I have a spreadsheet that has dates sprinkled throughout the sheet. Unfortunately I have the wrong month and need to change June 10 etc int...
Excel formatting
Hey All, I have a column of data in excel for example as below; ABC DEF GHI JKL MNO The list is faily exhaustive and I need to format the...
Word 2007 files opening with word 2003
Hello, My IT dept recently upgraded my Office suite from 2003 to 2007 (Word, Excel, PPT). However, they did not remove the 3003 programs. So, now,...
Excel 2007 question
Hello, I know it is possible to copy an Excel 07 sheet (#1) into another Excel 07 worksheet (#2) and keep the data in tact. What I want to know ...
[excel] color format
Hello, I'm trying to color fill a subset of a row (A1 - A10) if A10 is a certain value, False statement from a =istext. Any ideas?
[openoffice] how to convert numbers to words
Hello, can u please help me to convert the numbers to words in OPEN OFFICE. . . it will be highlly appreciated. . . regards Arsalan
Compare and delete data
Hello, Here is the scenario. I have 2 columns with names in excel. I need to compare both the rows and get the extra rows out. Column A Colum...
Microsoft word 2003
Hello,i need to install the microsoft word here in my laptop.and i need the free version. i can't find and it's difficult to search.
Rocord a variance using vlookup or cndtl.frmt
Hello, Im using Excel 2007 Please help me determine wether i use VLOOKUP or Conditional Formating to find a difference and list that in my spreadsh...
Please help me the vba
Hello, Excel sheet 1 have dump data and excel sheet 2 have feature name defined in second coulmn. I hv to define the array with some feature_nam...
Excel - storing entered data
Hello, I am a relative novice who knows what they want to achieve but is unsure how to get there. I work in a school and want all staff to compl...
How to generate different page numbers in a t
Hello, I am struggling to generate different page numbers in a text in word 2007 (e.g. i, ii,... for the first three pages and 1,2,... for the othe...
Splitting data in one column into rows
Hello, I have a situation where as all of the data from a survey was down loaded into one column. Each block of 10 rows represent one response. I nee...
Condition formating
Hello, I need to condition format cell, if the word in that cell is similar to the word in another cell which has many word. For example: If cel...
Forget password & secret question
SolvedHello, i have forget password & secret question .please help me.please reset my passwrd . kamal nautiyaljubl@yahoo.co.in
Forgot password of memorycard
SolvedHello, i forgot my password of my memorycard of nokia 3110c.. pl help me to change password.. thank u
Columns comparison
Hello, Please find the values in Column A,B,D,E Column A Column B Column D Column E AA 100 ...
Replace range of numeric values with text
Hello, I have an Excel report and I need to change all numercial values that are less than 5 to "NIL" and all those greater than 5 to "YES". Im ...
Password
Hello, i am installed the folder lock program its workin fine but password is forget pls help me
Slashes \in\ between \each \word
Hello, When \I \type, \slashes \come \up \between \each \word. \ \Also, \when \I \type \numbers, \letters \come after \each \number \typed. \ Thanks ...
Count numbers within text
Hello, How to count numbers within text Thanks!
Excel if function over a range of dates
SolvedHello, Can anyone help please? I am trying to add a divisions column, which are taken from a date range in another column. i.e. I would like to add "...
Lost password
Hello, i am forget my nokia 3110c memory card (sandisk micro sd 1gb card) password need help
Insert and order the column
SolvedHello, It has A, B, C, D, E Columns and less then 6500 rows as per given example. A and the B column are fixed. I want to reorder compare "C" co...
Matching data
Hello, Can anybody help me to simplify my work in matching debits and credits? For example in one column all I need are items that do not have a ma...
Excel help
Hi, I am looking for a macro that will cpoy and paste data if it mets certain contintions, Say i have two sheets of data in which sheet1 contains 3...
Excel formula to show zero
SolvedHello, I'm using the formula =A2/(A2+A3) in A4, same in B to AF, i need the A4 line to show a zeros when A2-AF2 and A3-AF3 do not have values in. ...
Background question
Hello, I would like my background to automatically change color in a cell when I type a number in the cell below it. I don't have a single clue, any...
Password
Hello, i need the password pls can you give me ?ty
Compairing two columns a&b
SolvedHello, column A column B 5000 4001 5001 4080 5002 4445 5003 4493 5004 4...
Network days
SolvedHello, I need some help if any one can assist, please... I have a date in a Excel S/S so i.e. 15/02/2010 and under this i have a number of days ...
Changing a value
Hello, I am trying to get excel to change the value in a cell eg if cell a1 b2 green else amber. Regards
I forget admin password & create a new admin
Hello, I forget my old password create a new admin With security .another Persons don't create a any password or new account & another persons...
Excel formula converting time difference
SolvedHello, i want to know the excel formula...below iam giving the details, In table A is my starting time e.g.10.49 and in table B is my reaching time...
Macro for copying info from worksheet 1 to 2
Hello, Could someone please help me!! I have a client list on Worksheet 2 and I need certain client info copied to Worksheet 1. I would like to mark ...
Excel file recovery
Hello, How Can I Repair My Excel File ? It Shows The Error "Excel found unreadable content in 'File Name.xlsx'. Do you want to recover the conte...
Conditonal formating of rows
Hello, I have a table in excel 2007, where column b has entries of names e.g. John, Devid, John, John, Gilbert, Devid etc. The same name may repeat ...
Deleting alternae rows
SolvedHello, I want to delete every alternate rows from my work sheet. I tried recording macro, but it only deletes a particular row as shown in macro bel...
Want to give a value to each cell
Hello, normally the value of each cell in excel is 0. but i want that the value of each cell will be 20.like whenever i ll add add 5 with any cell it...
Lost my password
Hello, i lost my password and secret answer.I am having long time this id .pls help to me. I am Shakila,my id
