Office Software Forum
- Excel (9,795)
- Open Office (113)
- Outlook (643)
- PDF (334)
- PowerPoint (179)
- Word (2,186)
-
Maximum and minimum values of a column Closed
Hi, I have a rather large database of experimental values and rather that giving the average of a particular set, I would like to give a range as it ...
-
Lining up group of cell values in Excel 2007 Solved/Closed
Hi I have two group of cells D6 to D8 and other G12 to G15 Need a code with two conditions that can line up the details of the mentioned cells in ...
-
Excel conditional formatting row color Closed
Hello, I want to change automatically the color of a whole row (from A to H) depending on the entry in column H which contain any "text" (suppose ...
-
Excel VBA/Formula Closed
I have a simple project in which a range of cells are needed to be in filled with color, based on the value on another cell. example if Cell A5 ha...
-
EXCEL Solved/Closed
Hello i want to know how to convert date into words(english & HINDI) in excel 2003 or 2007 for eg. 22.04.2010 - convert it into Twenty Two April...
-
If a cell cointains a specific name, then the value... Closed
Hi! I'm really new (dumb) when it comes to using excel and I've been trying to make my expenses spreadsheets more functional. Here's the layout? ...
-
to convert number into words Closed
Dear Sir Please give me instruction regarding number convert into words in excel. Thanks M. Quyum
-
moving completed tasks from one worksheet to another Closed
Hello, im creating an action register using excel and am trying to set it up to automatically move completed task from one worksheet to another w...
-
Date Closed
hi how find the no of days between two different month in excel example no of days between 12-Jan-13 and 29-APR-14 EG:12-Jan-13 ; 29-APR-14
-
update of Outlook, and after that I cannot receive or send mails Solved/Closed
The computer made an update of Outlook, and after that I cannot receive or send mails. I get the message "Not implemented" when trying. I have the sa...
-
how to arrange the data in the required format Closed
HI i have data in excel in the unorganized manner with blanks im pasting the some of the data 1 GTR4562625 ...
-
Automatically fill rows in Excel Closed
Hello, I have an excel file with the following values: Ico SONY SONY The next time I would write for e.x. "Ico" I want the excel file to...
-
Excel 2010 macros taking more than 4 hours for execution Closed
Hello, i'm validating two excel files, for this i had write macros in 2007 and it's execute in 15min, where as the same code is taking more than 4 ...
-
Synchronizing subscribed folders Closed
How can I disable the "Synchronizing subscribed folders" in Outlook with a GMAil account
-
Fill in rows automatically Closed
Hello, I have an excel file with the following values: Ico SONY SONY T...
-
PDF to Word or Excel Solved/Closed
Dear Sir/Madam, Can I know about the software and it can support our alignment if the text or images in PDF changes to word and it doesnt get align...
-
IF DATE Multiple conditions Solved/Closed
Hello, I need help with rewriting this code: =IF(A1DATE(2017,12,31),"2", IF(A1>DATE(2020,12,31), "1"))) I'm trying to categorize those date ...
-
How to clear contents Closed
Hello, I would like to know how to clear cells from a banking sheet with 7 tills, range from B5/B16 D5/D16 and 10 other columns. I'm hoping if I c...
-
VBA Programming Closed
I want to copy the excel sheet with in the same worksheet, using the VBA Programing i.e. on the click of the button. The new sheet is in the sorted fo...
-
IF DATE Multiple Conditions Closed
I have this code: =IF(A1DATE(2017,12,31),"2", IF(A1>DATE(2020,12,31), "1"))) I'm trying to categorize those date cutoffs into 3 but apparently, t...
-
Date formula question Closed
Hello, How do make the month date year such as 1/1/2014 to hard code month-year Jan-14 for use in pivot table? Thanks Configuration: Windows 7...
-
Word Macro to create Excel formatted cell Closed
I have Word Macro that I run to create an excel spreadsheet with my bookmarks and their text. Two of my bookmarks contain dates, and one contains a n...
-
Enter Key jumps to top of document Closed
Hello, I am working on Mac 2011 in Excel. I have been working in a document for several days and yesterday, every time I press Enter, the cursor ju...
-
Excel - sort by column specifics, copy rows to new worksheet Closed
Hello, I follow directions very well, but I just don't know enough about Excel to create what I am wanting. I've created a workbook of our off...
-
excel auto filling Closed
https://www.dropbox.com/s/ca7i7n9zj4c4315/test.xlsm can you give me some more help please before pasting the data it should check the bo...
-
comparing 2 columns extracting different cells Closed
Hello, I have 2 columns of data in Column A and Column B, I want to compare these columns and the numbers in column B that are not in Column A ...
-
VBA code to copy and insert data changing date value Closed
I have an excel template that captures network outages incidences, calculates the minutes of outage by checking the diff between incidence start time ...
-
Locking cell based on criteria - or removing formula once data h Closed
I have a interesting one, which I need help to crack if it is possible. I want to be able to lock a cell once speciifc data has been centre, or cop...
-
change date Locale Closed
I Want to change date format dd-mm-yyyy to dd/mm/yyyy in MS Excel 2003 Please solve my problem urgently
-
Comparing 2 excel reports Closed
Hello, I need to match a payroll report to a vendor bill. The payroll report includes name, deduction amount their relevant information and t...
-
how to convert amount into words in open office excle Closed
Hello, I am using open office excle I want convert amount into word format Plz give me explecation with exp, Configuration: Windows 2...
-
Combining Multiple Word Documents into One Closed
Hello, I have a short and should be simple task, but I want to be certain. I am an idiot and I wrote all the pages in my catalog on (in) seperate...
-
Conditional Formatting: Color of a cell by date AND value Closed
Hello, I am attempting to have a cell change colors based on the amount of time passed since a bill was sent, only if the bill is unpaid. In colum...
-
Compatibility Solved/Closed
Hello, I was just wondering if the free download for Open Office is compatible with Windows 8.1, as I did not see it listed. Thank you and have a gre...
-
Fill data according to other sheet's data Solved/Closed
I have a sheet1 like this: r1 text1 text 1 r2 text1 textx 2 r2 text1 textx 0 r3 text2 texty 1 r4 text2 textz 1 r5 text2 textx 3 r6 text2 text...
-
,">"&0),"") at the end of a countif formula Closed
Hello, I have the below formula, but don't understand why the last part of it ,">"&0),""). Can somebody clarify pls? =IF(COUNTIF($AJ$2:$AJ9,$AJ...
-
conditional formatting in Excel 2010 Closed
Hi, I'm wondering if there is a way to tell Excel use conditional formatting on a cell when/if another cell has conditional formatting to it. Basical...
-
About dated if function Closed
Hey again, i had to use this formula to find the deference between two dates =DATEDIF(E4,F4,"d")+(1) it shows me (1) in all the empty cells...
-
compare values in multiple columns in excel Closed
Hello, i have multiple columns with numerical values and I need to determine which one is the smallest value by row is there a function that can he...
-
black screen with message Closed
My computer says disk boot failure, insert system disk and press enter. My computer is 8 years old and I do not have a disk for the vista windows pack...
-
Black screen with massege, Disc boot failure insert Closed
Hello, My computer says disk boot failure, insert system disk and press enter. What should I do? Thank you, Charlotte Configuration: Windows ...
-
Excel Macro to list current costs by code and extract previous Closed
Hello, I am looking for a macro, that will list one set of values by a code and then move a precious list of codes with values and subtract one from t...
-
Lan computers sending messages to each other without internet Closed
Hello, Could you please help me with a problem. I have computers running windows 7 and networked and am trying to get a way to train users to use ...
-
macro gives me expected en sub error Closed
Hello, I have the below macro, but it gives me compile error expected end sub. This macro below I have copied and paste hoping it would work becau...
-
conditional formatting excel drop down list Closed
Hello, I want to color code a drop down list in excel? I have done conditional fomatting on each cell in the list, it is a text list, but not wor...
-
excel-create a compounding interest calculater Solved/Closed
I want to work out the after three months dates between two dates ex: 01/03/2013 as the starting date and today date as the last date.
-
data arrangement problem (very difficult) Closed
I have a lot of data A1:CET100 This is the initial set of values that I have A1 B1 C1 ... CET1 A2 B2 C2 ... CET2 . ...
-
Type name into a cell removing name from another unique list Closed
Is there a way to manually type a name into a cell on one worksheet, that removes that name/entry from another large list, with unique names, whether ...
-
Merge the selected sheets data into one data Closed
I am having 5 sheets (Name as Ricky, Rambo, Input, Output, Time) data combined into combined sheet , for this i need to run through macro Please hel...
-
Comparing values in multiple columns Closed
Hi All, Would appreciate if you people can help me, as am not that excel expert :( My argument is like this- Column: 1. 2. 3...
