Office Software Forum - solved topics
- Excel (9,800)
- Open Office (113)
- Outlook (643)
- PDF (334)
- PowerPoint (179)
- Word (2,187)
- Solved
-
Comparing Two Columns With other two columns in excel 2003 Solved/Closed
Dear Sir, I want to compare two columns with other two columns in excel 2003. Columns are as below A B C D a 10 a 10 b 20 b 30 c 30 d 40 ...
-
Excel - shortcut key for print view Solved/Closed
Hello, I am srinu what is d short cut key in ex-cel 2003 for print viewConfiguration: Windows XP / Safari 532.5
-
create worksheets with names from a list Solved/Closed
Hello, I would be most grateful if you would kindly help me out. I have a long list of projects and need to create an individual worksheet for ea...
-
file attachment Solved/Closed
Hello, is it possible to attach an excel file in this forum, for a better understanding of a particular posed question? Configuration: Windows ...
-
check info on two different cells... Solved/Closed
Hello, Ladies, Gentlemen, I am working with the formula below, and it WORKS GREAT =IF(Z17="PAID","",IF(F17"CTF","",IF(TODAY()>B17+15,"PAY NOW","HOLD...
-
Allow rules wizard to work without Exchange Server? Solved/Closed
Hello, I no longer work for the company that had the Exchange server and I have my personal pop3 email coming into Outlook. When I try to use th...
-
auto transfer data as i marked Solved/Closed
Hello, I have a spreedsheet where there are names, enrolment No., various subjects(1st Year, 2nd year & 3rd year) of at least 10000 students related...
-
IF formula error: False Solved/Closed
Hello, I'm trying to get one of three answers to show up in my excel document. Currently I have: ==IF(((J43/I43)*100)>=81,"APPROVED")&IF(OR((J43...
-
Counting action under condition of theyr value, and month when.. Solved/Closed
Hello Guys, I came here for help again :) I need to solve one issue. I've created database, which contain column with Dates(column E),and column w...
-
@if formula Solved/Closed
Hello, how do i formulate the following:- if cell B12 contains the word Meals, then I want to use the formula F12/2 else take 100% in F12 Conf...
-
conditional Formating a column Solved/Closed
Hello, I wish to conditionally format a column depending on another columns date value in excel 2010 Column A has a target date and Column B ha...
-
Copy cells based on conditions Solved/Closed
Hello, I want to make several versions of a questionnaire specific for each out of 11 types of a product. Therefore I made a button for each of th...
-
Copying data from workbook to workbook using button Solved/Closed
Hello guys nad ladies, I have a problem, i hope you can help me. I have an excel worksheet (2 columns, 7 rows) It's kind of daily statistics (email...
-
Change color to different cells based on another cells text. Solved/Closed
Hi, need some help, cannot figure this one out. I had attempted to use conditional formatting; however, it is not completely accomplishing what I hav...
-
Copy row and insert n times Solved/Closed
Hello, I have an example below, I'd like to take the first row, copy it "n" number of times, then take the next row copy it the same "n" number of ti...
-
Compare two worksheets and Remove duplicated data from one Solved/Closed
Hello everyone, I am struggling to find a solution and would value input from fellow users. The Problem: I have two separate worksheets "Customer...
-
Search for matches from columns on separate sheets. Solved/Closed
Hello, I've got a problem that is stumping me, and I hope you all can help. I have two sheets in my workbook and I would like to have a formula, ...
-
How To Copy Data Between Several Sheets on VBA Solved/Closed
Hi, I'm still a newbie on VBA, so I could use a little help on getting some code working. I have several client used for factoring. As such, each i...
-
values from one workbook to another Solved/Closed
Hello, I need help - I have two worksheets one with costs and formulas I want to pull the answer from the formula block from the one worksheet to t...
-
i am unable to send out Hotmail from MS Outlook Solved/Closed
Hello, I have configured two email address in outlook 2007. one gmail another one is hotmail. I can send email by my first one gmail account but I...
-
Giving false with certain answers Solved/Closed
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...
-
Range of cells depending on a condition. Solved/Closed
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...
-
Outlook Express emails disappeared - can I get them back? Solved/Closed
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 ...
-
match cells in excel with all characters same except one Solved/Closed
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...
-
Auto populate rows from master sheet to other sheets Excel 2013 Solved/Closed
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...
-
script which can check if a debit has a corresponding credit Solved/Closed
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...
-
IF functions with dates Solved/Closed
Hi, 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/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...
-
Unable to Convert Date in Excel Solved/Closed
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...
-
Using a comand button to open an external software? Solved/Closed
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...
-
How to populate a version # change to a text sentence Solved/Closed
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...
-
Dynamic database Solved/Closed
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...
-
sum different alphabets in an excel range. Solved/Closed
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...
-
Opening Word 2007 docs with Word 2010 Solved/Closed
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...
-
Convert mm/dd or mm/dd/yy or mm/dd/yyyy to Excel internal format Solved/Closed
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...
-
=IF(F21="CTF",I21*15,IF(L21="CTF",O21*15,IF(F21<>" Solved/Closed
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*...
-
IF function for "specific date" + 15 calendar days Solved/Closed
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 ...
-
My compliments, great altruism everybody! Great forum! Solved/Closed
Hello, everybody in the forum! My compliments for your unselfishness and altruism. Your help is VERY MUCH appreciated! A big hello, especially t...
-
=IF(F9:F46="CTF",I9,"") Solved/Closed
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...
-
Conditional Cells Filing Solved/Closed
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...
-
how to use a single part of a cell's date Solved/Closed
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...
-
Help in Merging Codes Solved/Closed
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...
-
Function has too many arguments... Solved/Closed
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 ...
-
Search for multiple substrings and return different values Solved/Closed
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 ...
-
Clicking data in one sheet..Saving all those clicked in another. Solved/Closed
Hello, I'm working on excel which has names(Col A) numbers (Col B). I'm looking to create a sheet, who by clicking on the number, stores the number ...
-
Same Date in Column A on Mutiple Lines in seperate worksheets Solved/Closed
Hi, Not using FILL with copy/paste....Is there a way to create a date range in Column A (IE: 9/1/15) from line 1 going downward when entering multi...
-
Acrobat Reader Solved/Closed
Hello, I get a prompt that my acrobat browser plugin is missing and need to reinstall. Do I need to download the software again? Configuration...
-
Please help in getting data clubbed in one cell Solved/Closed
Please inform how to get the following information clubbed in a row Data as follows Required data in a ...
-
master sheet to work sheet, Solved/Closed
I have been getting help at this site and I am not able to get into my messages to respond anymore. I am not sure if it is just a work computer issue ...
-
Accounts data requires automatic analysis Solved/Closed
Five columns headed Value, Type, Food, Household, Medical. The data is in Value and Type listed alongside each other. I wish to have those transfer...