The discussions
Vlookup help
Hello, I am trying to figure out how to use the VLOOKUP for table array in a spreadsheet. Here is my data EU ...
Unprotecting a sheet
Hello, Is there anyway to unprotect a spreadsheet without knowing the password ? Configuration: Windows XP / Internet Explorer 6.0
Problem formatting date
SolvedHello, I'm trying to use "date" to format cells in Excel 2003. I've selected number>date>mm/dd/yy. So, for example I enter today's date as 05201...
Sort by columns
Hello, I have been trying to create a macro to sort some arrival hours, I have 9 columns, the data I want to sort is on columns D, H and L, do you...
Smtp problem with outlook reading gmail
Hello, My Outlook 2003 Inbox Reads In From Gmail But Always Shows My Gmail Email Address As The Sender. I Have To Open The Email To See Who Really...
Match columns and bring back a third column
Hi excel gurus, I have a problem and I need some help to match information in two spreadsheets, I need to match the first two colomns in sheet1 ...
How to show the date automatic
Hello, how could show the date on the cell automatically ? Configuration: Windows XP / Firefox 3.0.5
How to change my standby mode to shutdown mod
Hello, I am using Vista Business. When i close my notebook it goes to Standby mode. I want to change it into Shutdoown mode. What i have to do for t...
Contract dates due to expire within 3 months
SolvedHello, In Excel 2003, I have a list of all contracts with expiry dates. I need to add a colum entitled Due to run out in next 3 months. How do I ...
Criteria help in ms access
Hello, I need to know how to write some criteria in MS Access in order to search for the word "FLAT" in a set of data and group this data together...
Pivot table query
Hello, If I construct a pivot tables that looks as follows : Name Total Current 30 Days 60...
Excel vba macro to make sheets
Hello, I'm looking for a macro that makes a sheet in the Excel-workbook. I have a mastersheet with all the persons working in a company in a partic...
Pictures hide
Hello, i want to hide pictures in excel how it is possible? pls help me out Configuration: Windows XP / Internet Explorer 8.0
Need help getting my password
Hello, i forgot secret answer Configuration: Windows XP / Internet Explorer 8.0
Admin password help
I let my grandpa borrow my acer laptop about 3 months ago and when he returned it he had put a password on the admin account and forgot what it was, c...
Product code key for msoffice small business
Hello, I purchased Micorsoft Office Small Business Edition 2007 in Mayof this year and loaded it onto my laptop. I now would like to load it on ...
Need macro for following condition
Hello, I need help on the following condition. ID Type Time 1 A 2 1 B 3 2 C 1.25 2 D 2 3 E ...
Color change and continual total...excel!!!!
Hello, I am begging for help !!!! I will explain what I need and then hopefully you can help me. FIRST ISSUE: If Cell F9 = E9 do nothin...
Problem of sending photos from cellphone to c
Hello, Can you please e-mail the instruction on how to send my photos to the computer.I have the USB and CD for SAMSUNG touch screen.I am using a ...
Macro to send email from vlookup cell value
SolvedHello, I am trying to create a macro that will among other things send an email to each address in a cell. The only problem is that the cell with ...
Micro max q3 pdf reader software link
Hello, I have micro max Q3 mobile. i want PDF reader for this mobile. please send me the link of adobe reader for micro max q3. Configuration: ...
Multiple criteria
Hi, I am trying to perform this for several criteria and I only want to return the detail in a specific column of the source data sheet (say detai...
A formula for comparing values in two columns
Hello, I want to compare values in two colums excel, if the value is in both columns to return a 0, if not to remain as it is. kindly help ...
How do i change dates automatically in excel
Hello, Any clever person out there. I am a frustrated administrator. I need to forward plan with dates. Basically I enter a Date of Birth i...
Excel: selection of cells in column between 2
All, Selection of Cells in a column Between two Values I am preparing a Statistical Data Sheet, for this I need to select and copy data from one...
Urgent computer won't logg into password
my lab top won't let me type in the password to logg into my computer. it's just a black screen with the mouse showning Configuration: Windows Vista...
Email function in excel
Hello, I have created a spreadsheet containing Clients, invoice numbers, Due date for payment, Date reminder has to be sent to the clients and fol...
Adding of the int values based on condition
SolvedHello, I am trying to sort out a problem in excel file. I have some duplicate strings in column C and there are some integer values in column D. I...
Excel macro to name ranges
Hello, I have a spreadsheet which contains many DSUM criteria, and I would like to name each of the ranges so I can refer to them by name rather than ...
Addition of the int values based on condition
SolvedHello, I am trying to sort out a problem in excel file. I have some duplicate strings in column C and there are some integer values in column ...
Add up the values of duplicate cells
SolvedHello, I am trying to sort out a problem in excel file. I have some duplicate strings in column C and there are some integer values in ...
Need 2003 product key urgent
Hello, I need help on the 2003 25 product key code! I need it so badly! Configuration: Windows XP / Internet Explorer 8.0
Password lost
Hello, I AM USING NOKIA 3110 C MOBILE & I LOST PASSWORD OF MY 1GM SAN DIS MEMORY CARD..PLZ HELP Configuration: Windows XP / Safari 532.5
Forgotten password
Hello, i forgot both my password n secret answer emails farhanayasmin17@hotmail.co.uk can u help me plzz Configuration: Windows Vista / Intern...
Forgot e-mail password and sec. answer
Hello, I forgot my hotmail e-mail password and the secret answer for my e-mail march_fifteen@hotmail.com,, could u plz send it to me on purple_but...
Column match
SolvedHello, I have two columns in excel 2007. Both columns show menu items from another computer system. So, as an example different roles in our com...
Forget my e71pmobile password
Hello, any one help me .. i forget my password of e71 pmobile(china) i change it default password Configuration: Windows XP / Internet Explore...
Office(excel) 2007 shortcut keys
Hello, Sir this is vivek, can anyone provide me shortcut keys for excel 2007. wud b vry gr8fl thx...Vivek Configuration: Windows XP / Saf...
Getting values from other xls file
SolvedHello, I have 2 xls files (book1.xls and book2.xls). In book1.xls the first column (A1) has certain names in first 10 rows (say x1, x2, x3, x4, .....
How to subtract two dates
Hello, I want to subtract Dates in 1 column from Dates in other column eg: 25.05.2010 - 02.05.2010 = Answer has to be 23.05.2010 I want to ...
Micro sd memory card password is forget
Solved/ClosedHello, i use NOKIA 3110c mobile. MY micro SD memory card password is forget. how can it find give me any solution. my id is : ...
Micro sd 1gb password forget
SolvedHello, . now i am using nokia 6085 mobile .. i forget my possword in micro sd 1 GB memory card.. plz tell me the solution what are the steps to fo...
Motorola droid i need my password back!
Hello, I have a motorola droid and when you set it up you have to create a google mail account but i have forgotten my password and answer to my s...
Excel - macro copy date for "n" month
SolvedHello, Would you please help me to create a macro for generate Date schedule to Sheet2 It just like an installment schedule. Sheet1 Col ...
.url to xls format
Hello, some of my files were xls files were deleted automatically, i am using ms excel 2007. i tried to recover them but was unsuccessful and can...
Looking up a dollar amount between two column
Hello, I want a cell to look up a value in a table that has three rows of data. A1 A2 A3 0 10 10.00 11 20 11.00 21 30 12.0...
Lookup last name in a range
SolvedHello, = LOOKUP(1E+30,Sheet3!E118:E141) I jused this formula to look up the last date of a range, but now want to change it to names but it won...
Ibm password
Hello, have a ibm think centre 8172. turn it on,my icon comes up but i dont remember the password. i cant even get to the desktop on it. any ideas...
Kindly help me on macros
Hi All, Kindly provide me a Macro for find and replace for an X no of dots in to a single / Example: manoj..............Kumar Rajesh..........
Counting values in multiple combobox's
SolvedHello, I'm looking for some assistance with excel VBA, it would be great to gain your assistance. I've created a UserForm with 4 x ComboBox's, ...