The discussions

Excel 2007 vlookup and match problem

 Solved

Hello Long time lurker, first time poster. I'm having an issue with a Vlookup and match function. I have a set of data that is organised and sorted...

1 reply Last reply on 23 Mar 2011 by
Nikeyg

Transfer barcode info to inventory quantity

 Solved

Hello, Is there a way to create a macros that would keep track of inventory quanitity by scanning a barcode? I have many boxes that have barcodes...

2 replies Last reply on 22 Mar 2011 by
osborsm

Office 2010 requirements

 Solved

Hi, What are the requirements to install office 2010 on system?the minimum ram required? Please reply as fast as possible

3 replies Last reply on 21 Mar 2011 by
TrowaD

Dell d505 booting password reset

 Solved

Hello, DELL MODEL D505 BIOS REV. A09 laptop show service tag #9R1ZM1J-595B PLEASE TELL ME IF ANYONE HAVE SOLUTION Dell Latitude Bios Password un...

1 reply Last reply on 21 Mar 2011 by
bionik

I forgot my password

 Solved

Hello, could some one please help me i have a dell laptop inspiron 7500 and i cant log in i forgot my password can you help me ...

1 reply Last reply on 20 Mar 2011 by
bionik

Pie chart comparison

 Solved

Hello, I have made a number of different pie charts & want to compare them with each other. Each pie chart is comparing the same thing but the ...

1 reply Last reply on 18 Mar 2011 by
TrowaD

I forgot my login password for my compaq cq60

 Solved

Hello, i forgot my login password on my compaq CQ60 laptop, i just recently changed it and now i can't remember it. Can i please get a reply ASAP

1 reply Last reply on 18 Mar 2011 by
pcsces

How to do if statements in excel

 Solved

Hello, I am having a problem trying to get an if formula right. If fig1 is +- 10% of fig2 I want it to say Fail If fig1 is within 10% of fig...

2 replies Last reply on 18 Mar 2011 by
Emerbeamer

Summary sheet

 Solved

Hello Sir, I Have 30 Data Sheets Of Individual Date & 1 Summary Sheet. The Example Of Those 30 Sheets Are: A1------------B1------------------...

9 replies Last reply on 18 Mar 2011 by
RWomanizer

Assign a value depending on the font color

 Solved

Hello, Can someone help me with this. I have a column with some text in each cell of that column. The text font is in either red or black co...

3 replies Last reply on 17 Mar 2011 by
TrowaD

Searching a column for a list of values

 Solved

Hello, I am using a macro to search for a list of values that i want to be written into the macro (Permanently). currently i am looping after each s...

2 replies Last reply on 17 Mar 2011 by
rizvisa1

Count appearances of specific words in excel

 Solved

Hello, I have a spread sheet with names of countries in the first column and over 1300 lines of text in the second column. I want to count number of t...

1 reply Last reply on 17 Mar 2011 by
RWomanizer

Regarding samsung sgh-m20 slider password

 Solved

Hello, please help me to reset the password for my mobile samsung sgh-m20, whose password has been forgotten by me. regards rajesh

1 reply Last reply on 16 Mar 2011 by
Ambucias

Bar and stacked bar graph in single graph

 Solved

Hello, hi i have to make chart using three field month wise. and i want to make bar for first field and stacked bar for next two within same graph...

4 replies Last reply on 15 Mar 2011 by
RWomanizer

Dell latitude d-505 config password lost

 Solved

Hello, Dear I have forgot the Confiq password of my Dell latitude D-505, which tag No. is 52MSW41 PLZ do help to reset or deactivate the said p...

1 reply Last reply on 14 Mar 2011 by
bionik

Found cell color and worksheet viewing

 Solved

Hello, The code below had cause the found value cell color to remain there even after I closed the Input Box.I would like to have the color to be re...

2 replies Last reply on 14 Mar 2011 by
TrowaD

Compare the values and multiply the greater

 Solved

Hello, A B 58.85 503.171 I want to compare the values in Column A and Column B and then multiply the greater with nu...

