The discussions

One cell calculation excel - time interval

 Solved

Hello, I need to calculate the elapsed time in hours if the start time and end time are contained in the same cell. Example: If A1 contain...

4 replies Last reply on 10 Jul 2010 by
yyzxyz

How install tally

 Solved

Hello, Sir, how install tally 7.2. plz send me ,

4 replies Last reply on 9 Jul 2010 by
tahir husain

Dell latitude c400 password -595b

 Solved

Hello, Lost my master password on Dell Latitude C400 laptop. Tried to unplug battery, but still need password. Any who can fix the password. ...

1 reply Last reply on 9 Jul 2010 by
Wandful

Excel : different criteria for excel to look

 Solved

Hello, Please could anyone help? Attached please find the example. https://authentification.site/files/23122635/nono.xls The sheet (Say in doc...

20 replies Last reply on 8 Jul 2010 by
carman

Excel macro

 Solved

Hi I am new to Excel macros, I need help with the following automation: I am trying to copy data from the main spreadsheet name "PMO Report" where...

8 replies Last reply on 8 Jul 2010 by
Moe

Micro sd password remove

 Solved

Hello, i use msd card in my nokia but i forgote it how gat it Configuration: Windows XP / Internet Explorer 8.0

1 reply Last reply on 8 Jul 2010 by
little.jay60

Ms excel 2007 macro/formula problem

 Solved

Hello, ##Please help! I am new to this and so fed up!! I need to transfer data from two worksheets onto another worksheet and I just cannot do it!!...

3 replies Last reply on 7 Jul 2010 by
cellbar

Excel macro help please

 Solved

Hello Everyone, I am sking for some help with an Excel macro please. I have a 1,900 hundred static HTML pages that I have converted to text for ...

45 replies Last reply on 7 Jul 2010 by
rizvisa1

Need to declare a cell as numeric in macro

 Solved

Hello, i need to declare a cell in excel as numeric so that only numbers can be entered in that cell and if any other text is entered then it di...

1 reply Last reply on 6 Jul 2010 by
rizvisa1

Excel vba

 Solved

Hello, currently i have 2 worksheets one which users would use to complete a template and the other to store the information in. i am trying to...

13 replies Last reply on 6 Jul 2010 by
rizvisa1

Break samsung 1080 password

 Solved

Hello, Configuration: Windows XP / Internet Explorer 7.0 m having samsung 1080 i want to break its password as i forgot the password for it.

1 reply Last reply on 6 Jul 2010 by
Ambucias

Using the pastespecial & xlpastevalues funct

 Solved

Hello, I'm working in Excel 2007, I'm trying to amend this vba script. I'm taking multiple worksheets, and combining them into one worksheet. It works...

2 replies Last reply on 6 Jul 2010 by
tee2tee

Switch from french to english version of word

 Solved

Hello, I wish to know how I can switch from my Microsoft Word 2002 french version to an English version: I need to buy a style guide software that wi...

2 replies Last reply on 5 Jul 2010 by
teresa

Show unique list in listbox

 Solved

Hello, Going trought some research I found some answers. Now my actual problem is how to sort the values in listbox1 by the ones showed in combobo...

14 replies Last reply on 5 Jul 2010 by
MOlie

Restore factory password fxd -3600 (sigmatel

 Solved

Hello, Good morning, I am Using FXD -3600 (Sigmatel). We Need to Restore My Mobile. But Mobile asking Input Password to Restore. Kindly Help m...

1 reply Last reply on 4 Jul 2010 by
Ambucias

Transfer values from lisbox to different shee

 Solved

Hello risviza1, It is my first time here, a friend of time told me you where an excel Guru I'm hoping you can help me. I'm facing different iss...

12 replies Last reply on 2 Jul 2010 by
MOlie

Find a town name within a string of text

 Solved

Hello, First time user so please be gentle :-) I need to find a town name with a whole string of adress info. I can use the search function ...

1 reply Last reply on 2 Jul 2010 by
rizvisa1

Excel 2007 time and date problem

 Solved

Hello, I have a sheet that has a date column and a time column (brought in from a csv file). My date column is showing in the format of MDDYYYY wi...

4 replies Last reply on 2 Jul 2010 by
David

Excel vba colour alternate rows

 Solved

Hello, I am creating a report, and I want to shade alternate cells in a light grey colour. I need all columns and rows, starting at A5, that conta...

6 replies Last reply on 2 Jul 2010 by
tora

Limiting the calculations in mailmerge

 Solved

Hello, I prepare some letters using excell and mailmerge. when mailmerge fetch calculations from excell, the calculatios appear on letter up to 13...

1 reply Last reply on 1 Jul 2010 by
rizvisa1

Recover deleted items

 Solved/Closed

Hello, my office server uses windows 2003 server with exchange server setup. one of the users accidentally deleted (shift+delete) some important em...

24 replies Last reply on 30 Jun 2010 by
anthonygeo3

Uneditable selected columns/rows/cells excel

 Solved

Hello, Kindly teach me how to keep the slected [Column or Rows or set of Cells] in Uneditable Mode in Excel, so that users can not change the info...

2 replies Last reply on 30 Jun 2010 by
AD

How to make date auto forward

 Solved

Hello, I'm trying to figure out how - after entering a date in a cell- to get the following dates to automatically fill in. For example: when ...

2 replies Last reply on 30 Jun 2010 by
rothi

How can i compare one excel sheet to other

 Solved

I have 1 main sheet of all the data which i send to my client, now he has slelcted some thing and sended it in new sheet. now i wanna highlight his se...

2 replies Last reply on 29 Jun 2010 by
dzigner

My pc dont see my printer

 Solved

Hello, y buy a new printer epson stylus sx 215 y have instal cd but in the end to finish instal my pc can comunicate whit printer y can scan but y ...

