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

1 reply Last reply on 26 Mar 2015 by
TrowaD

Excell 2013 - conditional formatting using a formula- apply rule

 Solved

Hello, I am trying to do the following : A1:A100 ==> dates B2:B100 ==> dates 1) apply conditional formatting to columns C1:BB1 if the containe...

2 replies Last reply on 26 Mar 2015 by
Manos

Excel formula display in cell

 Solved

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

6 replies Last reply on 25 Mar 2015 by
rc

About open office

Hello! How I,m donwloading full version Open office

1 reply Last reply on 25 Mar 2015 by
xpcman

Gorandhaka

Hello, i want to open new account Configuration: Windows 7 / Chrome 41.0.2272.101

1 reply Last reply on 25 Mar 2015 by
BunoCS

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

1 reply Last reply on 25 Mar 2015 by
venkat1926

How to open a prn file in office/word 2010

 Solved/Closed

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

Last reply on 25 Mar 2015 by
Aduka

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

1 reply Last reply on 24 Mar 2015 by
vcoolio

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

1 reply Last reply on 24 Mar 2015 by
TrowaD

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

1 reply Last reply on 24 Mar 2015 by
TrowaD

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

1 reply Last reply on 24 Mar 2015 by
TrowaD

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

1 reply Last reply on 24 Mar 2015 by
TrowaD

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

1 reply Last reply on 24 Mar 2015 by
TrowaD

Some cell date could not change

 Solved

Hello, I was having the same problem and this solution worked But Some cell Date Could not change Configuration: Windows XP / Firefox 36.0

1 reply Last reply on 24 Mar 2015 by
TrowaD

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

3 replies Last reply on 24 Mar 2015 by
TrowaD

Comparing data in 3 columns on a microsoft excel spreadsheet

 Solved

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

2 replies Last reply on 23 Mar 2015 by
daniz39

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

1 reply Last reply on 23 Mar 2015 by
TrowaD

Excel 2013 formula - maybe if formula?

 Solved

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

2 replies Last reply on 23 Mar 2015 by
Cookie5

Epson t13 ink pads end

The printers ink pads are at the end of thier service life. please contact epson support

1 reply Last reply on 22 Mar 2015 by
xpcman

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

1 reply Last reply on 21 Mar 2015 by
MaxStart

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

1 reply Last reply on 21 Mar 2015 by
MaxStart

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

1 reply Last reply on 21 Mar 2015 by
venkat1926

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

4 replies Last reply on 21 Mar 2015 by
Laura

Wordnum help needed

 Solved

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

7 replies Last reply on 19 Mar 2015 by
TrowaD

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

1 reply Last reply on 18 Mar 2015 by
MaxStart

Cell format

 Solved

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

3 replies Last reply on 17 Mar 2015 by
MaxStart

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

2 replies Last reply on 17 Mar 2015 by
Computertech

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

6 replies Last reply on 17 Mar 2015 by
venkat1926

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

1 reply Last reply on 17 Mar 2015 by
Mbime

Text-to-text equals number

 Solved

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

5 replies Last reply on 17 Mar 2015 by
kriswiberg

Formula, blank cell

 Solved

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

3 replies Last reply on 17 Mar 2015 by
MaxStart

Convert date into words(english) in excel 2003, 2007 or 2010

 Solved

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

1 reply Last reply on 17 Mar 2015 by
MaxStart

Conditional formating is applied based on date in two cells

 Solved

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

6 replies Last reply on 16 Mar 2015 by
TrowaD

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

1 reply Last reply on 16 Mar 2015 by
venkat1926

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

2 replies Last reply on 15 Mar 2015 by
Simeon

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

4 replies Last reply on 15 Mar 2015 by
MaxStart

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

6 replies Last reply on 14 Mar 2015 by
vcoolio

Password

Hello, i have forgot my password please me new password

1 reply Last reply on 13 Mar 2015 by
Ambucias

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

1 reply Last reply on 13 Mar 2015 by
vcoolio

Excel - help please! drop down and data filling

 Solved

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

4 replies Last reply on 13 Mar 2015 by
CatherineGPR

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

2 replies Last reply on 12 Mar 2015 by
joshdupler

Trying to have the current date go into one cell (a1)

 Solved

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

3 replies Last reply on 12 Mar 2015 by
dbmich

A strange range question ...

 Solved

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

8 replies Last reply on 11 Mar 2015 by
BrianGreen

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

1 reply Last reply on 11 Mar 2015 by
cmarzahn

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

1 reply Last reply on 11 Mar 2015 by
xpcman

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

1 reply Last reply on 11 Mar 2015 by
cmarzahn

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

3 replies Last reply on 10 Mar 2015 by
cmarzahn

How to convert number in word in excel

how to convert number in word in Excel

3 replies Last reply on 10 Mar 2015 by
Computertech

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

1 reply Last reply on 10 Mar 2015 by
kieferschild

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

22 replies Last reply on 10 Mar 2015 by
vcoolio
Results 3201 - 3250 out of a total of 12,269