The discussions

Hide the formula

Hello, I am creating an excel sheet where I need to have a cell show 55% of a number that will change weekly. How do I set it up where the original...

1 reply Last reply on 20 Feb 2013 by
rizvisa1

Conditional formatting

Hello, I'm using Excel 2010 (not sure whether or not that matters) I'm not very familiar with conditional formatting, so I need help with somethi...

1 reply Last reply on 20 Feb 2013 by
rizvisa1

Looking for a value in a cell

Hello, I am using the following formula below =IF(OR(A1=" ",B1=" ",C1=" ",D1=" ")" ",G1) What I am trying to do is if all the cells are blank ...

3 replies Last reply on 20 Feb 2013 by
rizvisa1

One cell will turn green when the two other cells match

 Solved

Hello, I am keeping a register of staff in our department. What I want to happen is for the cell (where the name is) to turn green when the date ...

13 replies Last reply on 20 Feb 2013 by
diestra123

=month(d2)

 Solved

Hello, Empty cell in Excel file has changed in the month, while 0 is 1 reply should have come to help please Configuration: Windows XP / Chrome...

5 replies Last reply on 20 Feb 2013 by
ramlalmeena

Adding specific days to date

Hello, Configuration: Windows 7 / Internet Explorer 9.0 how to add 21 days to date 25.02.2012 in Cell A1 in excel 2007

1 reply Last reply on 19 Feb 2013 by
rizvisa1

Excel formula not working - why?

Hello, I have trouble with this formula and I'm new to Excel, can you tell me why isn't working? =IF(ISNUMBER(SEARCH("1.1",A17:F17)), F17, "") ...

1 reply Last reply on 19 Feb 2013 by
rizvisa1

Macro to email picking up email address in one cell using lookup

 Solved

Hi can anyone help me I am using the VBA below to email a results sheet to various people,the code that I have will only allow me to email to one pers...

6 replies Last reply on 19 Feb 2013 by
Tom9o

Duplicate data from on tab to a master tab

Hello, I need to create a work book wit 5 tabs? The 1st tab will be a Master Page and the 2nd,3rd and 4th will be data inputted by other users,...

8 replies Last reply on 19 Feb 2013 by
TrowaD

Returning value from column b in column c, in a cell ajacent to

 Solved

Hello, BHID MN Samp 47.86 Samp 50.24 Samp 41.63 Samp 49.34 Samp 48.19 Samp 53.11 Samp 50.98 Samp 49.07 Samp 48.05 Samp 52.96 Samp 41...

3 replies Last reply on 19 Feb 2013 by
lawrencen

How to download?

Hello, I want to down load Excel and Microsoft Publisher Configuration: Windows 7 / Internet Explorer 9.0

1 reply Last reply on 18 Feb 2013 by
rizvisa1

Recovery my work and restart microsoft excel

 Solved/Closed

Hello, everyone i have a problem with my excel while I start this program then open the file in MS Excel. Excel pops a message saying "MS Office ...

21 replies Last reply on 18 Feb 2013 by
Sridhar L

Compare data in seperate columns to find likely matches

 Solved

Hello, I want to compare data in columns which essentially is the same but worded different. For Example Name of Person County...

4 replies Last reply on 18 Feb 2013 by
Spraoi

No tool bars or address bar on my browser

 Solved/Closed

Hello, I don't know what I did, but my address bar is only visable when I drag my mouse up to the top of my screen and my toolbars have disappea...

175 replies Last reply on 17 Feb 2013 by
Paddy

Excel function

Hello, please i need your help in the following problem I have one worksheet contains many colums, rows, and calculations as follows: empl...

3 replies Last reply on 15 Feb 2013 by
Zohaib R

Code for macro that conditionally inserts rows

 Solved

Hello, I know this has been asked and answered often, in particular here: https://ccm.net/forum/affich-222200-insert-rows-on-change-of-value-in-excel-...

4 replies Last reply on 15 Feb 2013 by
bfleming

Help!!! conditional formating