4 replies Last reply on 29 Jun 2010 by
rizvisa1

Excel unique data rows

 Solved

Hello, I need to compare two columns of data for uniqueness. Column a has a list of names and column b has a list of date/times. I need to be ab...

9 replies Last reply on 29 Jun 2010 by
quiz

Compare 2 coloumn with 2 column

 Solved

Hi friends, i want to check two columns with two columns if result is true then want next cell values. For Example A B ...

4 replies Last reply on 29 Jun 2010 by
Prabhu

My excel macro silently exploded... :(

 Solved

Hey, so I have a set of macro that were working, then dropped dead on the spot. before i paste the macros I'll give it some context So I have seve...

4 replies Last reply on 28 Jun 2010 by
rizvisa1

Copy row if column contains specified number

 Solved

Hello, I have three columns of information, column C contains the site name and number e.g. Priory Park 4742. I currently use Find to search for the...

6 replies Last reply on 28 Jun 2010 by
vince

Macro

 Solved

Hello, https://authentification.site/files/22774798/Copy_of_sample.xls please see the attached to see what i want done. Configuration: Win...

28 replies Last reply on 28 Jun 2010 by
Neo

Get value from the adjacent cell

 Solved

Hello, I have been working on excel worksheet where I need to get the cell value (in this case it is the date) from the adjacent column as well as...

8 replies Last reply on 28 Jun 2010 by
Ninz

Outlook configure

 Solved

Hello, i want to configure outlook express but i dont know server name please help me

3 replies Last reply on 28 Jun 2010 by
Ambucias

Vlookup error

 Solved

Hello, I am having this error when I use the vlookup function, here is what I have: Cell A Cell B EDI 2222 EDI 2222 EDI...

2 replies Last reply on 27 Jun 2010 by
Paula

At sum / less negative numbers

 Solved

Hello, Hi, I need to at sum a list of number but not the negative numbers. How do I write the formula? I’m 70 years old and kind of new at this but I...

2 replies Last reply on 27 Jun 2010 by
nilesh

How do i make a pdf smaller? zip?

 Solved/Closed

How Do I Make a PDF Smaller? Zip? I have a PDF document that I need to upload that is 3.75mb. The website will only allow me to upload files 3.0mb or...

42 replies Last reply on 27 Jun 2010 by
NH

Background color of cell in excel

 Solved

Hello, I am trying to write a simple formula that will give me the backgroud color of a cell (in Excel). Something along the lines of, if background ...

3 replies Last reply on 25 Jun 2010 by
Pankaj

Password for g five mobile

 Solved/Closed

Hi, What is default password for G FIVE mobile phones ( G FIVE U888)

1 reply Last reply on 23 Jun 2010 by
Ambucias

How to add time reminder in excel file

 Solved

Hello, I have made a work to do list and I would like excel to remind me at every task time. as I have made a column for work to do item and ti...

2 replies Last reply on 23 Jun 2010 by
nis

Moserbear sd card password

 Solved

Hello, I forogot my Moserbear SD card Password. So i can not attach this card is another Mobile Please HelpConfiguration: Windows XP Internet Expl...

1 reply Last reply on 22 Jun 2010 by
closeup22

Can't open word document

 Solved

Hello, i can't open my docx word document.i'm running office 2007 and i'm clickin all my word documents and getting the same response "the file is n...

5 replies Last reply on 22 Jun 2010 by
julie

Error 800a01a8

 Solved

Hello, I am having this error every time I try to save a file; " Could not complete the operation due to error 800a01a8". Plus this is the code ...

5 replies Last reply on 21 Jun 2010 by
Sofy

Search a column against a column of text

 Solved

Hi, I've been stumped with this problem for 2 days now and would appreciate any help. I have column A and column B. Column A has about 20,000 rows ...

19 replies Last reply on 20 Jun 2010 by
rizvisa1

Code clear contents

 Solved

Hello, I'm using this code to clear contents in a spreadsheet: Sub clearunprotectedcells() Dim cell As Range Range("A12:F14").Select For Eac...

4 replies Last reply on 20 Jun 2010 by
MONI

Load sheet with drop down menu

 Solved

Hello I have the userform1, and a combo box linked to two cells callled "UNIVERSAL BOL" AND "BLANK BOL", plus two sheets called "BOL" and "BLANK BO...

4 replies Last reply on 20 Jun 2010 by
Alexandra

Password removal

 Solved

Hello, This is frederick and there is a password on my pc's bios which software can i use to remove it without removing the battery from the comp...

1 reply Last reply on 20 Jun 2010 by
jack4rall

Log on password

 Solved

Hi There! Log on to windows password. How can i get rid of it? please! system win xp pro

1 reply Last reply on 19 Jun 2010 by
closeup22

Dell d620 system, administator password

 Solved

I have had this lap top for years and the hard drive stoped working. I bought a new one and when I turned it on to load ther OS that came with it it a...

1 reply Last reply on 18 Jun 2010 by
jack4rall

Calculating percentage from one column

 Solved

Hello, I am trying to calculate the simple sales commission. I entered the sales amount starting C8 and will continue below. Starting D8, I need...

4 replies Last reply on 17 Jun 2010 by
Judy

Calculating percentage

 Solved

Hello, This is not working. I am sorry that I cant explain it right. I have numbers entered on C8, C9, C10......................(It doesn't have m...

1 reply Last reply on 17 Jun 2010 by
rizvisa1

Match strings of characters & return content

 Solved

Hello, I was able to define this formula to return the row in which the match content was found: =MATCH("*"&MID($B2&REPT(CHAR(6),6),(ROW(OFFS...

7 replies Last reply on 17 Jun 2010 by
maggs
Results 2101 - 2150 out of a total of 2,603