The discussions

Adding the same action to every second line

 Solved

hi guys, i wonder if you could help me with the following: there is a worksheet where column A is full with numbers. I would like to add to ever...

8 replies Last reply on 15 Jan 2013 by
Dg83

If, then formula

 Solved

Hello, I am creating a spreadsheet for the company airplane. Part of it is to calculate how many of the miles flown were "occupied" (had passengers...

2 replies Last reply on 14 Jan 2013 by
eaglewings1983

Convert date into month name

 Solved/Closed

Hello, suppose date has mention 1/1/09 and no month name then how to get the month name

Last reply on 14 Jan 2013 by
Manoj

Copy excel 07 sheet to other & keep formulas?

 Solved/Closed

Hello, Is it possible to copy an Excel 07 spreadsheet to another window spreadsheet (not another tab but completely different spreadsheet) and keep t...

Last reply on 13 Jan 2013 by
limitdydx

Excel - active x combobox, selecting sheets

 Solved

Hi, Am a newbie in trying to automate Excel. I have a workbook with 50 worksheets and a menu sheet. On the menu sheet I created a Actixe X ...

5 replies Last reply on 12 Jan 2013 by
rizvisa1

Many columns return into fewer columns.

 Solved

Hello, I have a spreadsheet that was exported from Survey Monkey. So the format cannot be changed. There can be data in any of 100 columns. Howeve...

15 replies Last reply on 8 Jan 2013 by
Ambucias

Msoffice 2010

 Solved

Hello, How can I customize Naira Symbol in MS excel Office2010. Thank you.

1 reply Last reply on 6 Jan 2013 by
rizvisa1

How to send emails

 Solved

Hello, Please tell me how to get the blank form up to type & send an email on OE Configuration: iPhone / Safari 4.0 -- Dick McD...

3 replies Last reply on 31 Dec 2013 by
Ambucias

Short cut to merge cells

 Solved/Closed

Hello, If there a short cut on the key board to merge cells in excel?

Last reply on 31 Dec 2013 by
Roopesh

How to convert a numeric value into eng. word

 Solved/Closed

Hello, How to convert a numeric value into English words in Excel plz show that formula

Last reply on 22 Dec 2012 by
venki

Formating date

 Solved

Hello, I have date in a cell now i want to see the next cell red color if the next cell is not filled up by the next 10 days from 1st cells date. ...

9 replies Last reply on 19 Dec 2012 by
shishacu

How to recover deleted .ost and .pst files

 Solved/Closed

Hello friends, Outlook.pst file deleted. Now I am unable to configure outlook now.... Pls suggest...how to do now...? How to recover dele...

Last reply on 14 Dec 2012 by
Zohaib R

Product key for ms publisher just downloaded

 Solved/Closed

Hello, Configuration: Windows XP / Chrome 23.0.1271.95 how do I get the product key after down loading MS Publisher from your web site(X16-32...

Last reply on 13 Dec 2012 by
Ambucias

Match barcode between 2 sheets

 Solved/Closed

Hello, I have two diffrent sheets. One sheets has tens thausand lines with barcode value,description and quantity of product. another one has 2...

Last reply on 13 Dec 2012 by
TrowaD

Deleting a progress bar from powerpoint presentation

 Solved/Closed

Hello, I used the following method to add a progress bar to my PowerPoint presentation - now I don't like it. https://ccm.net/faq/937-insert-pr...

Last reply on 10 Dec 2012 by
lohbecej

How can i eliminate #value in calculated cells

 Solved

Hello, I am building an Excel calculation sheet for cookeries for christmas. In cell H$7 I have the input for how many times I would like to ...

14 replies Last reply on 9 Dec 2012 by
hwrychen

Convert number into words in excel 2007

 Solved/Closed

Hello, i'm trying to convert number into words in excel 2007. i've written coding in VB module. But I don't know how to get it in my function list...

Last reply on 8 Dec 2012 by
Brijesh

Converting number into words (excel)

 Solved/Closed

Dear friend, Pl.provide me a formulla which can translate currency number into words i.e. 12,34,56,78,910.91 into Twelve Arab,Thirty Four ...

Last reply on 5 Dec 2012 by
GS

Help with vba

 Solved

Hello, I'm trying to program a macro in Excell 2010. What I need it to do is look in a Range for the NotEmptyCells and change their property fro...

2 replies Last reply on 2 Dec 2012 by
amedotero

Copy data into next empty cell in new sheet

 Solved

Hello, I am trying to make a 2 sheet workbook which has the input details in Sheet1 A1 and this is changed weekly but the info in this cell shoul...

15 replies Last reply on 1 Dec 2012 by
rizvisa1

Auto filter problem

 Solved

Hello, when i am filtering any item for adding value in that item, it will gets filter but the blank cell coming at last is much further behind th...

1 reply Last reply on 1 Dec 2012 by
rizvisa1

Splitting list of names with formula - can you spot what's wrong

 Solved

Hi everyone, I have a list of 1805 names which are gathered in a single column. These names range in length and "format" (e.g. John Smith, John C ...

4 replies Last reply on 30 Nov 2012 by
Zohaib R

If function in excel

 Solved

Hello, my formula is =If(or(A5="016f7",A5="016b8",A5="017a3"),The monthly instalment is equivalent to...........,"") I want in place of ..........

5 replies Last reply on 30 Nov 2012 by
bkaromo

Comparing two excel worksheets

 Solved/Closed

Hello, I am trying to find an easy way to compare and extract data from two excel worksheets. This is the scenario.. I have an excel worksheet ...

Last reply on 28 Nov 2012 by
lcouri

Cut/copy in vba

 Solved

Hello, I am fairly new to Macros but I am trying to write vba code in Excel 2003 version that will enable me to cut/copy a table from one worksh...

3 replies Last reply on 26 Nov 2012 by
Chamberlyn

Covnvert numbers to single words

 Solved

Hello, In excel 2010 i would like to convert numers to words i.e. 123.00 (one two three point zero zero) or 1006235.23 (one zero zero six two thre...

3 replies Last reply on 23 Nov 2012 by
venkat1926

Wd my book reset password

 Solved

Hello, We recently had an employee leave our company. Her files are backed-up on a WD my book essential external hard drive. The program to resto...

24 replies Last reply on 21 Nov 2012 by
VL

Compare and copy data from one column to another

 Solved

Hello, I'm trying to compare column A in Sheet 1 with column A in Sheet 2, then copy corresponding values in column N from sheet 1 to column N in ...

4 replies Last reply on 20 Nov 2012 by
Zohaib R

Move item from 1 listbox to another listbox

 Solved

Hello, need help on an excel listbox using vba. i've got 2 listboxes on a form. listbox1 is being populated from an excel sheet. i need to move...

2 replies Last reply on 18 Nov 2012 by
smd_excel

Excel formulaes

 Solved

Hello, If there are two conditions, how to use the IF formulae. Regards

3 replies Last reply on 16 Nov 2012 by
lancymenezes

Help on generating a number series using a macro

 Solved

Hello, I would appreciate your help with a macro I am trying to create in Excel 2010 my Data is as below Column1 Column2 Column3 (Name) (start nu...

2 replies Last reply on 15 Nov 2012 by
venkat1926

Dynamic range and named ranges

 Solved

Hi, I have a list of students in Sheet 1,2,3 where being updated regularly. They are named ranges "Boys" & "Girls" in Column A & B respectively. In...

8 replies Last reply on 13 Nov 2012 by
iloco

File conversion message

 Solved/Closed

Hello, I use Microsoft Outlook 2003 for my emails. I cannot open any attachment that comes as a Microsoft Word document. I get the message "File Con...

Last reply on 11 Nov 2012 by
rod

Multiple data in one stacked column

 Solved

Hello, i am trying to plot a column chart and I want multiple data to appear in one column. example: I am plotting all the submitted inspections...

3 replies Last reply on 7 Nov 2012 by
Zohaib R

Vba for deleting data in row but not formulas

 Solved

Hello, I am working on a spreadsheet where I have to copy data over to a new sheet, once the data is copied I want to delete the data in the row f...

7 replies Last reply on 31 Oct 2012 by
Debs269

Automation of running excel macros

 Solved

Hello, I have a macro in excel which needs to be run twice a day and I dont even want to open the excel sheet. How can I make this process automati...

11 replies Last reply on 31 Oct 2012 by
Aurorian

Comparing two cell in different spreadsheets

 Solved

Hello, I'm currently struggling to do the following: Spreadsheet A Sheet1 Name Expenses Date ...

5 replies Last reply on 29 Oct 2012 by
narley7

Comparing two lists of id numbers in excel

 Solved

Hello, thanks in advance for reading this. I have a list of student ID numbers which I would like to use as a student check-in. Column A is the num...

3 replies Last reply on 28 Oct 2012 by
rizvisa1

Excel i want to sum only numeric values except alphabetic values

 Solved

Hello, in a school resultsheet where each student having numeric values of their marks in 5 subjects.i am using formula =D6+F6+H6+L6+P6 for total ...

2 replies Last reply on 22 Oct 2012 by
soni17177

Change cell color based on input in a range of cells

 Solved

Hello everyone, I have formatted a cell based on a specific text entered in one cell. Example, A1 will turn green if I write "yes" on B2, using cond...

2 replies Last reply on 22 Oct 2012 by
diestra123

Nested if's

 Solved

Hello, I would appreciate if somebody could help me in solving this problem. I am trying to make exel decide in an scheduled soccer games which team ...

3 replies Last reply on 21 Oct 2012 by
rizvisa1

Excel date format won't change

 Solved/Closed

If I enter a date into a cell in my Excel spreadsheet using the shortcut (CTRL+;), I can no longer change the formatting (right-click, format cell). T...

Last reply on 19 Oct 2012 by
Peaches

Excel,problem with if function

 Solved

Hello, i am working with excell with follwing formula- =IF(H33>=75,"A",IF(H33>=60,"B",IF(H33>=45,"C",IF(H33>=33,"D",IF(H33>=0,"E",IF(H33=AB,"E"...

4 replies Last reply on 17 Oct 2012 by
soni17177

Forgot password

 Solved/Closed

Hello, I am alin i have been using kaksoft folder lock protect the folder...but i could not use the folder so that i forgot the password so how wi...

Last reply on 10 Oct 2012 by
Ambucias

Highlight cells based on drop down list selection

 Solved

Good day, I would like to have a row highlighted in color based on the drop down list selection. I have inserted the following in Worksheet but I e...

4 replies Last reply on 8 Oct 2012 by
wliang

Saving papers

 Solved

Hello Everyone, I hope someone could help... I have list of Check Numbers on Column A and Their Amount on Column B and it runs on almost a ...

3 replies Last reply on 8 Oct 2012 by
ehlblackstar

Excel 2003 days before a certain date

 Solved

Hello, I am making a spreadsheet which has, for example, a given date of 1/1/2012. When I enter that number into cells A1, I want it to return ...

2 replies Last reply on 5 Oct 2012 by
news12kim

Add range if number is 1 to 10, 11-21,22-30 ...and so

 Solved

Hi , I am new to this forum. Looking for small help.. if 1 to 10 is in column A i want to add the numbers which are column B. A B 1 34...

6 replies Last reply on 4 Oct 2012 by
Tanuvi

Insert line number for two columns document

 Solved/Closed

Hello, I have a problem to do a process of line numbering in MS Office 2007 Word Document. I have a document, it has 2 columns and I have to inser...

Last reply on 3 Oct 2012 by
CrazyOliv

Create drop down list on certain cells

 Solved

Good day, I wanted to create a drop down list from data in Sheet2. I have tried the following codes but the outcome seems to be incorrect. Instead...

6 replies Last reply on 1 Oct 2012 by
venkat1926
Results 1351 - 1400 out of a total of 2,608