Hello, I have a spreadsheet (d2:d7) with 2012 prices in column D2 and 2013 prices in column D3 for the same product...what i want is if D2 is bigg...

1 reply Last reply on 15 Feb 2013 by
rizvisa1

Excel if function: less than date

Hello, I need a what if formula to satisfy the following: if date in K34 is before 23 Nov 2012, then AB34 = yes and so on.. i.e date in K35> 23 N...

1 reply Last reply on 15 Feb 2013 by
rizvisa1

Excel for mac opens all files on desktop

 Solved/Closed

Hello, Whenever I open any Excel file, Excel opens every file on my desktop as well (excel or not). I have to wait until the whole bunch load up, t...

10 replies Last reply on 14 Feb 2013 by
Dan

Is there anyway to use vlook with index

Hello, I have hard time to solve this: I have problem like this: 1st worksheet I have a table similar than this: A B C D 1 D...

2 replies Last reply on 13 Feb 2013 by
rizvisa1

Microsoft word free download

Hello, i am wondering how i can download microsoft word free onto my computer help please... Configuration: Windows 7 / Chrome 24.0.1312.57

1 reply Last reply on 13 Feb 2013 by
Ambucias

Can't open excel file

 Solved/Closed

Hello, I'm running a Mac (10.5.8) and am having trouble opening a recently created Excel file. I was able to open the file since the first time I ...

6 replies Last reply on 13 Feb 2013 by
yolooo

Office

Hello, I have just downloaded project 2007 from this site but I need a product code to activate it. Can anybody help me with this? Your assistan...

1 reply Last reply on 12 Feb 2013 by
Ambucias

If statement errors and using multiple if statements.

 Solved

Hello, I am self teaching excel spreadsheets, and I would really appreciate some help to anyone that would graciously be willing to offer it. I ...

3 replies Last reply on 12 Feb 2013 by
jsav

Comparing two xl sheets

Hello, I have two excel sheets. A and B A has two columns col1 ,col2 B has two columns col1 and col3 i want create new sheet which has col1 ,...

3 replies Last reply on 12 Feb 2013 by
Zohaib R

Conditional formatting of cell in other worksheet dependent

 Closed

Hello, Hope I make this one clear. I am working on a workbook created by a another and here is what I am trying to achieve. An item selecte...

1 reply Last reply on 10 Feb 2013 by
Ambucias

Can this be done? if yes, how?

Hello, This is my beginners attempt to write VBA code (I just wrote a macro to write MsgBox "Hello World" :-)) Please chk the Following ex...

5 replies Last reply on 8 Feb 2013 by
resolehtmai

Writing rule in ms excel using vb

Hello, my question is...i'm having huge customer list mails in the format ******@***.es.us ******@***.es.in ******@***.net.us ******@...

7 replies Last reply on 7 Feb 2013 by
rizvisa1

How to expert office excel work

Hello, I'm Salman i live in dhaka. i work in a company. some time facing many problem to office excel work. Pls told me to how to improve excel wo...

1 reply Last reply on 7 Feb 2013 by
Zohaib R

Conditionnal formating for more than 3 colors

Hi, I need some help with conditionnal formating. I have 27 conditions and for each I need a separate color. 1,0-2,0 2,0-4,0 4,0-6,0 6,0-...

10 replies Last reply on 7 Feb 2013 by
rizvisa1

Merging more cells into one cell

 Solved

Hello, how to merge 3 cells into 1 cell? we tried and tried but we didn't get it.. even the formula, we don't know.. we are just a first timer. w...

10 replies Last reply on 6 Feb 2013 by
markswan20

How can calculate days between twodates

 Solved

Hello, I HVE TO CALCULATE THE DIFFRENCE IN DATE. e.g: there is a two coloums as per below, purchase requisition date purchase order date ...

2 replies Last reply on 6 Feb 2013 by
Kevin@Radstock

I want to insert an image without a background

Hello, How can i insert an image without a background using .. ACDsee Pro 5 ... and if i could do it with another programe what is it and what is ...

