The discussions

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

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

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

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

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

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

Last reply on 17 Jun 2010 by
maggs

Calculating percentage amount 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 nee...

Last reply on 17 Jun 2010 by
Netscur

Excel move cells to right.

 Solved

Hello, I have a task to move several cells in a few column to the far right column (like below) Number of column can be up to 25. ...

Last reply on 17 Jun 2010 by
j3kj3k

Protecting column in worksheet

 Solved

How to protect only one particular column in worksheet?

Last reply on 17 Jun 2010 by
Saky

Excel 2007 find max value

 Solved

Hello, date time value 05/11/2008 205 102 FALSE 05/11/2008 205 110 TRUE 05/11/2008 205 108 FALSE 05/11/2008 240 123 TRUE 05/11/2008 240 104 FA...

Last reply on 17 Jun 2010 by
rizvisa1

Clearing clipboard

 Solved

How to clear clipboard using macros?

Last reply on 17 Jun 2010 by
Saky

Sumif formula to sum between 2 dates...help

 Solved

Hello, I want a formula to sum the cells between 2 dates. For eg: Col A Col B Dates Total 3/2/2010 100...

Last reply on 16 Jun 2010 by
Chris

Excel macro to insert a new row

 Solved

Hello, I would like to create a macro in excel to automatically insert a new blank row immediately after the last row of filled-in data and for th...

Last reply on 16 Jun 2010 by
rizvisa1

Guyz...please help with this ...

 Solved

Hello, Thanks for giving your time to this. I want to get a help for the following thing. I am trying to calculate ticket fares between places. I w...

Last reply on 16 Jun 2010 by
rizvisa1

Memory card password

 Solved

Hello, Configuration: Windows XP / Safari 533.4 hi i want to ask how to set a password for only memory card i have tried every option please hel...

Last reply on 15 Jun 2010 by
closeup22

Help with if vba statement

 Solved

Hello, I have this code that i can not get to work all the way i get the error of "Too many local, nonstatic variables" i am new to this and all i...

Last reply on 15 Jun 2010 by
Boysenb

Automatic date population

 Solved

If i fill any data in cell A1 then automatically current date should get update in the next column B2. Can this be done? Pls assist.

Last reply on 15 Jun 2010 by
Krish

Trying to create a advanced control box

 Solved

Hello, I'm wondering how the control box in the attached sheet can be created in Excel 2007 - i want to create it in one of my sheets http://i...

Last reply on 15 Jun 2010 by
rizvisa1

Lookup word within text and provide cross-ref

 Solved

Hello, Excel V. 2003. First list contains Internal Account Numbers, Portfolio Names Second list contains External Account numbers, Portfolios ...

Last reply on 15 Jun 2010 by
rizvisa1

Excel function or macros

 Solved

Hello, I have a table in which every number from 1 to 52 expresses a specified text For example 1 = Sofia 2 = London ... I n...

Last reply on 15 Jun 2010 by
Philip

Password problem

 Solved

Hello, when ever i turn on my computer and i wana go to setup by pressing f2 it requirs password how can i remove it plz help!!! Configurati...

Last reply on 14 Jun 2010 by
jack4rall

Macros

 Solved

Hi, I need a macro coding for the below scenario. In column D(Application) i have created a validation in which i have included the list of appl...

Last reply on 14 Jun 2010 by
Saky

Excel help with percent calculations

 Solved

Hello, I use "=AVERAGE(B2:AR2)" to calculate percentages based on information from 40 sheets. Example, On one sheet that compiles the data from 40 she...

Last reply on 13 Jun 2010 by
rizvisa1

Forgotten the pnone lock password

 Solved

Hello, I have forgotten the phone lock password of my nokia 7210 supernova.can anyone help me to recover the password.plz help....

Last reply on 13 Jun 2010 by
closeup22

Converting time units to whole no.

 Solved/Closed

Hello, Example: start time is 8:00AM and end time is 8:30 AM= total time :30 (cell is formated to time units)... How do I convert :30 to show ...

Last reply on 12 Jun 2010 by
eyji

If function in data range

 Solved

Hello, does anyone know how to solve this: In a data range of say A1:A10, if all entries are "YES", give me "YES"; otherwise give me "No"

Last reply on 12 Jun 2010 by
eyji

Can't open ms word 2007

 Solved

Hello, Whenever I try opening MS Word 2007 - I get this message "Windows cannot find C:\Users\User\Desktop\...............file.doc. Make sure y...

Last reply on 12 Jun 2010 by
closeup22

Delete entire content if cell a1 value change

 Solved

Hello, I have been enriching high value support in excel programing, its great upto you guys, I have a another chanllange to answer, hope you sol...

Last reply on 12 Jun 2010 by
Nitin

Vba language for a range of cells

 Solved

Hello, I created a calendar cell pop-up and I wanted to include it in a range of cells. However I can't figure out how to include an entire range of c...

