The discussions
Copying a conditional format to other cells...
Hello, I have set a formula to calculate how many days between two dates i.e. Date in A5 - date in A4 +1 = number of days in A6. Pretty simple ok....
Excell 2013 - conditional formatting using a formula- apply rule
SolvedHello, I am trying to do the following : A1:A100 ==> dates B2:B100 ==> dates 1) apply conditional formatting to columns C1:BB1 if the containe...
Excel formula display in cell
SolvedHello, Apologize if the question is too stupid. In cell A4, it contains a formula =Sum(A1:B3)+A3/B2. How to display the formula in cell A6 for this...
About open office
Hello! How I,m donwloading full version Open office
Gorandhaka
Hello, i want to open new account Configuration: Windows 7 / Chrome 41.0.2272.101
Day of week and date in same cell, autofill rest of month?
Hello, Is it possible to put day of week and date in the same cell in Excel 2004, and then autofill down for the rest of the month? I have tried ...
How to open a prn file in office/word 2010
Solved/ClosedHello, How do you open a PRN file to see how it converted? I only want to open the document to see how it converted, not print it. I used Window...
Macro code to copy and past in new sheet last row of data
Hello, I'm trying to write a simple macro to copy in one sheet a selected amount of column data (which varies by size each time) and then paste the...
Convert to mm/dd/yy to dd/mm/yyy
Hello, Pls help how to change mm/dd/yyy to dd/mm/yy in excel. Configuration: Windows / Chrome 41.0.2272.101
Day of week and date in the same cell, then autofill rest of mon
Hello, I would like to know how to put the weekday and date into one cell, as in: Wednesday, 4/1. Then I want autofill to fill the rest of ...
Find and replace a specific number
Hi All, I am new to this, so I hope somebody can help. I have a code CF|0612|1-12 in cell A1. That code is the code for an apartment block we...
Macro for extracting data
I need helping writing a macro to extract data from column A and input into column B. Example data = 13A:123456789:V1 and what I need is the data betw...
Cell color
Hello, I have a worksheet with various dollar values in it. I want to write a formula to add all the cells that are a certain color (green or yel...
Some cell date could not change
SolvedHello, I was having the same problem and this solution worked But Some cell Date Could not change Configuration: Windows XP / Firefox 36.0
Show formula with example
Hello, hi sir/madam...i am doing some work with the students result in excel...but i faced a problem..it is simple but i havn't got that in my mind....
Comparing data in 3 columns on a microsoft excel spreadsheet
SolvedWould be really grateful for some help. I have 3 columns of different lengths with email addresses in them and I want to see all instances where th...
Formula which calculates the percentage of these cells
I was wondering if anyone could help me with a formula for some work I am currently doing. I have a set of data (numbers ranging from -0.8 to + 0.7) w...
Excel 2013 formula - maybe if formula?
SolvedI have a list of names in Excel and I need to put their supervisor name in the cell to the right of each name. I would like to find a formula that wi...
Epson t13 ink pads end
The printers ink pads are at the end of thier service life. please contact epson support
Copying data based on number from one sheet to another
Hello, I would really like a VBA CODE which would help me to copy Data based on number from one sheet to another: So I have 5 projects(sheet1,s...
Call equation according to choice
Hello, When choosing from a data validation list, i want some cells to import specified equations according to the choice selected from the list ...
Compare sheet 1 and 2 and copy to sheet 3
Hi, I got this code which compare sheet 1 and 2 and copy to sheet 3 data with similar data from 1 and 2. Now what i need is to cell from sheet 2 t...
Date formulas
I am wanting to know how to make a copy of the same spreadsheet many times and when I do I want the date on the spreadsheet to change automatically ea...
Wordnum help needed
SolvedHello, I hope somebody can help. I use WordNum to spell the result of a formula and it gives me 4 digits (spelled) after the point. I need just ...
Comparing 2 cells to get an answer
Hello, I am a primary school teacher and I really really need helps on this matter. Excel is something new to me and my boss asked me to help him ...
Cell format
SolvedHi Guys, I'm new here, I have a very limited knowledge about excel. My superior has asked me to do some sort of Advanced Cell Formatting in our per...
Linked cells to excel
Hello, I have a word document that has a section linked to a excel worksheet, all working ok (e.i. the values are updating correctly) but it dosent ...
Filter on multiple rows - two rows or four?
Hello, How can I apply filter on multiple rows? The first row got different detailed header, the second one and the third one. rgds, Mbime. ...
Formula or macro to combine data
I have data in two columns that I am trying to combine, but keep in separate columns. So I have: A 1 B 2 C 3 And I need this: A 1 A 2 A 3...
Text-to-text equals number
SolvedHi.. I'm looking for a solution for a dilemma I'm in.. On sheet 1 I have a dropdown box in cell A1 and B1 is an emtpy cell. On sheet 2 I have the...
Formula, blank cell
SolvedSorry in advance if this has been asked but I can't see anything. Excel 2010 I have a cell that will contain a date then the next adjacent cell the...
Convert date into words(english) in excel 2003, 2007 or 2010
SolvedHello i want to know how to convert date into words(english) in excel 2003, 2007 or 2010 for eg. 22.04.2010 - convert it into Twenty Second April T...
Conditional formating is applied based on date in two cells
SolvedHi everyone I'm using Excel 2010 and applying conditional formating on dates in Column E. I don't want the formatting to be applied if there is the f...
Vba copying and pasting loop with if then
Hi forum, I am really new to VBA for Excel. I wanted to create a macro far beyond my skill and hit a brick wall. I really wish I can attach a sa...
Inventory set-up
Dear all, I have been struggling with setting up my inventory process in excel. So I have a live stock with my total actual unprinted t-shirts...
Excel macro experts out there?
Hello all, I am very new to writing macros and was looking for some guidance in writing one for patient blood volume. What I am looking to do is...
Need to automatically copy data from one sheet to another
Hello, I have a worksheet titled "Pipeline Data". There is a header row and data from A-R. In column K there are dates of the contract solicitati...
Password
Hello, i have forgot my password please me new password
Invoice numbers
Hello, Would you be able to tell me if the second code has to be in it's own box or can I put it right under the top code to increment the next genera...
Excel - help please! drop down and data filling
SolvedGood morning/afternoon. I was hoping you would be able to assist me with a query please. Currently my team is using 2 spreadsheets, one that li...
Auto copy-paste from one spreadsheet to another
Hello. First of all thank you that you are willing to help. This is much appreciated! I am new to Excel (but I know how to apply macros) so ple...
Trying to have the current date go into one cell (a1)
SolvedHello, I'm trying to have the current date go into one cell (A1) when an order number is entered in another cell (A2) but don't want the date to aut...
A strange range question ...
SolvedHi guys Im back with a new twist on one of my old problems. I had help earlier and one of you kind people hellped me out with a solution (thanks ag...
To identify repeated values
Hello, Please help with this issue. I have a list of players in column 1 and column 2. I would like to know, for instance how many times "Allan"(pl...
Outlook 2007 mail sending problem win7
is the following works for all for exmpl gmail,hotmail or any other David Jun 28, 2009 07:49PM Hey guys, this worked for me! If you use Out...
Is there a percentage formula!
Hello, Is there a percentage formula!!? e.g. If you enter a100 in a cell and that amount to appear 30% in one cell and 70% in another !! Thank y...
Highlight any dates that exceed a target date
Hello, Wonder if someone can help me, I have a sheet that i want to calculate and highlight if one date is beyond another then highlight it red IF...
How to convert number in word in excel
how to convert number in word in Excel
Excel formula
Hello, I'm looking for a simple formula to convert numbers in to words in Excel 2007. with example. Configuration: Windows 7 / Internet Explo...
Sheet one items transferred to sheet two.
I have few items in sheet one and want to transfer to sheet two. Please help me.. Sheet 1 consist of:- S.no Tanker Date Voucher ...