1 reply Last reply on 6 Feb 2013 by
nimmi

How to insert & resize picture automatically

Hello, Configuration: Windows 7 / Chrome 24.0.1312.57 Sir I have an Excel 2007 file named "DTPH.xlsx" with data having person names, details i...

1 reply Last reply on 6 Feb 2013 by
Zohaib R

Insert row with formats and formulas

Hello, I am curretly trying to write a macro, that will insert a row on the next available line, keeping the formulas, formats, (including some co...

2 replies Last reply on 5 Feb 2013 by
TrowaD

Recurring billing fee

Hello all, I was wondering if anyone knows a way to have Excel add a monthly billing charge to invoices. I need something that would automatically...

8 replies Last reply on 5 Feb 2013 by
rawr

Organisation chart preparation

Hello, how to prepare organisation chart Configuration: Windows XP / Firefox 18.0

1 reply Last reply on 5 Feb 2013 by
TrowaD

Macro to count the answers in a table

Hello, I have a problem in macro in Excel. I am working on a file that counts the number of responses (0 or 1) of a certain type under certain que...

3 replies Last reply on 5 Feb 2013 by
TrowaD

How can i recover my exchange edb mailbox into pst?

 Closed

Hello, I need to recover my Exchange EDB mailboxes into PST from corrupt Exchange environment. Can you please tell me how can i recover my Exchange...

2 replies Last reply on 5 Feb 2013 by
zenobia

Macro to download certain files from a webpage

Hello, I am trying to find a way to download a number of files that exist on a webpage (the names are in sequence, e.g. abc202, abc203, abc204...e...

3 replies Last reply on 4 Feb 2013 by
rizvisa1

Changing cell formats based on another cell value

Hello, I was having difficulty in solving this problem. say: I have a dropdown on A2, text1, text2, text3 when you selected text1 the format...

1 reply Last reply on 4 Feb 2013 by
rizvisa1

Transferring data from one sheet to another

 Solved

Hello, I have been using Excel for a number of years but fairly new to formula etc. I need a VBA code that can copy data from costing(raw data) to ...

15 replies Last reply on 3 Feb 2013 by
Cuffy70

Convert text mixed numbers to spelling

Hello, i want to know how can we convert in excel the mixed numbers such as 1ZXV78 to "one ZXV seven eight".. can some one help on this task, ...

1 reply Last reply on 2 Feb 2013 by
rizvisa1

What formula shall i use

Hello, Hi morning! I Have a problem right now. Here's the thing. I' working on an Ms Excel. My data are the following: "Assigned Reg...

11 replies Last reply on 2 Feb 2013 by
rizvisa1

Vb script to read data from another sheet

Hello, please provide solution , please find my requirement Sheet1 column name values A 1 B ...

1 reply Last reply on 2 Feb 2013 by
Zohaib R

Cell with cal/min

Hello, I want to calculate the (k)Cal/min in excel. I have a cell with start time defined in time and a cell with endtime (from a running session)...

1 reply Last reply on 2 Feb 2013 by
Zohaib R

Time calculations on a 24-hr clock

 Solved

Hello, I need a formula that I can apply to my spreadsheet that will calculate how much time it takes someone to complete a task. Everything is b...

1 reply Last reply on 2 Feb 2013 by
Zohaib R

French- english word?

Hello, Im trying to work out how I change the language on my word to English, as I accidently installed it all in French and now I cant work it ...

1 reply Last reply on 1 Feb 2013 by
AcerLappy

Auto notify or mail when excel sheet updated.

 Solved/Closed

Hello, We have a Excel which is saved to a network drive and used by multiple users. What I need is when somebody updates the excel sheet or puts ...

20 replies Last reply on 1 Feb 2013 by
cdb2013

I have a problem with microsoft office starter?

 Solved

Hello, I would respctfully ask anyone to help me with this problem which is: someday I have open the Microsoft Office starter and then I have been ...

2 replies Last reply on 31 Jan 2013 by
a cooperator
Results 4851 - 4900 out of a total of 12,260