Last reply on 11 Jun 2010 by
rizvisa1

Compare multiple cells and return other value

 Solved

Hello, a problematic case, when comparing values in multiple cells (rows) in Excel. In a single cell , "A1" I would need an answer depending on...

Last reply on 11 Jun 2010 by
Vince

Cell changing color if updated within the las

 Solved

Hello, Can I set a cell to change background color if I have updated that cell during the last 10 days? Meaning that, if I update a cell it will r...

Last reply on 11 Jun 2010 by
rizvisa1

Create a form to modify existing records

 Solved

Hi, My name is Lucy, I was wondering if any person here could help me. I am having this trouble, i have a form where I enter the name of client...

Last reply on 10 Jun 2010 by
Corina

If cell is a,b or c then 1,2 or 3

 Solved

Hello, I am trying to get a formula that will let my put a numerical value in one cell dependant on the word in another cell for example a1="word1...

Last reply on 10 Jun 2010 by
mltplyn

Need excel percentage!! help

 Solved

Hello, I am having diffficulty writing a formula to calculate a percentage. I need to calculate 25% of $ 3,100 - I thought I had it figured ...

Last reply on 9 Jun 2010 by
Deanna

Copy row to different sheet based on cell

 Solved

Hello, I am need to have a script run each time a cell changes to a date in column O, line 12 and after. I have a spreadsheet that has one tab ca...

Last reply on 9 Jun 2010 by
gregoryps

Tabs not showing

 Solved

Hello, A few days ago somebody very kind gave a hand with this, but I am having a problem: every time I use combo box it should be showing tabs "...

Last reply on 8 Jun 2010 by
Mary

Calculating exact percentages in excel

 Solved

Hello, I'm trying to add exact percentages like 99.54%, 84.23% in six cells then calculate the average. I've tried =AVERAGE(A1:B1:C1) but it only ...

Last reply on 8 Jun 2010 by
rizvisa1

Recover card password

 Solved

Hello, I have the card which has password to open it. but I forgot the password. and I have no data cable , now how can I recover the password. ...

Last reply on 8 Jun 2010 by
closeup22

Excel: partial cell matches in dfrnt sheets

 Solved

Hello, I searched a lot and found quite some useful results about searching Partial Cell matches. But if the cells belong to different sheets how ...

Last reply on 8 Jun 2010 by
fairooz

I forgote memorycard password

 Solved

Hello, how to unloke(delete) my memory card password?

Last reply on 8 Jun 2010 by
ash_perez01

Please help to set print area automatically

 Solved

Hello, I have an issue with print areas. I have a worksheet with equations in it up to cell # 5000. However, most of the time, the equations usual...

Last reply on 7 Jun 2010 by
rizvisa1

Please help - run macro when switching sheets

 Solved

Hello, If someone could tell me how to run a macro upon switching worksheets, that would be extremely helpful. If this is not possible, perhaps ru...

Last reply on 7 Jun 2010 by
D

Undoing a macro to retrieve info back

 Solved

Hello, If I accidentally run a macro, can I (edit undo) to retrieve the information back to how it was? Configuration: Windows XP / Internet Ex...

Last reply on 7 Jun 2010 by
kat

Macro to blank out filtered columns

 Solved

Hello, I have a worksheet that is filtered by a number. I would like to blank out columns M, N, S and T. (Only the filtered information) Can yo...

Last reply on 7 Jun 2010 by
kat

Excel conditional formatting

 Solved

Hello, if date in cell A1 appears anywhere from B1:B30 then apply format. Configuration: Windows XP / Internet Explorer 7.0

Last reply on 7 Jun 2010 by
G

Return a value from a data set

 Solved

The problem is I have number 1 to 10 in A2:A11 and number 10,20,30....100 in B1,C1,D1..... K1 and there are corresponding values in the cells under th...

Last reply on 7 Jun 2010 by
Surya

Default password for china moblie x.e88 mob ?

 Solved

Hello, i need default password for china moblie X.E88 mobile ohone.. pls some one help me..

Last reply on 7 Jun 2010 by
surya

3 dropdownlists

 Solved

Hello, Please help I want to make 3 dropdown lists in Column B2,3,4 and all must work together. In B2 i must have a selection of e.g Building,Person...

Last reply on 7 Jun 2010 by
rizvisa1

Code to open a tabs from combox excel

 Solved

Hello, I'm looking for a code, i can put in a combo box to show up different tabs located in my spreasheet. example: I have four tabs called tab1,...

Last reply on 6 Jun 2010 by
Mary

Excel 2007 days and dates issue?

 Solved

Hello, I was working to have the week numbers in excel and i step into a question when i entered in cell "B1" the date 05/1/2010 and i changed the...

Last reply on 5 Jun 2010 by
rizvisa1
Results 2151 - 2200 out of a total of 2,609