2 replies Last reply on 13 Mar 2011 by
Abid

Startup password

 Solved

Hello, I just purchased a d260 mini secondhand and I stupidly thought I could change the administrator name, but of course it would not let me cha...

1 reply Last reply on 12 Mar 2011 by
Ambucias

Remaining retirement calculation

 Solved

Hello Sir, I Wanna Calculate Few Things A1 Is My Date Of Birth A2 Is My Date Of Joining I Want Few Formulas Using These Two. First Thin...

5 replies Last reply on 11 Mar 2011 by
Game Start Now

Lost password -sa6 pink

 Solved

Hello, My grand kids changed the password on her laptop cannot rember the pasword i need a disk.Thanks Configuration: Windows Vista / Internet ...

1 reply Last reply on 11 Mar 2011 by
Ambucias

Macro to define a interval

 Solved

Hello, i have a excel sheet of details of employee of the organisation. in that sheet I have a column D of age. I have to define age interval f...

12 replies Last reply on 9 Mar 2011 by
rizvisa1

How to make xl readonly true or false on cond

 Solved

Hi, I have an requirement like need to open an excle workbook and make it as readonly false then copy some rows to dat workbook then again make it ...

2 replies Last reply on 9 Mar 2011 by
Govind

Vlookup

 Solved

Hello Sir, In Sheet1 I Have Numbers Like A-----------------B------------ 4050 6080 9060 And In Sheet 2 I Have Data Like: A--------...

2 replies Last reply on 7 Mar 2011 by
Game Start Now

Find, select, copy, paste elsewhere in para

 Solved

Hello, Can anyone help in the following matter: How to find, select, copy and paste elsewhere the paragraphs containing specific terms in...

3 replies Last reply on 5 Mar 2011 by
Ambucias

Adding new data sets to multiple worksheets

 Solved

Hello, I am creating a spreadsheet database for data to determine the best vendor to use. I have multiple vendors on different worksheets and the...

2 replies Last reply on 4 Mar 2011 by
Aaron

Macro to copy rows from one worksheet to anot

 Solved

Hi , I'd like to know if there's a macro that can be run to check one worksheet. In this worksheet there is a column where the value should be "true"...

9 replies Last reply on 4 Mar 2011 by
Gowind

One button to execute two macros

 Solved

Hello, I got one macro in Sheet1 and another macro in sheet2 under the same workbook.I want to assign a button in sheet1 so it can execute both the ...

4 replies Last reply on 3 Mar 2011 by
azmiismail

Excel formula a+b=c with the following except

 Solved

Hello, I really could use some help please. I am working on an 2010 excel spreadsheet. Would anyone know if there is a formula to do the following....

2 replies Last reply on 3 Mar 2011 by
Scott

Use excel vba to create an e-mail w reminder

 Solved

Hello, I create a file in Excel that does some calculations based on a small database and some user input. I then added a button to open an e-mail...

2 replies Last reply on 2 Mar 2011 by
Bruno

Overtime calculation

 Solved

Hello Sir, I am having problem doing my work at office. I want to calculate the overtime hours of the employees. A1 is Time In where i...

21 replies Last reply on 1 Mar 2011 by
Game Start Now

Filter all pivot table by same criteria

 Solved

Hello, I am using excel 2007. I have a data on sheet1: I had make 4 pivot tables from that data in four different sheets: Now I have ...

10 replies Last reply on 1 Mar 2011 by
RWomanizer

Toshiba password reset disk

 Solved

Hello, hi how r u good i hope anyway i forgot my password on my toshiba satalite laptop is there any thing i can do from home to fix this Confi...

1 reply Last reply on 28 Feb 2011 by
Ambucias

Codes explaination

 Solved

Hello, I have an text in excel as below. 1 1 1 2 2 2 3 3 3 After running a macro Iam getting the result as below. 1 ...

2 replies Last reply on 28 Feb 2011 by
Waseem

Macro to highlight a row if cells match value

 Solved

