The discussions

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

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

1 reply 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

Help in merging codes

 Solved

Hi I need help in the following VBA (Macro Codes) in Excel 2013 Code 1: Private Sub Worksheet_Change(ByVal Target As Range) Dim Inva...

2 replies Last reply on 10 Sep 2015 by
smuneeb

Function has too many arguments...

 Solved

Why is excel telling me that this formula has too many arguments? =IF(TODAY()>=B9+15,"PAY NOW","HOLD",IF(u9="PAID","PAID")) I am stationed on ...

1 reply Last reply on 10 Sep 2015 by
venkat1926

Search for multiple substrings and return different values

 Solved

I have a cell I2 which contains long string. I want to find out the following: If string in I2 contains "month", then return "Monthly", If string ...

2 replies Last reply on 9 Sep 2015 by
jotied

Need help with data sorting

I have 2 columns , one which contains values ( the invoice amount) i send.. The other column will have another list of values ( funds credited to me)....

1 reply Last reply on 9 Sep 2015 by
ac3mark

Outlook 7 not sending mails

Hello sir, I use outlook 7.but when i send message enter network password dilogbox box appear and message not send what should i do give suggestion....

1 reply Last reply on 9 Sep 2015 by
ac3mark

Spreadsheet data

Hello, I would like to know how to set up a formula so when I enter a certain value or text into a cell i.e "C" all of the information in that row ...

1 reply Last reply on 9 Sep 2015 by
vcoolio

View in browser

Hello,

3 replies Last reply on 8 Sep 2015 by
xpcman

Filers

Hello, I added filters to my excel spreadsheet and saved, however, when other people open it sometimes the filters are no longer there. What could ...

2 replies Last reply on 8 Sep 2015 by
Brenda

Data storing by click.

Hello, I'm working on excel which has assembly numbers. I've assembly names and corresponding numbers by side for each assembling we do. I'm looking...

1 reply Last reply on 8 Sep 2015 by
TrowaD
Results 2751 - 2800 out of a total of 12,258