The discussions

Giving false with certain answers

 Solved

Hello, I am having an issue with my formula. Certain values will give me the correct answer (A, B, C, D, F) but other values will give me a FALSE...

1 reply Last reply on 29 Sep 2015 by
TrowaD

I want to add 9 if conditions is it possible

Hello, I want to add 9 if conditions is it possible in Excel?

1 reply Last reply on 29 Sep 2015 by
TrowaD

Range of cells depending on a condition.

 Solved

Hello, I am trying to change part of a cell reference for a range of cells depending on a condition. For example, the formulas in column A & E: A...

2 replies Last reply on 29 Sep 2015 by
Milvy

Please solve my promlem if any body can ?

Hello, if i make 10 invoices for a company on sheet 1 to sheet 10, each invoice has amount about Rs. 10000/- i need a auto covering letter on sheet ...

1 reply Last reply on 28 Sep 2015 by
Mazzaropi

Excel formula

Hello, i need the formula on excel sheet for find out percentage if the number is >=3499 than find out 5% and if the number is

1 reply Last reply on 28 Sep 2015 by
Mazzaropi

Outlook express emails disappeared - can i get them back?

 Solved

A user opens his Outlook Express 6 (all windows updates up to date) this morning and finds that his inbox is empty. 200-odd messages that were there ...

2 replies Last reply on 28 Sep 2015 by
EdwardHunterS

Match cells in excel with all characters same except one

 Solved

Hi I was wondering if it was possible in excel to write a formula to perform the following task. I have two columns of data, col A and Col B . For eac...

13 replies Last reply on 27 Sep 2015 by
ac3mark

Please help create sub sheet w/master sheet using vba/macro

Hi, I have a master spreadsheet that I want to pull certain information from without losing the format and formulas. I need it to link with my mast...

1 reply Last reply on 27 Sep 2015 by
RayH

Copy data from a workbook to another work book

I want to copy a particular column from sheet 1 in a workbook to the corresponding sheet 1 in the other workbook and from sheet 2 to the sheet 2 in ...

1 reply Last reply on 25 Sep 2015 by
ac3mark

Excel - if function

Hi I'm trying to write a formula to produce an answer depending on whether the data in a cell contains any of the words I am trying to match. Ie. ...

1 reply Last reply on 25 Sep 2015 by
Mazzaropi

Convert numbers to word

Hello, how can convert for numbers to word Configuration: Windows 7 / Chrome 45.0.2454.101

1 reply Last reply on 25 Sep 2015 by
Mazzaropi

Microsoft excel

How to work Microsoft Excel properly?

1 reply Last reply on 25 Sep 2015 by
Mazzaropi

How to remove apostrophe in excel

How to remove Apostrohe in excel eg. '6018-8400-1532-3636 to 6018840015323636. I successfully remove the dashes by using "Find & Replace" but can't...

1 reply Last reply on 25 Sep 2015 by
Mazzaropi

Auto populate rows from master sheet to other sheets excel 2013

 Solved