Hello, I sorry but I am very new to macros and trying to create one in Office 2003. I need to bold a row if for example column E is greater than a...

2 replies Last reply on 22 Feb 2011 by
sgriffis

Count if macro on multiple criteria

 Solved

Hello, Could someone please help me out with a count-if macro on multiple criteria. I have attached a sample file in the below link http://ww1....

4 replies Last reply on 22 Feb 2011 by
Wasem

Number convert to word in excel which formula

 Solved

Dear Sir, Please help me number convert to word in excel which formula Hello, Configuration: Windows XP / Safari 534.13

1 reply Last reply on 21 Feb 2011 by
RWomanizer

Help with excel

 Solved

Hello, i have two speadsheets. the first sheet contains a total column EX: in C4 =SUM(E4+G4+I4+K4+M4) Value of C4 = (339816) on the ...

1 reply Last reply on 21 Feb 2011 by
RWomanizer

Macro not saving file in excel format

 Solved

Hello, I have a coding like this: filename = Range("B3").Value Workbooks.Add Set newwb = ActiveWorkbook ChDir "D:\P3\Jan-11\B2B" ...

4 replies Last reply on 21 Feb 2011 by
RWomanizer

If then excel entry

 Solved

Hello, In excel, I have a row where hours worked is entered. Directly underneath that row is another row where allotted break time needs to be ...

2 replies Last reply on 18 Feb 2011 by
Jen

Repeat formula within cell

 Solved

Hello, im a newb with excel and I need to know how would you make this formula repeat within the same cell.. =IF((AND(E9="DOA",S9="Hardware")),...

5 replies Last reply on 17 Feb 2011 by
MoonMemo

Create a backup copy

 Solved

Hello, How do I create a backup copy of original file every time I run macro in excel? Thanks Configuration: Windows 2000 / Firefox 3.6.13

2 replies Last reply on 17 Feb 2011 by
may

Add same value of a column

 Solved

I have two columns A & B like this A B 32 7000 33 8000 32 9000 33 6000 39 10000 and so on, I would like to get in column...

2 replies Last reply on 17 Feb 2011 by
Banti

Conditional formatting in excel 2007

 Solved

Hello, I am trying to apply conditional formatting to a calculated cell (For ex A). Criteria: If Cell A value = Cell B or " - " then ...

17 replies Last reply on 16 Feb 2011 by
Toast

For got my yahoo password

 Solved

Hello, sir i forgot my yahoo password in 2 question i remember one and another i do not remember please help me iwill be obliged i am orgnly i...

1 reply Last reply on 15 Feb 2011 by
Ambucias

I forget my yahoo password

 Solved

Hello, my name is roshan i loss my yahoo account password. i remember only my alternet email and one secret question .pls hep me Configuratio...

1 reply Last reply on 15 Feb 2011 by
Ambucias

Select and copy only nonblank cells

 Solved

Hello, many thanks in advance for any responses I get here, I have toiled in vain on this for hours now. At first it was acceptable to simply c...

5 replies Last reply on 15 Feb 2011 by
Ambucias

Help with conditonal formatting

 Solved

Hello, On our work tracker we have a 10 business day turnaround to get work completed. Currently we have a formula that works out how long it...

2 replies Last reply on 15 Feb 2011 by
croppman

Date diff in excel 2010

 Solved

Hello, So I want to figure out how to write a formula for a difference in days on a "visit log". I want excel to look in multiple cells. (basicall...

2 replies Last reply on 14 Feb 2011 by
Mark

How to name excel sheets on values in columns

 Solved

Hello, I have a list of people names in a column in one sheet with additional cells in each row for adding data. I want to create separate excel s...

8 replies Last reply on 14 Feb 2011 by
eskagsms

Pasword recovery for memory card

 Solved

Hello, i have noika 5233 and i had put a password for the memory card and now i have fought the password so if u can help me ...... Plz

1 reply Last reply on 13 Feb 2011 by
Ambucias
Results 1751 - 1800 out of a total of 2,608