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 ...

1 reply Last reply on 21 May 2010 by
rizvisa1

Unprotecting a sheet

Hello, Is there anyway to unprotect a spreadsheet without knowing the password ? Configuration: Windows XP / Internet Explorer 6.0

2 replies Last reply on 20 May 2010 by
rizvisa1

Problem formatting date

 Solved

Hello, 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...

6 replies Last reply on 20 May 2010 by
dp

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...

7 replies Last reply on 20 May 2010 by
rizvisa1

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...

1 reply Last reply on 20 May 2010 by
Mirran

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 ...

5 replies Last reply on 20 May 2010 by
rizvisa1

How to show the date automatic

Hello, how could show the date on the cell automatically ? Configuration: Windows XP / Firefox 3.0.5

2 replies Last reply on 20 May 2010 by
StormDronk

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...

1 reply Last reply on 20 May 2010 by
rizvisa1

Contract dates due to expire within 3 months

 Solved

Hello, 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 ...

9 replies Last reply on 20 May 2010 by
rizvisa1

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...

2 replies Last reply on 20 May 2010 by
PM

Pivot table query

Hello, If I construct a pivot tables that looks as follows : Name Total Current 30 Days 60...

1 reply Last reply on 20 May 2010 by
rizvisa1

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...

1 reply Last reply on 20 May 2010 by
rizvisa1

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

1 reply Last reply on 20 May 2010 by
dist.urbd

Need help getting my password

Hello, i forgot secret answer Configuration: Windows XP / Internet Explorer 8.0

1 reply Last reply on 20 May 2010 by
ash_perez01

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...

1 reply Last reply on 20 May 2010 by
anjana03

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 ...

1 reply Last reply on 19 May 2010 by
bean

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 ...

1 reply Last reply on 19 May 2010 by
rizvisa1

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...

3 replies Last reply on 19 May 2010 by
rizvisa1

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 ...

1 reply Last reply on 19 May 2010 by
suff954

Macro to send email from vlookup cell value

 Solved

Hello, 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 ...

5 replies Last reply on 19 May 2010 by
rizvisa1

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: ...

1 reply Last reply on 19 May 2010 by
suff954

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...

14 replies Last reply on 19 May 2010 by
rizvisa1

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 ...

1 reply Last reply on 19 May 2010 by
rizvisa1

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...

1 reply Last reply on 19 May 2010 by
rizvisa1

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...

3 replies Last reply on 19 May 2010 by
rizvisa1

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...

1 reply Last reply on 19 May 2010 by
suff954

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...

1 reply Last reply on 19 May 2010 by
rizvisa1

Adding of the int values based on condition

 Solved

Hello, 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...

4 replies Last reply on 19 May 2010 by
Sumit

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 ...

1 reply Last reply on 19 May 2010 by
rizvisa1

Addition of the int values based on condition

 Solved

Hello, 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 ...

1 reply Last reply on 19 May 2010 by
rizvisa1

Add up the values of duplicate cells

 Solved

Hello, 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 ...

2 replies Last reply on 19 May 2010 by
rizvisa1

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

1 reply Last reply on 19 May 2010 by
dist.urbd

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

1 reply Last reply on 19 May 2010 by
dist.urbd

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...

1 reply Last reply on 19 May 2010 by
dist.urbd

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...

2 replies Last reply on 19 May 2010 by
Soft Touch

Column match

 Solved

Hello, 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...

9 replies Last reply on 18 May 2010 by
Ross

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...

1 reply Last reply on 18 May 2010 by
suff954

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...

1 reply Last reply on 18 May 2010 by
rizvisa1

Getting values from other xls file

 Solved

Hello, 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, .....

1 reply Last reply on 18 May 2010 by
venkat1926

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 ...

2 replies Last reply on 18 May 2010 by
love2garv

Micro sd memory card password is forget

 Solved/Closed

Hello, i use NOKIA 3110c mobile. MY micro SD memory card password is forget. how can it find give me any solution. my id is : ...

2 replies Last reply on 18 May 2010 by
madhu

Micro sd 1gb password forget

 Solved

Hello, . 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...

1 reply Last reply on 18 May 2010 by
ash_perez01

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...

1 reply Last reply on 18 May 2010 by
dist.urbd

Excel - macro copy date for "n" month

 Solved

Hello, Would you please help me to create a macro for generate Date schedule to Sheet2 It just like an installment schedule. Sheet1 Col ...

3 replies Last reply on 18 May 2010 by
rizvisa1

.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...

2 replies Last reply on 18 May 2010 by
Prittam

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...

1 reply Last reply on 17 May 2010 by
rizvisa1

Lookup last name in a range

 Solved

Hello, = 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...

10 replies Last reply on 17 May 2010 by
rizvisa1

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...

1 reply Last reply on 17 May 2010 by
suff954

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..........

1 reply Last reply on 17 May 2010 by
rizvisa1

Counting values in multiple combobox's

 Solved

Hello, 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, ...

1 reply Last reply on 17 May 2010 by
rizvisa1
Results 8501 - 8550 out of a total of 12,249