Hello, I'm working on a sheet to autopopulate from data that I've downloaded in Excel format. Currently, I have to recreate the wheel (spreadshee...

3 replies Last reply on 25 Sep 2015 by
vcoolio

Match two unique criteria, total from a third .add to new sheet

Hello Apologies if this has been answered in another thread, I have tried to ask the question in many different ways but cannot come up with anything...

3 replies Last reply on 24 Sep 2015 by
Kazok1

Script which can check if a debit has a corresponding credit

 Solved

Hello, I am new to VBA, and I am searching for a script which can check if a debit has a corresponding credit (same value bue with -/+), and highl...

11 replies Last reply on 24 Sep 2015 by
dennisvhansen

If functions with dates

 Solved

Hi, I have recently become part of a restaurant management team. Previously they have used excel very basically, just manually inputting every piece ...

1 reply Last reply on 24 Sep 2015 by
kev8687

Excel - compare data in two worksheets

 Solved/Closed

Hello, I need help with the best way to combine information in two worksheets and identify rows where data in colum B and column C has changed on...

Last reply on 24 Sep 2015 by
Manish

Help! conditional formatting to 1 cell with numerious entries!

I am having some difficulty trying to apply conditional formatting to 1 cell with numerious rules - as i have found 1 rule will always work as new rul...

2 replies Last reply on 23 Sep 2015 by
mdhafeezahmed

Unable to convert date in excel

 Solved

I am trying to change all of the dates in an excel spreadsheet to the mm/dd/yyyy format, but when I go to format the cells, it does not change, even w...

7 replies Last reply on 22 Sep 2015 by
Ambucias

How to download typing master app

hellow...i need the typing master app...how can i download that?

5 replies Last reply on 22 Sep 2015 by
Ambucias

Using a comand button to open an external software?

 Solved

Hello. I'm using Excel and I need do create a comand button to open an external software, e.g. I need do order that button to open "Profis Anchor f...

7 replies Last reply on 22 Sep 2015 by
alfa_eng

Sum funtion to substract

Hello, When I do the below formula the results are different. What's the difference between Sum function and simply doing the subtraction directly...

1 reply Last reply on 21 Sep 2015 by
Mazzaropi

How to populate a version # change to a text sentence

 Solved

Hello, Using Excel 2013 What I'm trying to do is I have for example a row that contains information about my software. And in 4 of those cells t...

4 replies Last reply on 21 Sep 2015 by
Mazzaropi

Dynamic database

 Solved

Hello, i have a database sheet about spare parts in my store .. this spare pasrts are changed their counted daily , i need the formula that refreash...

2 replies Last reply on 21 Sep 2015 by
omar

Excel macro to rearrange data- combine cells and move sheets

Hello, I am just starting to use macros and am lost on figuring this out. Any help would be appreciated, thanks. Inventory comes in a 9x9 bo...

1 reply Last reply on 21 Sep 2015 by
TrowaD

Auto start a specific row in second page from previous page

Hi i need auto start a specific row in second page from previous page in excel i hope your replay Configuration: Windows 7 / Chrome 45.0.24...

1 reply Last reply on 21 Sep 2015 by
TrowaD

Sum different alphabets in an excel range.

 Solved

some one please help me......how to sum different alphabets in an excel range..........example.....range is ...A!:Z1 and i want to sum "P" and C...

12 replies Last reply on 20 Sep 2015 by
Mazzaropi

Macro to copy rows of data off of a sheet into several different

Hello, i'm new to these forums and new to writing macros, I've been trying to find a solution to my problem but haven't found one yet. I need a ma...

1 reply Last reply on 20 Sep 2015 by
vcoolio

Comparison of two table

Hello, I need to compare the two table values and return the result as true or false based on two table value in another table . It should be high...

1 reply Last reply on 19 Sep 2015 by
Mazzaropi

Auto-running macro when cell is changed.

Hello guys, I am using simple macro for one sheet (ControlSheet) to hide rows, in which certain cell (B11;B51) contains text "Corrective Action not ...

4 replies Last reply on 18 Sep 2015 by
RayH

If then rule with dates help

Hello, I'm trying to figure out a formula to calculate adding 84 days to an original date. However, if the calculated date does not fall on a Sund...

1 reply Last reply on 18 Sep 2015 by
Mazzaropi

Transferring data to successive worksheets

Hi I have a excel workbook containing several worksheets. To keep things simple Sheet 1 contains a column headed Dates listing 36 weekly starting dat...

1 reply Last reply on 17 Sep 2015 by
TrowaD

Opening word 2007 docs with word 2010

 Solved

So I installed Office 2010, and removed Office 2007 from my computer (I had lost the product key, so it was in view-only mode, it's a long story) - ob...

3 replies Last reply on 16 Sep 2015 by
Rockport

Conditional formatting as a text

I'm trying to create a conditional formatting to come up as a text. For example I want an if then statement... if the cell = 7, I want a text to com...

2 replies Last reply on 15 Sep 2015 by
Aglo

Cell blocking

Hello, i need to block the cell after entering data to it which means i need each cell to accept entry one time only note.the worksheet must be pr...

1 reply Last reply on 15 Sep 2015 by
TrowaD

Vba for copy/paste a tutor perhaps....

First of all, Excel is not new to me, and although I am not fluid on creating pivot tables, I can create some pretty awesome formulas on my own...and ...

1 reply Last reply on 14 Sep 2015 by
technicgang

Comparing sales of mondays

We have an excel spreadsheet of sales for the year. The headings are Monday thru Friday. The rows are labeled for different categories. We would li...

1 reply Last reply on 14 Sep 2015 by
ac3mark

Convert mm/dd or mm/dd/yy or mm/dd/yyyy to excel internal format

 Solved

I have looked at dozens of articles, but they all talk about converting different forms of mm/dd... etc. to other similar forms. I want to chart bloo...

1 reply Last reply on 14 Sep 2015 by
ac3mark

Ôter la protection

 Closed

Bonjour tout le monde, j'ai un problème qui me bloque depuis un bout de temps, je veux ôter la protection des structures et fenêtres pour un classeur ...

Last reply on 14 Sep 2015 by
Ambucias

How do i lookup a value in say column and in returning the found

Hello, How do I lookup a value in say column and in returning the found value replace the it with a typed value. An example is; a b ...

1 reply Last reply on 14 Sep 2015 by
Mazzaropi

=if(f21="ctf",i21*15,if(l21="ctf",o21*15,if(f21<>"

 Solved

Hello, I am at the crossroads with this functions string (doesn't work) any help will be much appreciated... =IF(F21="CTF",I21*15,IF(L21="CTF",O21*...

1 reply Last reply on 13 Sep 2015 by
Mazzaropi

If function for "specific date" + 15 calendar days

 Solved

Hello, maybe you can help with the following... I am looking for an IF function that alerts me to "PAY NOW" or to "HOLD" as follows; PRODUCT ENTRY ...

11 replies Last reply on 11 Sep 2015 by
j1969c

My compliments, great altruism everybody! great forum!

 Solved

Hello, everybody in the forum! My compliments for your unselfishness and altruism. Your help is VERY MUCH appreciated! A big hello, especially t...

4 replies Last reply on 11 Sep 2015 by
j1969c

Translate spanish to english of a pdf file

I need to know how I can translate a large PDF file from Spanish to English

2 replies Last reply on 11 Sep 2015 by
Ambucias

Forgot password on locked folder

Hello, hi i forget my locked folder pass. i have the file with me. but i tried to open with the pass i always use but cant open. i need the date in...

2 replies Last reply on 11 Sep 2015 by
qazal_eh

=if(f9:f46="ctf",i9,"")

 Solved

Hello, I would appreciate any help regarding the above formula - =IF(F9:F46="CTF",I9,"") - I am trying to compute a scheme where if any cell betwe...

1 reply Last reply on 11 Sep 2015 by
Mazzaropi

Conditional cells filing

 Solved

Hello guys :), I use Excel 12. What I need help with is a conditional filling of cells, based on values in different cells/in the certain row. I l...

2 replies Last reply on 11 Sep 2015 by
Branok

How to use a single part of a cell's date

 Solved

So that's the scenario, I've a date in a Cell (D4) in the format 02/02/2008. I need to compare only the year of the date (2008) and if it's true re...

2 replies Last reply on 11 Sep 2015 by
TheMarcus

Find number (1), in like 12,15,31 ans.should be 3

Hello, Find Number (1), in like 12,15,31 Ans.should be 3 Any formula to count number Configuration: Windows / Chrome 45.0.2454.85

1 reply Last reply on 11 Sep 2015 by
Mazzaropi
Results 2751 - 2800 out of a total of 12,266