The discussions
Formula needed for yes/no calculation
ClosedHi, I am trying to create a formula with an IF function in Excel, but I can't seem to figure it out. Here's the "business case": I am trying to ...
Word 2007 open publisher 1997?
Hello, I have a document created with Publisher 1997 but I need to open it on a computer that only has Word 2007.Please help, can this be done? Than...
Micro sd card password
Hello, i have my micro SD card..2GB...and it was locked...i dont know what was the pasword of it.......can you help me unlock my memory card????ah...
Multiple rows in multiple columns
Hello, I have a spreadsheet with two columns and 100+ rows. Data in column A, the category repeats, Data in column B is unique to what is in col...
Make multiple columns into a single column
Hello, I have data in excel sheet with 3600 columns and each column has 6 rows.Suppose say Column 'A'...It has 6 rows.I want the Column 'B' dat...
Sorting and extracting data...
SolvedHello, I need to extract the data from from the cells of Column "B" and placed it into cells of Columns "E" by comparing Column"A" and Column"D"....
Outlook express
ClosedHello, I have a new computer Windows 7. My old computer was Windows XP. How do I get my files from Outlook Express? I downloaded them to a flash dri...
Blank rows deletion
Hello, Dear friends, I really appreciate your support and help all the time. I have another problem and I need your help once again. I have ...
[ooo calc] spreadsheet: if / then ?
ClosedHello I would like to make a comparison calculation and tried to use an IF(), but I keep getting an error. I use Open Office Calc, here, but that...
Please help in excel data function making
Hello, Am Ravi Kiran, Vishakhapatnam, Andhra Pradesh, India, I have a doubt in Ms EXCEL 2007, my doubt is that am having a client who is a small...
Search and count?
Hello, Using Excel and trying to count and display results for Column A (let's say it has test grades A, B, C, or D for each person) but I need th...
Sd memory card password
Hello, hai my nokia sd memarecard is lock pls hellp me my memarecard unlock passward Configuration: / Opera 9.80
Filter not working
Hello, I have filtered a sheet on 2 columns which has around 50 columns and 900 rows. Now I am trying to remove the filter but it is not working. ...
Searching in 2nd sheet for values in first
Hello, I am looking for a macro to search data in col A of first sheet in col A of 2nd sheet and whereever there is a match copy the data in ColB ...
If function
SolvedHello, I am just starting out with formulas and I need some help. What I need is: If the value in Sheet 1 B2 is found anywhere in Sheet 2 colum...
Macro to compare two sheet and return a value
Hello, Can you please help me with a macro. What I am trying to get is a macro that will compare two names in two sheets (Sheet1, col AD and Sheet...
Macros 2 columns info into 1 same wksht.
Hello, I have two columns of information. One column is labeled description and lists a (numerical and text) description of and item. EX: 1/2" ...
Compare two cells and do another formula
ClosedHello, I need some help on this, i have three cells containing either the letter H, B or U. Next to these i will have another three cells with one...
Lost phone software need password to unlock
ClosedHello, I am using this samsung galaxy s2 and am using the lost phone software I am on travel overseas and once I changed the sim the phone has ...
To find, copy the corresponding value, paste
Hello, i want the macro code for finding a value using inputbox, copy its corresponding value(row) and paste them in the same sheet where the cell ...
Administrator password or power on password.
ClosedHello, i have got an HP Pavilion dv6. There was no administrator or bios password set. It was working fine yesterday. It would not start today as...
Cells display a total or text
SolvedHello, I have an excel workbook that has cells that display a currency amount U43, U45, U47, U49, U51 and Q53. For example U43 would have $200 in...
Outlook says it is sending my email
ClosedHello, I was cleaning up my folders in my yahoo and gmail accts and outlook says it forwarded my email to undisclosed recipients. I am not set up...
Outlook 2007 email randomly not sent
SolvedHello, the problem started a few days ago. Randomly Outlook 2007 does not send a message. Looks like it is mostly when I reply to another email. I...
Conditional format more then 3
SolvedHello, I have seen a solution on your web from aquarelle, but how do i put that in my excel, sorry maybe its a basic question. But i have tried i...
Excel table, lookup, match, index, array ??
Hello, Can anyone help, please? I have a table with manager names running down column A, and dates running along row 1. Inside the table fo...
Formula in exel 2007
Hello, Configuration: Windows XP / Opera 9.80WHAT FORMULA IN EXCEL 2007 NUMERIC FIGURE INTO CHANGE THE ALPHABETICAL FIGURE
[excel] formula for this problem
Hello, i'm so confused with excel formula. how to get data from other table and other sheet which comparing data in row and column.like shown in the...
Match data from multiple w/books & paste row
Hello, I have a main spreadsheet which contains order reference numbers (Column B), details of the order are filled out to the right on the same r...
Program manager
ClosedHello, I have a formula that it is working fine (Excel 2007) =IF(F2="",IF(G2="","MISSING BOTH","MISSING GCT"),IF(G2="","MISSING LOCAL","HAV...
Pop up msg in excel when condition is tru
Hello, I want to get a pop up message in excel when a condition is TRUE. I am bringing in live data and want to notified through pop up when the nu...
Need to match and fetch data to 1st sheet fro
Hello, I have two excel sheet having "Name" common in both sheet, 1st dosent have mobile number that I am trying to fetch from 1st sheet. the tota...
Excel:move a columm that contain <a to anothe
ClosedHello, I really don't know this things in excel but this is an assignment that i have. I had an text file with a data and some items have an ex...
Excel transfer selected rows
SolvedHello, I have in place a data validation,''list''. I want to be able to transfer selected rows with the different list names into separate worksh...
How to move data in excell?
Hello, I would like to separate data in one excell cell into two excell cells e.g. 241 GOLD CREEK RD, BROOKFIELD, QLD 4069 in one cell into 241 ...
Help me copy data
Hello all , kindly help me copy data from A1 in sheet1 into A1 in sheet 2 only if value of M1 in sheet 1 is say "ok". Configuration: Wind...
Excel auto fill
Hello, I am pulling informaton from a row into a column. I was wondering if there is a way to auto fill formulas in the column with the row numb...
Data validation macro modification for excel
Hello, I am having an issue with manipulating a macro that will allow me to choose a secondary data validation set based on the condition of a pri...
Copy cell into new sheet conditionaly
Hello, Looking to copy a row from one sheet to a new sheet if one cell equals 1 or more Let me know if I need to clarify Appreciate any help that so...
Remove password from memeorycard
Hello, i am having nokia c2-00 mobile,i forgot my password ,i can,t able to open my memory card I tried it in pc also .I kindly request you to...
Hp laptop wont come out of hibernate
ClosedHello, I have a hp laptop it will go into sleep mode or hibernate then it will not come out of that unless I manually power down the machine I have tr...
Wont let me type password
Hello, i just got my laptop back, when i turn it on a white screen comes up saying it needs password,administarters passwoed, but it wont let me ...
Forgot of memory card password
hello i forgot my transcend micro s d memory card password ,i want to use that ,so please help to unlock that .please give the suggestion as early a...
Email password
Hello, i forget my pasword and also securty question.plz tell me how i open my id. Configuration: Windows XP / Safari 535.2
Kingstone dti/4gb flash drive password prote
Respected members i shall be very thankful to all of you if anyone will help me i have kingstone DTI/4GB Flash Drive its password protected and ca...
How to use macro in my case
Hello, Would appreciate if anyone could help me in detail how to use macros in the below case: I have Expected closure date Column A1, and escala...
Excel data validation
SolvedHello, I have a master spreadsheet to collate data from spreadsheets filled in by my colleagues. Column b is 'Transaction Type' and I want to pro...
Good connection, browser won't display page
Hello, Running Windows 7 / Firefox 7.0.1 and suddenly internet stops working. First my router had some issue broadcasting the network - sorted...
Compare sheet and return last column
Hello, I have two sheets with the same column to compare as follows: Sheet 1 Column A: First name Column B: Surname Column C: Father's name ...
Merge data from 3 columns into one cell
ClosedHello, I am trying to make bin labels for my parts dpt. I have a file with 3 columns but it's 2051 rows long. I need the data from the 3 columns to ...
