The discussions
Range of cells depending on a condition.
SolvedHello, 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...
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 ...
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
Outlook express emails disappeared - can i get them back?
SolvedA 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 ...
Match cells in excel with all characters same except one
SolvedHi 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...
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...
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 ...
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. ...
Convert numbers to word
Hello, how can convert for numbers to word Configuration: Windows 7 / Chrome 45.0.2454.101
Microsoft excel
How to work Microsoft Excel properly?
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...
Auto populate rows from master sheet to other sheets excel 2013
SolvedHello, 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...
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...
Script which can check if a debit has a corresponding credit
SolvedHello, 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...
If functions with dates
SolvedHi, I have recently become part of a restaurant management team. Previously they have used excel very basically, just manually inputting every piece ...
Excel - compare data in two worksheets
Solved/ClosedHello, 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...
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...
Unable to convert date in excel
SolvedI 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...
How to download typing master app
hellow...i need the typing master app...how can i download that?
Using a comand button to open an external software?
SolvedHello. 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...
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...
How to populate a version # change to a text sentence
SolvedHello, 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...
Dynamic database
SolvedHello, 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...
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...
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...
Sum different alphabets in an excel range.
Solvedsome 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...
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...
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...
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 ...
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...
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...
Opening word 2007 docs with word 2010
SolvedSo 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...
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...
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...
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 ...
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...
Convert mm/dd or mm/dd/yy or mm/dd/yyyy to excel internal format
SolvedI 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...
Ôter la protection
ClosedBonjour 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 ...
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 ...
=if(f21="ctf",i21*15,if(l21="ctf",o21*15,if(f21<>"
SolvedHello, 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*...
If function for "specific date" + 15 calendar days
SolvedHello, 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 ...
My compliments, great altruism everybody! great forum!
SolvedHello, everybody in the forum! My compliments for your unselfishness and altruism. Your help is VERY MUCH appreciated! A big hello, especially t...
Translate spanish to english of a pdf file
I need to know how I can translate a large PDF file from Spanish to English
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...
=if(f9:f46="ctf",i9,"")
SolvedHello, 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...
Conditional cells filing
SolvedHello 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...
How to use a single part of a cell's date
SolvedSo 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...
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
Help in merging codes
SolvedHi I need help in the following VBA (Macro Codes) in Excel 2013 Code 1: Private Sub Worksheet_Change(ByVal Target As Range) Dim Inva...
Function has too many arguments...
SolvedWhy 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 ...
